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