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