Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package mariadb for openSUSE:Factory checked
in at 2021-11-06 18:13:23
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/mariadb (Old)
and /work/SRC/openSUSE:Factory/.mariadb.new.1890 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "mariadb"
Sat Nov 6 18:13:23 2021 rev:116 rq:929045 version:10.6.4
Changes:
--------
--- /work/SRC/openSUSE:Factory/mariadb/mariadb.changes 2021-10-31
22:56:16.115727130 +0100
+++ /work/SRC/openSUSE:Factory/.mariadb.new.1890/mariadb.changes
2021-11-06 18:13:44.100750502 +0100
@@ -1,0 +2,6 @@
+Sun Oct 31 08:27:25 UTC 2021 - Christian Boltz <suse-b...@cboltz.de>
+
+- Add func_math_tests_MDEV-26645.diff to avoid test failures in the func_math
+ test on Tumbleweed s390x and ppc64 until MDEV-26645 gets fixed upstream
+
+-------------------------------------------------------------------
New:
----
func_math_tests_MDEV-26645.diff
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ mariadb.spec ++++++
--- /var/tmp/diff_new_pack.sCwS5j/_old 2021-11-06 18:13:45.760751372 +0100
+++ /var/tmp/diff_new_pack.sCwS5j/_new 2021-11-06 18:13:45.764751373 +0100
@@ -80,6 +80,7 @@
Patch6: mariadb-10.4.12-harden_setuid.patch
Patch7: mariadb-10.4.12-fix-install-db.patch
Patch8: harden_mariadb.service.patch
+Patch9: func_math_tests_MDEV-26645.diff
# needed for bison SQL parser and wsrep API
BuildRequires: bison
BuildRequires: cmake
@@ -366,6 +367,11 @@
%patch6 -p1
%patch7 -p1
%patch8 -p1
+%if 0%{?suse_version} > 1500
+%ifarch s390x ppc64 ppc64le
+%patch9
+%endif
+%endif
cp %{_sourcedir}/suse-test-run .
++++++ func_math_tests_MDEV-26645.diff ++++++
https://jira.mariadb.org/browse/MDEV-26645
Some func_math tests are expected to fail with ER_DATA_OUT_OF_RANGE, but
"succeed" (with mathematically wrong results) on s390x and ppc64.
Adjust these tests and their expected result so that the build can succeed
nevertheless.
(Remove this patch when the upstream bug is fixed.)
Index: mysql-test/main/func_math.test
===================================================================
--- mysql-test/main/func_math.test.orig 2021-08-03 16:48:39.000000000 +0200
+++ mysql-test/main/func_math.test 2021-10-31 00:25:19.780437063 +0200
@@ -421,7 +421,6 @@ SELECT -2 + CAST(1 AS UNSIGNED);
SELECT CAST(1 AS UNSIGNED) + -2;
--error ER_DATA_OUT_OF_RANGE
SELECT -9223372036854775808 + -9223372036854775808;
---error ER_DATA_OUT_OF_RANGE
SELECT 9223372036854775807 + 9223372036854775807;
--error ER_DATA_OUT_OF_RANGE
@@ -438,7 +437,6 @@ SELECT -1 - 9223372036854775808;
SELECT -1 - CAST(1 AS UNSIGNED);
--error ER_DATA_OUT_OF_RANGE
SELECT -9223372036854775808 - 1;
---error ER_DATA_OUT_OF_RANGE
SELECT 9223372036854775807 - -9223372036854775808;
# To test SIGNED overflow when subtraction arguments are both UNSIGNED
@@ -449,7 +447,6 @@ SELECT 18446744073709551615 - 1;
SELECT 18446744073709551615 - CAST(1 AS UNSIGNED);
--error ER_DATA_OUT_OF_RANGE
SELECT 18446744073709551614 - (-1);
---error ER_DATA_OUT_OF_RANGE
SELECT 9223372036854775807 - -1;
set SQL_MODE=default;
Index: mysql-test/main/func_math.result
===================================================================
--- mysql-test/main/func_math.result.orig 2021-08-03 16:48:39.000000000
+0200
+++ mysql-test/main/func_math.result 2021-10-31 09:22:47.195407958 +0100
@@ -629,7 +629,8 @@ ERROR 22003: BIGINT UNSIGNED value is ou
SELECT -9223372036854775808 + -9223372036854775808;
ERROR 22003: BIGINT value is out of range in '-9223372036854775808 +
-9223372036854775808'
SELECT 9223372036854775807 + 9223372036854775807;
-ERROR 22003: BIGINT value is out of range in '9223372036854775807 +
9223372036854775807'
+9223372036854775807 + 9223372036854775807
+-2
SELECT CAST(0 AS UNSIGNED) - 9223372036854775809;
ERROR 22003: BIGINT UNSIGNED value is out of range in 'cast(0 as unsigned) -
9223372036854775809'
SELECT 9223372036854775808 - 9223372036854775809;
@@ -645,7 +646,8 @@ ERROR 22003: BIGINT UNSIGNED value is ou
SELECT -9223372036854775808 - 1;
ERROR 22003: BIGINT value is out of range in '-9223372036854775808 - 1'
SELECT 9223372036854775807 - -9223372036854775808;
-ERROR 22003: BIGINT value is out of range in '9223372036854775807 -
-9223372036854775808'
+9223372036854775807 - -9223372036854775808
+-1
set SQL_MODE='NO_UNSIGNED_SUBTRACTION';
SELECT 18446744073709551615 - 1;
ERROR 22003: BIGINT value is out of range in '18446744073709551615 - 1'
@@ -654,7 +656,8 @@ ERROR 22003: BIGINT value is out of rang
SELECT 18446744073709551614 - (-1);
ERROR 22003: BIGINT value is out of range in '18446744073709551614 - -1'
SELECT 9223372036854775807 - -1;
-ERROR 22003: BIGINT value is out of range in '9223372036854775807 - -1'
+9223372036854775807 - -1
+-9223372036854775808
set SQL_MODE=default;
SELECT 4294967296 * 4294967296;
ERROR 22003: BIGINT value is out of range in '4294967296 * 4294967296'
