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 |