Debian Codegraph @

mysql-test/suite/perfschema/t/show_misc.test

raw
1 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
2 --source include/no_protocol.inc
3
4 select 1;
5 SHOW STATUS LIKE 'Last_query_partial_plans';
6 select 2;
7 SHOW STATUS LIKE 'Last_query_cost';
8
9 flush status;
10
11 SHOW STATUS LIKE 'Created_tmp_tables';
12
13 --echo
14 --echo ================================================================================
15 --echo Bug#21789221 SHOW STATUS FAILS WITH LOCK TABLES AND SHOW_COMPATIBILITY_56=OFF
16 --echo ================================================================================
17 --echo Verify that SHOW STATUS and SHOW VARIABLES works under LOCK TABLES mode
18 --echo
19 CREATE TABLE test.t1 (s1 INT);
20 LOCK TABLE test.t1 READ;
21 --echo
22 SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
23 --echo
24 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
25 --echo
26 SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
27 --echo
28 SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
29 --echo
30 UNLOCK TABLES;
31 --echo
32 LOCK TABLE test.t1 WRITE;
33 --echo
34 SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
35 --echo
36 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
37 --echo
38 SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
39 --echo
40 SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
41 --echo
42 UNLOCK TABLES;
43
44 DROP TABLE test.t1;
45