Debian Codegraph @

mysql-test/suite/perfschema/r/show_misc.result

raw
1 select 1;
2 1
3 1
4 SHOW STATUS LIKE 'Last_query_partial_plans';
5 Variable_name Value
6 Last_query_partial_plans 0
7 select 2;
8 2
9 2
10 SHOW STATUS LIKE 'Last_query_cost';
11 Variable_name Value
12 Last_query_cost 0.000000
13 flush status;
14 SHOW STATUS LIKE 'Created_tmp_tables';
15 Variable_name Value
16 Created_tmp_tables 0
17
18 ================================================================================
19 Bug#21789221 SHOW STATUS FAILS WITH LOCK TABLES AND SHOW_COMPATIBILITY_56=OFF
20 ================================================================================
21 Verify that SHOW STATUS and SHOW VARIABLES works under LOCK TABLES mode
22
23 CREATE TABLE test.t1 (s1 INT);
24 LOCK TABLE test.t1 READ;
25
26 SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
27 Variable_name Value
28
29 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
30 Variable_name Value
31
32 SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
33 Variable_name Value
34
35 SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
36 Variable_name Value
37
38 UNLOCK TABLES;
39
40 LOCK TABLE test.t1 WRITE;
41
42 SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
43 Variable_name Value
44
45 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
46 Variable_name Value
47
48 SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
49 Variable_name Value
50
51 SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
52 Variable_name Value
53
54 UNLOCK TABLES;
55 DROP TABLE test.t1;