autopkgtest: Invalid DATETIME test fails with mysql >= 8.0.24

[Paride Legovini]

[Impact]

The test suite is failing when running against MySQL >= 8.0.24 with:

---------------------------------------------

Failures:

  1) Mysql2::Result row data type mapping should raise an error given an invalid DATETIME
     Failure/Error:
       expect { @client.query("SELECT CAST('1972-00-27 00:00:00' AS DATETIME) as bad_datetime").each }.to \
         raise_error(Mysql2::Error, "Invalid date in field 'bad_datetime': 1972-00-27 00:00:00")

       expected Mysql2::Error with "Invalid date in field 'bad_datetime': 1972-00-27 00:00:00" but nothing was raised
     # ./spec/mysql2/result_spec.rb:321:in `block (3 levels) in <top (required)>'

  2) Mysql2::Statement row data type mapping should raise an error given an invalid DATETIME
     Failure/Error:
       expect { @client.query("SELECT CAST('1972-00-27 00:00:00' AS DATETIME) as bad_datetime").each }.to \
         raise_error(Mysql2::Error, "Invalid date in field 'bad_datetime': 1972-00-27 00:00:00")

       expected Mysql2::Error with "Invalid date in field 'bad_datetime': 1972-00-27 00:00:00" but nothing was raised
     # ./spec/mysql2/statement_spec.rb:478:in `block (3 levels) in <top (required)>'

---------------------------------------------

This regression was introduced by the following uploads:

    mysql-8.0 (8.0.25-0ubuntu0.20.04.1) focal-security;
    mysql-8.0 (8.0.25-0ubuntu0.21.04.1) hirsute-security;

According to the MySQL release notes (https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-24.html):

    Using CAST() on a DATE or DATETIME value in an INSERT statement
    raised a warning for "0000-00-00" and "2000-02-31", but not for
    "2000-01-00" or "2000-00-01". Now a warning is shown in each of
    these cases also.

but the ruby-mysql2 tests rely on the old behavior.

This is preventing Focal and Hirsute SRUs from migrating when they trigger a ruby-mysql2 autopkgtest run.

[Test Plan]

Once the autopkgtest pass the fix can be considered verified.

[Where problems could occur]

The SRU only touches test code, so this upload won't change the behavior of the package in any user visible way.

As this is a test fix I'm tagging this bug as block-proposed.

[Development Fix]

Already fixed by the security team by disabling the bad test.

I reported the bug upstream, so it's likely that one of the next upstream releases will ship with a fix, and we'll then be able to drop the delta.

This is not a bug in Debian *yet* because Debian still ships mysql-8.0 8.0.23, the latest version with the old behavior.

[Stable Fix]

What it's being proposed here it the same fix uploaded to the devel release (Impish) by the security team, with no changes.

[Paride Legovini (paride)]

This regression was introduced by the following upload:

  mysql-8.0 (8.0.25-0ubuntu0.20.04.1) focal-security;

which was not subject to the stricter SRU migration checks and was then copied into focal-updates.

[Paride Legovini (paride)]

Fix Released in Impish by 0.5.2-1ubuntu4.

[Brian Murray (brian-murray)]

Hello Paride, or anyone else affected,

Accepted ruby-mysql2 into hirsute-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/ruby-mysql2/0.5.2-1ubuntu3.21.04.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-hirsute to verification-done-hirsute. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-hirsute. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Brian Murray (brian-murray)]

Hello Paride, or anyone else affected,

Accepted ruby-mysql2 into focal-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/ruby-mysql2/0.5.2-1ubuntu3.20.04.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-focal to verification-done-focal. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-focal. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Paride Legovini (paride)]

Verified via local autopkgtest run against the -proposed package.

[Brian Murray (brian-murray)]

The Hirsute Hippo has reached End of Life, so this bug will not be fixed for that release.