Debian Codegraph @

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

raw
1 -- source ../include/ps_truncate_all_tables.inc
2 # Tests for sys schema
3 # Verify the sys.innodb_lock_waits view
4
5 # TODO: Bug#30760026.
6 # View metadata updates make the view columns after
7 # the first server restart different from what they look
8 # like after an upgrade, because the view meta data update
9 # triggered by the storing of the DD meta data for the
10 # underlying entities is done using sql_mode=0, which
11 # is different from the sql_mode used during CREATE
12 # (i.e. the default sql_mode).
13 #
14 # As a short term fix, to avoid noise from test runs,
15 # we mask the values that become different in order to
16 # get deterministic results. This short term fix should
17 # be removed when the underlying issue is fixed.
18 --replace_column 3 X 5 X
19
20 # Ensure structure changes don't slip in
21 DESC sys.innodb_lock_waits;
22
23 # Make sure view select does not error, but ignore results
24 --disable_result_log
25 SELECT * FROM sys.innodb_lock_waits;
26 --enable_result_log
27
28 # TODO: Bug#30760026.
29 --replace_column 3 X 5 X
30
31 # Ensure structure changes don't slip in
32 DESC sys.x$innodb_lock_waits;
33
34 # Make sure view select does not error, but ignore results
35 --disable_result_log
36 SELECT * FROM sys.x$innodb_lock_waits;
37 --enable_result_log
38
39 EXPLAIN SELECT * FROM sys.innodb_lock_waits;
40
41 EXPLAIN SELECT * FROM sys.x$innodb_lock_waits;
42