summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2022-04-10 14:46:24 +0400
committerAlexander Barkov <bar@mariadb.com>2022-04-10 14:46:24 +0400
commit284ff64cd6618ac9f90c182d46fa6f03b301b65b (patch)
tree5dd9315b6f26c6f85a0b2ab67d20d1961be22437
parentd90c5ddd8beb961434200f7e02fac3a3a121f7e2 (diff)
downloadmariadb-git-284ff64cd6618ac9f90c182d46fa6f03b301b65b.tar.gz
10.6 tests for MDEV-26507 Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed
The patch for MDEV-27673 (in 10.3) fixed MDEV-26507 as well. This patch only adds 10.6 specific MTR tests for MDEV-26507.
-rw-r--r--mysql-test/suite/sysschema/r/v_innodb_lock_waits.result12
-rw-r--r--mysql-test/suite/sysschema/t/v_innodb_lock_waits.test18
2 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/r/v_innodb_lock_waits.result b/mysql-test/suite/sysschema/r/v_innodb_lock_waits.result
index 7e44c334283..d8e2c496d13 100644
--- a/mysql-test/suite/sysschema/r/v_innodb_lock_waits.result
+++ b/mysql-test/suite/sysschema/r/v_innodb_lock_waits.result
@@ -56,3 +56,15 @@ blocking_trx_rows_modified bigint(21) unsigned NO NULL
sql_kill_blocking_query varchar(32) YES NULL
sql_kill_blocking_connection varchar(26) YES NULL
SELECT * FROM sys.x$innodb_lock_waits;
+#
+# Start of 10.6 tests
+#
+#
+# MDEV-26507 Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed
+#
+SET SESSION sql_mode='ALLOW_INVALID_DATES';
+SELECT * FROM sys.x$innodb_lock_waits;
+SET SESSION sql_mode=DEFAULT;
+#
+# End of 10.6 tests
+#
diff --git a/mysql-test/suite/sysschema/t/v_innodb_lock_waits.test b/mysql-test/suite/sysschema/t/v_innodb_lock_waits.test
index d742f599595..b784587d2a6 100644
--- a/mysql-test/suite/sysschema/t/v_innodb_lock_waits.test
+++ b/mysql-test/suite/sysschema/t/v_innodb_lock_waits.test
@@ -21,3 +21,21 @@ DESC sys.x$innodb_lock_waits;
SELECT * FROM sys.x$innodb_lock_waits;
--enable_result_log
+
+--echo #
+--echo # Start of 10.6 tests
+--echo #
+
+--echo #
+--echo # MDEV-26507 Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed
+--echo #
+
+SET SESSION sql_mode='ALLOW_INVALID_DATES';
+--disable_result_log
+SELECT * FROM sys.x$innodb_lock_waits;
+--enable_result_log
+SET SESSION sql_mode=DEFAULT;
+
+--echo #
+--echo # End of 10.6 tests
+--echo #