mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
bf70532e3d
The fix for MDEV-27673 (in 10.3) fixed MDEV-26507 as well. This patch only adds MTR tests.
34 lines
834 B
Text
34 lines
834 B
Text
--source include/have_innodb.inc
|
|
|
|
SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_TRX;
|
|
|
|
CREATE TEMPORARY TABLE t1 LIKE INFORMATION_SCHEMA.INNODB_TRX;
|
|
DROP TEMPORARY TABLE t1;
|
|
|
|
CREATE TEMPORARY TABLE t1 AS SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX LIMIT 0;
|
|
DROP TEMPORARY TABLE t1;
|
|
|
|
|
|
--echo #
|
|
--echo # Start of 10.5 tests
|
|
--echo #
|
|
|
|
--echo #
|
|
--echo # MDEV-26507 Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed
|
|
--echo #
|
|
|
|
CREATE ALGORITHM=TEMPTABLE VIEW i AS
|
|
SELECT a.trx_started
|
|
FROM INFORMATION_SCHEMA.innodb_lock_waits w
|
|
JOIN INFORMATION_SCHEMA.innodb_trx a
|
|
ORDER BY a.trx_wait_started;
|
|
SET SESSION sql_mode='ALLOW_INVALID_DATES';
|
|
--disable_result_log
|
|
SELECT * FROM i;
|
|
--enable_result_log
|
|
SET SESSION sql_mode=DEFAULT;
|
|
DROP VIEW i;
|
|
|
|
--echo #
|
|
--echo # End of 10.5 tests
|
|
--echo #
|