Debian Codegraph @

mysql-test/suite/sysschema/r/v_schema_redundant_indexes.result

raw
1 DESC sys.schema_redundant_indexes;
2 Field Type Null Key Default Extra
3 table_schema varchar(64) NO NULL
4 table_name varchar(64) NO NULL
5 redundant_index_name varchar(64) YES NULL
6 redundant_index_columns text YES NULL
7 redundant_index_non_unique int YES NULL
8 dominant_index_name varchar(64) YES NULL
9 dominant_index_columns text YES NULL
10 dominant_index_non_unique int YES NULL
11 subpart_exists int NO 0
12 sql_drop_index varchar(223) YES NULL
13 SELECT * FROM sys.schema_redundant_indexes;
14 DESC sys.x$schema_flattened_keys;
15 Field Type Null Key Default Extra
16 table_schema varchar(64) NO NULL
17 table_name varchar(64) NO NULL
18 index_name varchar(64) YES NULL
19 non_unique int YES NULL
20 subpart_exists bigint YES NULL
21 index_columns text YES NULL
22 SELECT * FROM sys.x$schema_flattened_keys;
23 CREATE DATABASE rkey;
24 CREATE TABLE rkey.rkey (
25 i INT,
26 j INT,
27 k INT,
28 PRIMARY KEY (i),
29 KEY (j),
30 KEY (j, k),
31 KEY (i, j, k)
32 );
33 SELECT * FROM sys.schema_redundant_indexes ORDER BY table_name, dominant_index_name;
34 table_schema table_name redundant_index_name redundant_index_columns redundant_index_non_unique dominant_index_name dominant_index_columns dominant_index_non_unique subpart_exists sql_drop_index
35 rkey rkey j j 1 j_2 j,k 1 0 ALTER TABLE `rkey`.`rkey` DROP INDEX `j`
36 rkey rkey i i,j,k 1 PRIMARY i 0 0 ALTER TABLE `rkey`.`rkey` DROP INDEX `i`
37 DROP DATABASE rkey;