Debian Codegraph @

mysql-test/suite/sysschema/t/v_schema_unused_indexes.test

raw
1 -- source ../include/ps_truncate_all_tables.inc
2 # Tests for sys schema
3 # Verify the sys.schema_unused_indexes view
4
5 # Ensure structure changes don't slip in
6 DESC sys.schema_unused_indexes;
7
8 # Make sure view select does not error, but ignore results
9 --disable_result_log
10 SELECT * FROM sys.schema_unused_indexes;
11 --enable_result_log
12