Debian Codegraph @

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

raw
1 --source include/have_perfschema.inc
2 --source include/not_embedded.inc
3 --source include/no_protocol.inc
4
5 select 1;
6 SHOW STATUS LIKE 'Last_query_partial_plans';
7 select 2;
8 SHOW STATUS LIKE 'Last_query_cost';
9
10 flush status;
11 flush global status;
12 SHOW STATUS LIKE 'Created_tmp_tables';
13
14 --echo #
15 --echo # ================================================================================
16 --echo # Bug#21789221 SHOW STATUS FAILS WITH LOCK TABLES AND SHOW_COMPATIBILITY_56=OFF
17 --echo # ================================================================================
18 --echo # Verify that SHOW STATUS and SHOW VARIABLES works under LOCK TABLES mode
19 --echo #
20 CREATE TABLE test.t1 (s1 INT);
21 LOCK TABLE test.t1 READ;
22 --echo #
23 SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
24 --echo #
25 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
26 --echo #
27 SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
28 --echo #
29 SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
30 --echo #
31 UNLOCK TABLES;
32 --echo #
33 LOCK TABLE test.t1 WRITE;
34 --echo #
35 SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
36 --echo #
37 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
38 --echo #
39 SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
40 --echo #
41 SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
42 --echo #
43 UNLOCK TABLES;
44
45 DROP TABLE test.t1;
46
47
48 --echo #
49 --echo # ================================================================================
50 --echo # Bug#28515475 BOGUS DATA WHEN ORDERING RESULTS FROM VARIABLES_BY_THREAD
51 --echo # ================================================================================
52 --echo # Verify the results from "WHERE variable_name IN(...)", particularly for those
53 --echo # variables that are listed after the deprecated variable gtid_executed.
54 --echo # The ORDER BY also forces an additional code path through rnd_pos().
55 --echo #
56
57 SELECT variable_name FROM performance_schema.variables_by_thread
58 WHERE variable_name IN ('interactive_timeout','net_read_timeout','net_write_timeout','wait_timeout')
59 ORDER BY variable_name;
60
61
62 --echo #
63 --echo # ================================================================================
64 --echo # CLEAN UP
65 --echo # ================================================================================