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