Package: mysql-8.0 Version: 8.0.36-2 Severity: serious Tags: patch Justification: ftbfs User: ubuntu-de...@lists.ubuntu.com Usertags: origin-ubuntu noble ubuntu-patch
Dear maintainers, With the switch to 64-bit time_t on 32-bit archs, mysql-8.0 now fails to build from source because of a test that *checks* that only 32-bit time is supported: [...] [ 57%] main.func_unixtime_32bits w4 [ fail ] Test ended at 2024-03-09 05:01:27 CURRENT_TEST: main.func_unixtime_32bits --- /<<PKGBUILDDIR>>/mysql-test/r/func_unixtime_32bits.result 2023-12-12 21:09:36.000000000 +0300 +++ /<<PKGBUILDDIR>>/builddir/mysql-test/var/4/log/func_unixtime_32bits.reject 2024-03-09 08:01:27.450443865 +0300 @@ -12,7 +12,7 @@ 2038-01-19 06:14:07 select from_unixtime(2147483648); from_unixtime(2147483648) -NULL +2038-01-19 06:14:08 select from_unixtime(0); from_unixtime(0) 1970-01-01 03:00:00 @@ -32,26 +32,26 @@ 2147483647 select unix_timestamp(from_unixtime(2147483648)); unix_timestamp(from_unixtime(2147483648)) -NULL +2147483648 [...] - the logfile can be found in '/<<PKGBUILDDIR>>/builddir/mysql-test/var/log/main.func_unixtime_32bits/func_unixtime_32bits.log' Test main.func_unixtime_32bits has failed 2 times, no more retries. [...] (https://launchpad.net/ubuntu/+source/mysql-8.0/8.0.36-2/+build/27892969) Please find attached a patch for this issue which I have uploaded to Ubuntu. Thanks, -- Steve Langasek Give me a lever long enough and a Free OS Debian Developer to set it on, and I can move the world. Ubuntu Developer https://www.debian.org/ slanga...@ubuntu.com vor...@debian.org
diff -Nru mysql-8.0-8.0.36/debian/patches/64bit_time_everywhere.patch mysql-8.0-8.0.36/debian/patches/64bit_time_everywhere.patch --- mysql-8.0-8.0.36/debian/patches/64bit_time_everywhere.patch 1969-12-31 16:00:00.000000000 -0800 +++ mysql-8.0-8.0.36/debian/patches/64bit_time_everywhere.patch 2024-03-08 21:59:20.000000000 -0800 @@ -0,0 +1,22 @@ +Description: fix test for 64-bit time_t + i386 is the only architecture where we don't have 64-bit time_t now. + Update the tests accordingly. +Author: Steve Langasek <steve.langa...@ubuntu.com> +Forwarded: no +Last-Update: 2024-03-08 + +Index: mysql-8.0-8.0.36/mysql-test/include/have_32bits_time.inc +=================================================================== +--- mysql-8.0-8.0.36.orig/mysql-test/include/have_32bits_time.inc ++++ mysql-8.0-8.0.36/mysql-test/include/have_32bits_time.inc +@@ -1,8 +1,7 @@ + # see also have_64bits_time.inc + +-let $have_64bit = `SELECT @@version_compile_machine IN +- ('x86_64', 'amd64', 'sparc', 'sparc64', 'arm64', 'aarch64', +- 'ppc64', 'ppc64le', 's390x')`; ++let $have_64bit = `SELECT @@version_compile_machine != 'i686'`; ++ + if ($have_64bit) { + --skip Doesn't support 32 bits UNIX time, only 64 bits + } diff -Nru mysql-8.0-8.0.36/debian/patches/series mysql-8.0-8.0.36/debian/patches/series --- mysql-8.0-8.0.36/debian/patches/series 2024-03-05 06:26:25.000000000 -0800 +++ mysql-8.0-8.0.36/debian/patches/series 2024-03-08 21:55:11.000000000 -0800 @@ -9,3 +9,4 @@ disable_timestamping_test.patch mysql_secure_installation-remove-root-pw-creation.patch suppress_armhf_test_warning.patch +64bit_time_everywhere.patch