Debian Codegraph @

mysql-test/suite/perfschema/t/index_schema.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2 # Show existing objects and information about their structure
3
4 # List of indexes
5 select TABLE_NAME, NON_UNIQUE, INDEX_SCHEMA, INDEX_NAME, INDEX_TYPE, INDEX_COMMENT
6 from INFORMATION_SCHEMA.STATISTICS
7 where TABLE_SCHEMA = "performance_schema" and SEQ_IN_INDEX = 1
8 order by TABLE_NAME collate utf8_general_ci, INDEX_NAME;
9
10 # List of index columns
11 select TABLE_NAME, NON_UNIQUE, INDEX_SCHEMA, INDEX_NAME, SEQ_IN_INDEX,
12 COLUMN_NAME, CARDINALITY, NULLABLE
13 from INFORMATION_SCHEMA.STATISTICS
14 where TABLE_SCHEMA = "performance_schema"
15 order by TABLE_NAME collate utf8_general_ci, INDEX_NAME, SEQ_IN_INDEX;