Incomplete accounting for MariaDB version being prefixed with '5.5.5-' on older PHP versions

[maximumsoftware]

In the file wp-includes/class-wpdb.php, function has_cap, near Account for MariaDB version being prefixed with '5.5.5-' on older PHP versions, there is a possible issue with PHP_VERSION_ID < 80016 // PHP 8.0.15 or older..

The problem is that if you look at ​https://www.php.net/ChangeLog-8.php, you can see that GH-7972 is fixed twice, once in 8.0.16 and second time in 8.1.3, which means the prefix is still there in 8.1.0 - 8.1.2. So, PHP_VERSION_ID < 80016 should actually be (PHP_VERSION_ID < 80016 || (PHP_VERSION_ID >= 80100 && PHP_VERSION_ID < 80103)).

• Update the MariaDB prefix condition to include the PHP version that does not include the stripped version.

Trac ticket: https://core.trac.wordpress.org/ticket/64332

[hbhalodia]

Hi @SergeyBiryukov @maximumsoftware, I have addded the PR with the required updates. Can you please help review the same.

Thank You,

[SergeyBiryukov]

In 61349:

Database: Further correct MariaDB version check in wpdb::has_cap().

On older PHP versions, MariaDB version is reported with the 5.5.5- prefix, e.g. 5.5.5-10.6.24-MariaDB.

This includes PHP 8.0.15 or earlier, as well as PHP 8.1.0—8.1.2, which was not accounted for previously.

This commit updates the condition for removing the 5.5.5- prefix to include PHP 8.1.0—8.1.2.

Follow-up to [54384].

Props maximumsoftware, hbhalodia, SergeyBiryukov.
Fixes #64332.