Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package mariadb for openSUSE:Factory checked in at 2026-05-05 15:14:47 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/mariadb (Old) and /work/SRC/openSUSE:Factory/.mariadb.new.30200 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "mariadb" Tue May 5 15:14:47 2026 rev:162 rq:1350884 version:11.8.6 Changes: -------- --- /work/SRC/openSUSE:Factory/mariadb/mariadb.changes 2026-04-21 12:43:06.650165048 +0200 +++ /work/SRC/openSUSE:Factory/.mariadb.new.30200/mariadb.changes 2026-05-05 15:15:58.444681485 +0200 @@ -1,0 +2,13 @@ +Mon May 4 13:32:59 UTC 2026 - Antonio Teixeira <[email protected]> + +- Update to 11.8.6: + https://mariadb.com/docs/release-notes/community-server/11.8/11.8.6 + https://mariadb.com/docs/release-notes/community-server/changelogs/11.8/11.8.6 + * fixes for the following security vulnerabilities: + 11.8.6: CVE-2026-32710 (bsc#1260081) +- Update skipped test list +- Add MDEV-38811.patch + * Fixes crash in information_schema.table_constraints when --skip-grant-tables + (bsc#1263153) + +------------------------------------------------------------------- @@ -4,0 +18,6 @@ + +------------------------------------------------------------------- +Thu Feb 19 16:34:28 UTC 2026 - Bernhard Wiedemann <[email protected]> + +- Add 0001-MDEV-38874-Make-tests-pass-after-2030.patch (bsc#1258504) +- Drop %jobs macro for reproducible builds (bsc#1237231) Old: ---- mariadb-11.8.5.tar.gz mariadb-11.8.5.tar.gz.asc New: ---- 0001-MDEV-38874-Make-tests-pass-after-2030.patch MDEV-38811.patch mariadb-11.8.6.tar.gz mariadb-11.8.6.tar.gz.asc ----------(New B)---------- New: - Add 0001-MDEV-38874-Make-tests-pass-after-2030.patch (bsc#1258504) - Drop %jobs macro for reproducible builds (bsc#1237231) New:- Update skipped test list - Add MDEV-38811.patch * Fixes crash in information_schema.table_constraints when --skip-grant-tables ----------(New E)---------- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ mariadb.spec ++++++ --- /var/tmp/diff_new_pack.8w15tz/_old 2026-05-05 15:15:59.904742107 +0200 +++ /var/tmp/diff_new_pack.8w15tz/_new 2026-05-05 15:15:59.904742107 +0200 @@ -52,7 +52,7 @@ # Build with cracklib plugin when cracklib-dict-full >= 2.9.0 is available %define with_cracklib_plugin 0 Name: mariadb -Version: 11.8.5 +Version: 11.8.6 Release: 0 Summary: Server part of MariaDB License: SUSE-GPL-2.0-with-FLOSS-exception @@ -85,6 +85,9 @@ Patch12: mariadb-fix-testsuite-openssl3.2.3.patch # PATCH-FIX-OPENSUSE fix-MDEV-32585.patch boo#1237555 [email protected] -- Fixes potential buffer overflow in get_defaults_options() Patch13: fix-MDEV-32585.patch +# PATCH-FIX-UPSTREAM https://github.com/MariaDB/server/pull/4667 +Patch14: 0001-MDEV-38874-Make-tests-pass-after-2030.patch +Patch15: MDEV-38811.patch # needed for bison SQL parser and wsrep API BuildRequires: bison BuildRequires: cmake @@ -373,6 +376,10 @@ %patch -P 11 -p1 %patch -P 12 -p1 %patch -P 13 -p1 +%ifnarch %{ix86} armv7l armv7hl +%patch -P 14 -p1 +%endif +%patch -P 15 -p1 cp %{_sourcedir}/suse-test-run . @@ -720,7 +727,7 @@ # spider test have been enabled in 10.6 and they fail, skip these tests # mariadb-client cannot connect to the server due to self-signed certificates ./mysql-test-run.pl \ - --parallel=%{?jobs:%{jobs}} \ + --parallel=4 \ --force \ --retry=3 \ --ssl \ ++++++ 0001-MDEV-38874-Make-tests-pass-after-2030.patch ++++++ >From b4493ad53d1d2dbabbfa1c90b933ae42d199ac1a Mon Sep 17 00:00:00 2001 From: "Bernhard M. Wiedemann" <[email protected]> Date: Thu, 19 Feb 2026 15:00:15 +0100 Subject: [PATCH] MDEV-38874: Make tests pass after 2030 Background: As part of my work on reproducible builds for openSUSE, I check that software still gives identical build results in the future. I tested with an offset of +11 years, because that is how long I expect some software will be used in some places. This showed up failing tests in our mariadb package build. See https://reproducible-builds.org/ for why this matters. --- mysql-test/main/mysqldump.result | 42 ++++++++++---------- mysql-test/main/mysqldump.test | 14 +++---- mysql-test/suite/events/events_2.result | 4 +- mysql-test/suite/events/events_2.test | 2 +- mysql-test/suite/versioning/r/sysvars.result | 4 +- mysql-test/suite/versioning/t/insert.test | 2 +- mysql-test/suite/versioning/t/sysvars.test | 2 +- 7 files changed, 35 insertions(+), 35 deletions(-) diff --git a/mysql-test/main/mysqldump.result b/mysql-test/main/mysqldump.result index ec14b283894..2c28406d739 100644 --- a/mysql-test/main/mysqldump.result +++ b/mysql-test/main/mysqldump.result @@ -4688,43 +4688,43 @@ drop table words2; create database first; use first; set time_zone = 'UTC'; -create event ee1 on schedule at '2035-12-31 20:01:23' do set @a=5; +create event ee1 on schedule at '2085-12-31 20:01:23' do set @a=5; Warnings: Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. show events; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation -first ee1 root@localhost UTC ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +first ee1 root@localhost UTC ONE TIME 2085-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci show create event ee1; Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation -ee1 UTC CREATE DEFINER=`root`@`localhost` EVENT `ee1` ON SCHEDULE AT '2035-12-31 20:01:23' ON COMPLETION NOT PRESERVE ENABLE DO set @a=5 latin1 latin1_swedish_ci latin1_swedish_ci +ee1 UTC CREATE DEFINER=`root`@`localhost` EVENT `ee1` ON SCHEDULE AT '2085-12-31 20:01:23' ON COMPLETION NOT PRESERVE ENABLE DO set @a=5 latin1 latin1_swedish_ci latin1_swedish_ci drop database first; create database second; use second; show events; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation -second ee1 root@localhost UTC ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +second ee1 root@localhost UTC ONE TIME 2085-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci show create event ee1; Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation -ee1 UTC CREATE DEFINER=`root`@`localhost` EVENT `ee1` ON SCHEDULE AT '2035-12-31 20:01:23' ON COMPLETION NOT PRESERVE ENABLE DO set @a=5 latin1 latin1_swedish_ci latin1_swedish_ci -create event ee2 on schedule at '2030-12-31 21:01:22' do set @a=5; +ee1 UTC CREATE DEFINER=`root`@`localhost` EVENT `ee1` ON SCHEDULE AT '2085-12-31 20:01:23' ON COMPLETION NOT PRESERVE ENABLE DO set @a=5 latin1 latin1_swedish_ci latin1_swedish_ci +create event ee2 on schedule at '2080-12-31 21:01:22' do set @a=5; Warnings: Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. -create event ee3 on schedule at '2030-12-31 22:01:23' do set @a=5; +create event ee3 on schedule at '2080-12-31 22:01:23' do set @a=5; Warnings: Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. show events; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation -second ee1 root@localhost UTC ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci -second ee2 root@localhost UTC ONE TIME 2030-12-31 21:01:22 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci -second ee3 root@localhost UTC ONE TIME 2030-12-31 22:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +second ee1 root@localhost UTC ONE TIME 2085-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +second ee2 root@localhost UTC ONE TIME 2080-12-31 21:01:22 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +second ee3 root@localhost UTC ONE TIME 2080-12-31 22:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci drop database second; create database third; use third; show events; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation -third ee1 root@localhost UTC ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci -third ee2 root@localhost UTC ONE TIME 2030-12-31 21:01:22 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci -third ee3 root@localhost UTC ONE TIME 2030-12-31 22:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +third ee1 root@localhost UTC ONE TIME 2085-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +third ee2 root@localhost UTC ONE TIME 2080-12-31 21:01:22 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +third ee3 root@localhost UTC ONE TIME 2080-12-31 22:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci drop database third; set time_zone = 'SYSTEM'; use test; @@ -4853,12 +4853,12 @@ DROP DATABASE mysqldump_test_db; # TRUNCATE mysql.event; USE test; -CREATE event e29938 ON SCHEDULE AT '2035-12-31 20:01:23' DO SET @bug29938=29938; +CREATE event e29938 ON SCHEDULE AT '2085-12-31 20:01:23' DO SET @bug29938=29938; Warnings: Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. SHOW EVENTS; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation -test e29938 root@localhost SYSTEM ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci +test e29938 root@localhost SYSTEM ONE TIME 2085-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci TRUNCATE mysql.event; SHOW EVENTS; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation @@ -4954,7 +4954,7 @@ Bug #34861 - mysqldump with --tab gives weird output for triggers. CREATE TABLE t1 (f1 INT); CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW SET @f1 = 1; CREATE PROCEDURE pr1 () SELECT "Meow"; -CREATE EVENT ev1 ON SCHEDULE AT '2030-01-01 00:00:00' DO SELECT "Meow"; +CREATE EVENT ev1 ON SCHEDULE AT '2080-01-01 00:00:00' DO SELECT "Meow"; Warnings: Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. @@ -4963,7 +4963,7 @@ Trigger Event Table Statement Timing Created sql_mode Definer character_set_clie tr1 UPDATE t1 SET @f1 = 1 BEFORE # root@localhost latin1 latin1_swedish_ci latin1_swedish_ci SHOW EVENTS; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation -test ev1 root@localhost SYSTEM ONE TIME 2030-01-01 00:00:00 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +test ev1 root@localhost SYSTEM ONE TIME 2080-01-01 00:00:00 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci SELECT name,body FROM mysql.proc WHERE NAME = 'pr1'; name body pr1 SELECT "Meow" @@ -4991,7 +4991,7 @@ Trigger Event Table Statement Timing Created sql_mode Definer character_set_clie tr1 UPDATE t1 SET @f1 = 1 BEFORE # root@localhost latin1 latin1_swedish_ci latin1_swedish_ci SHOW EVENTS; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation -test ev1 root@localhost SYSTEM ONE TIME 2030-01-01 00:00:00 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci +test ev1 root@localhost SYSTEM ONE TIME 2080-01-01 00:00:00 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci SELECT name,body FROM mysql.proc WHERE NAME = 'pr1'; name body pr1 SELECT "Meow" @@ -5766,7 +5766,7 @@ CREATE TRIGGER `trig one` BEFORE INSERT ON `tab one` FOR EACH ROW SET NEW.a = 1; CREATE EVENT `event -one` ON SCHEDULE AT '2030-01-01 00:00:00' DO SET @a=5; +one` ON SCHEDULE AT '2080-01-01 00:00:00' DO SET @a=5; Warnings: Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. SHOW TABLES FROM bug25717383; @@ -6942,7 +6942,7 @@ DROP DATABASE test1; create function f1() returns int return 1; create function f2() returns int return 2; update mysql.proc set body='return no_such_var' where db='test' and name='f1'; -create event e1 on schedule every 1 year starts '2030-01-01' do select 1; +create event e1 on schedule every 1 year starts '2080-01-01' do select 1; Warnings: Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. update mysql.event set body ='select not_a_value' where db='test' and name='e1'; @@ -6970,7 +6970,7 @@ DELIMITER ;; /*!50003 SET sql_mode = '' */ ;; /*!50003 SET @saved_time_zone = @@time_zone */ ;; /*!50003 SET time_zone = 'SYSTEM' */ ;; -/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`localhost`*/ /*!50106 EVENT `e1` ON SCHEDULE EVERY 1 YEAR STARTS '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO select not_a_value */ ;; +/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`localhost`*/ /*!50106 EVENT `e1` ON SCHEDULE EVERY 1 YEAR STARTS '2080-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO select not_a_value */ ;; /*!50003 SET time_zone = @saved_time_zone */ ;; /*!50003 SET sql_mode = @saved_sql_mode */ ;; /*!50003 SET character_set_client = @saved_cs_client */ ;; diff --git a/mysql-test/main/mysqldump.test b/mysql-test/main/mysqldump.test index 340f20a4a51..0e6bab151a6 100644 --- a/mysql-test/main/mysqldump.test +++ b/mysql-test/main/mysqldump.test @@ -1788,7 +1788,7 @@ use first; set time_zone = 'UTC'; ## prove one works (with spaces and tabs on the end) -create event ee1 on schedule at '2035-12-31 20:01:23' do set @a=5; +create event ee1 on schedule at '2085-12-31 20:01:23' do set @a=5; show events; show create event ee1; --exec $MYSQL_DUMP --default-character-set=utf8mb4 --events first > $MYSQLTEST_VARDIR/tmp/bug16853-1.sql @@ -1803,8 +1803,8 @@ show create event ee1; ## prove three works (with spaces and tabs on the end) # start with one from the previous restore -create event ee2 on schedule at '2030-12-31 21:01:22' do set @a=5; -create event ee3 on schedule at '2030-12-31 22:01:23' do set @a=5; +create event ee2 on schedule at '2080-12-31 21:01:22' do set @a=5; +create event ee3 on schedule at '2080-12-31 22:01:23' do set @a=5; show events; --exec $MYSQL_DUMP --default-character-set=utf8mb4 --events second > $MYSQLTEST_VARDIR/tmp/bug16853-2.sql drop database second; @@ -1912,7 +1912,7 @@ DROP DATABASE mysqldump_test_db; TRUNCATE mysql.event; USE test; -CREATE event e29938 ON SCHEDULE AT '2035-12-31 20:01:23' DO SET @bug29938=29938; +CREATE event e29938 ON SCHEDULE AT '2085-12-31 20:01:23' DO SET @bug29938=29938; SHOW EVENTS; --exec $MYSQL_DUMP --default-character-set=utf8mb4 --skip-events --all-databases > $MYSQLTEST_VARDIR/tmp/bug29938.sql @@ -2057,7 +2057,7 @@ SET @@GLOBAL.CONCURRENT_INSERT = @OLD_CONCURRENT_INSERT; CREATE TABLE t1 (f1 INT); CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW SET @f1 = 1; CREATE PROCEDURE pr1 () SELECT "Meow"; -CREATE EVENT ev1 ON SCHEDULE AT '2030-01-01 00:00:00' DO SELECT "Meow"; +CREATE EVENT ev1 ON SCHEDULE AT '2080-01-01 00:00:00' DO SELECT "Meow"; --echo --replace_column 6 # @@ -2519,7 +2519,7 @@ one` BEFORE INSERT ON `tab one` FOR EACH ROW SET NEW.a = 1; CREATE EVENT `event -one` ON SCHEDULE AT '2030-01-01 00:00:00' DO SET @a=5; +one` ON SCHEDULE AT '2080-01-01 00:00:00' DO SET @a=5; SHOW TABLES FROM bug25717383; --replace_column 6 # @@ -2994,7 +2994,7 @@ DROP DATABASE test1; create function f1() returns int return 1; create function f2() returns int return 2; update mysql.proc set body='return no_such_var' where db='test' and name='f1'; -create event e1 on schedule every 1 year starts '2030-01-01' do select 1; +create event e1 on schedule every 1 year starts '2080-01-01' do select 1; update mysql.event set body ='select not_a_value' where db='test' and name='e1'; create table t1 (i int); --replace_result mariadb-dump.exe mariadb-dump diff --git a/mysql-test/suite/events/events_2.result b/mysql-test/suite/events/events_2.result index 58d725f241e..b6cb0876667 100644 --- a/mysql-test/suite/events/events_2.result +++ b/mysql-test/suite/events/events_2.result @@ -2,12 +2,12 @@ set sql_mode=""; drop database if exists events_test; create database events_test; use events_test; -create event e_26 on schedule at '2037-01-01 00:00:00' disable do set @a = 5; +create event e_26 on schedule at '2087-01-01 00:00:00' disable do set @a = 5; Warnings: Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. select db, name, body, definer, convert_tz(execute_at, 'UTC', 'SYSTEM'), on_completion from mysql.event; db name body definer convert_tz(execute_at, 'UTC', 'SYSTEM') on_completion -events_test e_26 set @a = 5 root@localhost 2037-01-01 00:00:00 DROP +events_test e_26 set @a = 5 root@localhost 2087-01-01 00:00:00 DROP drop event e_26; create event e_26 on schedule at NULL disable do set @a = 5; ERROR HY000: Incorrect AT value: 'NULL' diff --git a/mysql-test/suite/events/events_2.test b/mysql-test/suite/events/events_2.test index 9385f5d356d..630b9232c24 100644 --- a/mysql-test/suite/events/events_2.test +++ b/mysql-test/suite/events/events_2.test @@ -18,7 +18,7 @@ use events_test; # mysql.event intact checking end # -create event e_26 on schedule at '2037-01-01 00:00:00' disable do set @a = 5; +create event e_26 on schedule at '2087-01-01 00:00:00' disable do set @a = 5; select db, name, body, definer, convert_tz(execute_at, 'UTC', 'SYSTEM'), on_completion from mysql.event; drop event e_26; --error ER_WRONG_VALUE diff --git a/mysql-test/suite/versioning/r/sysvars.result b/mysql-test/suite/versioning/r/sysvars.result index a5a3f79990c..ec1e89ef9c2 100644 --- a/mysql-test/suite/versioning/r/sysvars.result +++ b/mysql-test/suite/versioning/r/sysvars.result @@ -12,10 +12,10 @@ system_versioning_asof DEFAULT select * from t; a 2 -set system_versioning_asof= '2031-1-1 0:0:0'; +set system_versioning_asof= '2081-1-1 0:0:0'; show variables like 'system_versioning_asof'; Variable_name Value -system_versioning_asof 2031-01-01 00:00:00.000000 +system_versioning_asof 2081-01-01 00:00:00.000000 select * from t; a 2 diff --git a/mysql-test/suite/versioning/t/insert.test b/mysql-test/suite/versioning/t/insert.test index fe430b8e3b6..b276f8284eb 100644 --- a/mysql-test/suite/versioning/t/insert.test +++ b/mysql-test/suite/versioning/t/insert.test @@ -139,7 +139,7 @@ insert into t1(x, row_start, row_end) values (6, '1980-01-01 00:00:01', '1980-01 --error ER_WRONG_VERSIONING_RANGE insert into t1(x, row_start, row_end) values (7, '1980-01-01 00:00:11', '1980-01-01 00:00:11'); insert into t1(x, row_start) values (8, '1980-01-01 00:00:22'); ---replace_regex /'202\d-\d\d-\d\d .*'/'now'/ +--replace_regex /'20[2-8]\d-\d\d-\d\d .*'/'now'/ --error ER_WRONG_VERSIONING_RANGE insert into t1(x, row_end) values (9, '1980-01-01 00:00:33'); diff --git a/mysql-test/suite/versioning/t/sysvars.test b/mysql-test/suite/versioning/t/sysvars.test index 91dd278a2e1..1bc406faa2f 100644 --- a/mysql-test/suite/versioning/t/sysvars.test +++ b/mysql-test/suite/versioning/t/sysvars.test @@ -8,7 +8,7 @@ show global variables like 'system_versioning_asof'; show variables like 'system_versioning_asof'; select * from t; -set system_versioning_asof= '2031-1-1 0:0:0'; +set system_versioning_asof= '2081-1-1 0:0:0'; show variables like 'system_versioning_asof'; select * from t; -- 2.52.0 ++++++ MDEV-38811.patch ++++++ >From 20241132630660c94180f74a00065044dd2ae45c Mon Sep 17 00:00:00 2001 From: Sergei Golubchik <[email protected]> Date: Fri, 13 Feb 2026 15:22:57 +0100 Subject: [PATCH] MDEV-38811 crash in information_schema.table_constraints when --skip-grant-tables acl_get_all3() wasn't expecting --skip-grant-tables --- mysql-test/main/skip_grants.result | 40 +++++++++++++++++++++++++++++- mysql-test/main/skip_grants.test | 8 +++++- sql/sql_acl.cc | 3 +++ 3 files changed, 49 insertions(+), 2 deletions(-) Index: b/mysql-test/main/skip_grants.result =================================================================== --- a/mysql-test/main/skip_grants.result +++ b/mysql-test/main/skip_grants.result @@ -152,4 +152,43 @@ EXPECT_0 # select * from information_schema.users; USER PASSWORD_ERRORS PASSWORD_EXPIRATION_TIME +# MDEV-38811 crash in information_schema.table_constraints when --skip-grant-tables +# +select * from information_schema.table_constraints; +CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE +def mysql Host mysql roles_mapping UNIQUE +def mysql Options mysql servers CHECK +def mysql PRIMARY mysql column_stats PRIMARY KEY +def mysql PRIMARY mysql columns_priv PRIMARY KEY +def mysql PRIMARY mysql db PRIMARY KEY +def mysql PRIMARY mysql event PRIMARY KEY +def mysql PRIMARY mysql func PRIMARY KEY +def mysql PRIMARY mysql global_priv PRIMARY KEY +def mysql PRIMARY mysql gtid_slave_pos PRIMARY KEY +def mysql PRIMARY mysql help_category PRIMARY KEY +def mysql PRIMARY mysql help_keyword PRIMARY KEY +def mysql PRIMARY mysql help_relation PRIMARY KEY +def mysql PRIMARY mysql help_topic PRIMARY KEY +def mysql PRIMARY mysql index_stats PRIMARY KEY +def mysql PRIMARY mysql plugin PRIMARY KEY +def mysql PRIMARY mysql proc PRIMARY KEY +def mysql PRIMARY mysql procs_priv PRIMARY KEY +def mysql PRIMARY mysql proxies_priv PRIMARY KEY +def mysql PRIMARY mysql servers PRIMARY KEY +def mysql PRIMARY mysql table_stats PRIMARY KEY +def mysql PRIMARY mysql tables_priv PRIMARY KEY +def mysql PRIMARY mysql time_zone PRIMARY KEY +def mysql PRIMARY mysql time_zone_leap_second PRIMARY KEY +def mysql PRIMARY mysql time_zone_name PRIMARY KEY +def mysql PRIMARY mysql time_zone_transition PRIMARY KEY +def mysql PRIMARY mysql time_zone_transition_type PRIMARY KEY +def mysql Priv mysql global_priv CHECK +def mysql name mysql help_category UNIQUE +def mysql name mysql help_keyword UNIQUE +def mysql name mysql help_topic UNIQUE +def sys PRIMARY sys sys_config PRIMARY KEY +Warnings: +Warning 1286 Unknown storage engine 'InnoDB' +Warning 1286 Unknown storage engine 'InnoDB' +Warning 1286 Unknown storage engine 'InnoDB' # End of 11.8 tests Index: b/mysql-test/main/skip_grants.test =================================================================== --- a/mysql-test/main/skip_grants.test +++ b/mysql-test/main/skip_grants.test @@ -191,4 +191,9 @@ SELECT @@skip_grant_tables AS EXPECT_0; --echo # select * from information_schema.users; +--echo # MDEV-38811 crash in information_schema.table_constraints when --skip-grant-tables +--echo # +--sorted_result +select * from information_schema.table_constraints; + --echo # End of 11.8 tests Index: b/sql/sql_acl.cc =================================================================== --- a/sql/sql_acl.cc +++ b/sql/sql_acl.cc @@ -3927,6 +3927,9 @@ exit: privilege_t acl_get_all3(Security_context *sctx, const char *db, bool db_is_patern) { + if (!initialized) + return DB_ACLS; + privilege_t access= acl_get(sctx->host, sctx->ip, sctx->priv_user, db, db_is_patern); if (sctx->priv_role[0]) ++++++ mariadb-11.8.5.tar.gz -> mariadb-11.8.6.tar.gz ++++++ /work/SRC/openSUSE:Factory/mariadb/mariadb-11.8.5.tar.gz /work/SRC/openSUSE:Factory/.mariadb.new.30200/mariadb-11.8.6.tar.gz differ: char 12, line 1 ++++++ suse_skipped_tests.list ++++++ --- /var/tmp/diff_new_pack.8w15tz/_old 2026-05-05 15:16:00.208754731 +0200 +++ /var/tmp/diff_new_pack.8w15tz/_new 2026-05-05 15:16:00.212754897 +0200 @@ -57,3 +57,8 @@ main.func_regexp_pcre : boo#1252518 mysql_sha2.ssl_auto : since 11.8.5 - all +main.chained_ssl_certificates : since 11.8.6 - all +compat/oracle.sp-package : since 11.8.6 - armv7l +main.xml : since 11.8.6 - armv7l + +
