Unit test Tests_DB_Charset::test_strip_invalid_text fails with MariaDB 10.1

[netweb]

Tests_DB_Charset::test_strip_invalid_text

1) Tests_DB_Charset::test_strip_invalid_text with data set #41 (array(array('big5', 'a�@ba�@ba�@ba�@ba�@ba�@ba�@ba...@ba�@b', array('byte', 10))), array(array('big5', 'a�@ba�@ba', array('byte', 10))), 'big5_byte_length')
big5_byte_length
Failed asserting that Array &0 (
    0 => Array &1 (
        'charset' => 'big5'
        'value' => 'a�@ba�@ba?'
        'length' => Array &2 (
            'type' => 'byte'
            'length' => 10
        )
    )
) is identical to Array &0 (
    0 => Array &1 (
        'charset' => 'big5'
        'value' => 'a�@ba�@ba'
        'length' => Array &2 (
            'type' => 'byte'
            'length' => 10
        )
    )
).

https://core.trac.wordpress.org/browser/trunk/tests/phpunit/tests/db/charset.php#L349

[vdwijngaert]

Can confirm, I am running MariaDB 10.1.9 and have the same problem. Anyone looking into this?

[swissspidy]

Still happening with 10.1.12. A bit annoying because I use MariaDB on my local machine and usually run the tests there when working on patches.

Is there something we can do about it on our side?

[netweb]

#36547 was marked as a duplicate.

[onnimonni]

I can also confirm this with with MariaDB version:

10.1.12-MariaDB-1~jessie

[ocean90]

Any objections for skipping this data set when running MariaDB?

[pento]

I'm inclined to just skip it. MariaDB have shown no interest in fixing it, I don't think it's possible for us to work around it, and we haven't had an reports of this behaviour causing problems on production sites.

[boonebgorges]

Let's skip, with a reference back to this ticket for our future selves. I, for one, am tired of seeing this failure locally.

[ocean90]

33171.patch​ skips the failing data set if the MySQL version contains MariaDB.

[pento]

:thumbsup:

[boonebgorges]

In 38843:

Tests: Skip strip_invalid_text() test for big5 charset on MariaDB.

MariaDB doesn't support the tested configuration.

Props ocean90.
Fixes #33171.