blob: 2a66750ed9ffc161917acbf47573f10338cb205b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
--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 #
|
