Debian Codegraph @

mysql-test/suite/storage_engine/index_key_block_size.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>,
3 b <CHAR_COLUMN>,
4 <CUSTOM_INDEX> (a) KEY_BLOCK_SIZE=8
5 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
6 SHOW KEYS IN t1;
7 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
8 t1 1 a 1 a # # NULL NULL # #
9 DROP TABLE t1;
10 CREATE TABLE t1 (a <INT_COLUMN>,
11 b <CHAR_COLUMN>,
12 <CUSTOM_INDEX> ind1(b ASC) KEY_BLOCK_SIZE=0
13 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
14 SHOW INDEX IN t1;
15 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
16 t1 1 ind1 1 b # # NULL NULL # #
17 DROP TABLE t1;
18 CREATE TABLE t1 (a <INT_COLUMN>,
19 b <CHAR_COLUMN>,
20 UNIQUE INDEX ind2(b(1) DESC) KEY_BLOCK_SIZE=32768 COMMENT 'big key_block_size value'
21 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
22 SHOW INDEX IN t1;
23 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
24 t1 0 ind2 1 b # # 1 NULL # # big key_block_size value
25 DROP TABLE t1;
26 CREATE TABLE t1 (a <INT_COLUMN>,
27 b <CHAR_COLUMN>,
28 <CUSTOM_INDEX> a_b(a,b) KEY_BLOCK_SIZE=8192
29 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
30 SHOW INDEX IN t1;
31 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
32 t1 1 a_b 1 a # # NULL NULL # #
33 t1 1 a_b 2 b # # NULL NULL # #
34 DROP TABLE t1;
35 CREATE TABLE t1 (a <INT_COLUMN>,
36 b <CHAR_COLUMN>
37 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
38 INSERT INTO t1 (a,b) VALUES (100,'z');
39 ALTER TABLE t1 ADD <CUSTOM_INDEX>(a) KEY_BLOCK_SIZE 8192;
40 SHOW INDEX FROM t1;
41 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
42 t1 1 a 1 a # # NULL NULL # #
43 DROP TABLE t1;