Debian Codegraph @

mysql-test/suite/sysschema/t/v_innodb_lock_waits.test

raw
1 -- source include/not_embedded.inc
2 -- source ../include/ps_truncate_all_tables.inc
3 -- source include/have_innodb.inc
4 # Tests for sys schema
5 # Verify the sys.innodb_lock_waits view
6
7 # Ensure structure changes don't slip in
8 DESC sys.innodb_lock_waits;
9
10 # Make sure view select does not error, but ignore results
11 --disable_result_log
12 SELECT * FROM sys.innodb_lock_waits;
13 --enable_result_log
14
15
16 # Ensure structure changes don't slip in
17 DESC sys.x$innodb_lock_waits;
18
19 # Make sure view select does not error, but ignore results
20 --disable_result_log
21 SELECT * FROM sys.x$innodb_lock_waits;
22 --enable_result_log
23
24
25 --echo #
26 --echo # Start of 10.6 tests
27 --echo #
28
29 --echo #
30 --echo # MDEV-26507 Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed
31 --echo #
32
33 SET SESSION sql_mode='ALLOW_INVALID_DATES';
34 --disable_result_log
35 SELECT * FROM sys.x$innodb_lock_waits;
36 --enable_result_log
37 SET SESSION sql_mode=DEFAULT;
38
39 --echo #
40 --echo # End of 10.6 tests
41 --echo #