[wp-trac] [WordPress Trac] #30462: Test multiple MySQL versions on Travis

[WordPress Trac]

#30462: Test multiple MySQL versions on Travis
---------------------------------------+------------------------------
 Reporter:  pento                      |       Owner:  (none)
     Type:  enhancement                |      Status:  new
 Priority:  normal                     |   Milestone:  Awaiting Review
Component:  Build/Test Tools           |     Version:
 Severity:  normal                     |  Resolution:
 Keywords:  needs-refresh needs-patch  |     Focuses:
---------------------------------------+------------------------------

Comment (by desrosj):

 With the introduction of the local Docker environment (and the current
 move to GitHub Actions), this should be ''much'' simpler.

 I have opened #51744 to add the ability to change database software. After
 that change is made, adding test jobs for various versions of MariaDB
 should not be a problem.

 We'll need to come up with the combinations that we'd like to test
 against. Rough first pass based on a [https://github.com/desrosj
 /wordpress-develop/actions/runs/354995496 test workflow run] I set up
 (though these combinations may not be ideal or indicate the actual
 support):

 - MySQL 5.6
 - MySQL 5.7
 - MySQL 8.0
 - MariaDB 10.1 (PHP 5.6.20 only)
 - MariaDB 10.2-10.5 (PHP 5.6.20-8.0)

 I'd also like to get a page similar to the
 [https://make.wordpress.org/core/handbook/references/phpunit-
 compatibility-and-wordpress-versions/ PHPUnit] and
 [https://make.wordpress.org/core/handbook/references/php-compatibility-
 and-wordpress-versions/ PHP version] support set up for MySQL/MariaDB
 support in the handbook once we figure out the support matrix.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/30462#comment:23>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform