diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-13 12:24:36 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-13 12:24:36 +0000 |
| commit | 06eaf7232e9a920468c0f8d74dcf2fe8b555501c (patch) | |
| tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/perfschema/t/show_misc.test | |
| parent | Initial commit. (diff) | |
| download | mariadb-06eaf7232e9a920468c0f8d74dcf2fe8b555501c.tar.xz mariadb-06eaf7232e9a920468c0f8d74dcf2fe8b555501c.zip | |
Adding upstream version 1:10.11.6.upstream/1%10.11.6
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/perfschema/t/show_misc.test')
| -rw-r--r-- | mysql-test/suite/perfschema/t/show_misc.test | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/t/show_misc.test b/mysql-test/suite/perfschema/t/show_misc.test new file mode 100644 index 00000000..e557ef31 --- /dev/null +++ b/mysql-test/suite/perfschema/t/show_misc.test @@ -0,0 +1,64 @@ +--source include/have_perfschema.inc +--source include/not_embedded.inc +--source include/no_protocol.inc + +select 1; +SHOW STATUS LIKE 'Last_query_partial_plans'; +select 2; +SHOW STATUS LIKE 'Last_query_cost'; + +flush status; +SHOW STATUS LIKE 'Created_tmp_tables'; + +--echo # +--echo # ================================================================================ +--echo # Bug#21789221 SHOW STATUS FAILS WITH LOCK TABLES AND SHOW_COMPATIBILITY_56=OFF +--echo # ================================================================================ +--echo # Verify that SHOW STATUS and SHOW VARIABLES works under LOCK TABLES mode +--echo # +CREATE TABLE test.t1 (s1 INT); +LOCK TABLE test.t1 READ; +--echo # +SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo"; +--echo # +SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo"; +--echo # +SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo"; +--echo # +SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo"; +--echo # +UNLOCK TABLES; +--echo # +LOCK TABLE test.t1 WRITE; +--echo # +SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo"; +--echo # +SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo"; +--echo # +SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo"; +--echo # +SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo"; +--echo # +UNLOCK TABLES; + +DROP TABLE test.t1; + + +--echo # +--echo # ================================================================================ +--echo # Bug#28515475 BOGUS DATA WHEN ORDERING RESULTS FROM VARIABLES_BY_THREAD +--echo # ================================================================================ +--echo # Verify the results from "WHERE variable_name IN(...)", particularly for those +--echo # variables that are listed after the deprecated variable gtid_executed. +--echo # The ORDER BY also forces an additional code path through rnd_pos(). +--echo # + +SELECT variable_name FROM performance_schema.variables_by_thread + WHERE variable_name IN ('interactive_timeout','net_read_timeout','net_write_timeout','wait_timeout') + ORDER BY variable_name; + + +--echo # +--echo # ================================================================================ +--echo # CLEAN UP +--echo # ================================================================================ |