diff options
Diffstat (limited to 'mysql-test/suite/sysschema/t/v_waits_by_user_by_latency.test')
| -rw-r--r-- | mysql-test/suite/sysschema/t/v_waits_by_user_by_latency.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/t/v_waits_by_user_by_latency.test b/mysql-test/suite/sysschema/t/v_waits_by_user_by_latency.test new file mode 100644 index 00000000000..0f98c3a254a --- /dev/null +++ b/mysql-test/suite/sysschema/t/v_waits_by_user_by_latency.test @@ -0,0 +1,22 @@ +-- source include/not_embedded.inc +-- source ../include/ps_truncate_all_tables.inc +# Tests for sys schema +# Verify the sys.waits_by_user_by_latency view + +# Ensure structure changes don't slip in +DESC sys.waits_by_user_by_latency; + +# Make sure view select does not error, but ignore results +--disable_result_log +SELECT * FROM sys.waits_by_user_by_latency; +--enable_result_log + + +# Ensure structure changes don't slip in +DESC sys.x$waits_by_user_by_latency; + +# Make sure view select does not error, but ignore results +--disable_result_log +SELECT * FROM sys.x$waits_by_user_by_latency; +--enable_result_log + |