1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1 (a INT, 3b CHAR(8), 4pk INT PRIMARY KEY, 5KEY (a) KEY_BLOCK_SIZE=8 6) ENGINE=rocksdb; 7SHOW KEYS IN t1; 8Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 9t1 0 PRIMARY 1 pk A # NULL NULL LSMTREE 10t1 1 a 1 a A # NULL NULL YES LSMTREE 11DROP TABLE t1; 12CREATE TABLE t1 (a INT, 13b CHAR(8), 14pk INT PRIMARY KEY, 15KEY ind1(b ASC) KEY_BLOCK_SIZE=0 16) ENGINE=rocksdb; 17SHOW INDEX IN t1; 18Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 19t1 0 PRIMARY 1 pk A # NULL NULL LSMTREE 20t1 1 ind1 1 b A # NULL NULL YES LSMTREE 21DROP TABLE t1; 22CREATE TABLE t1 (a INT, 23b CHAR(8), 24PRIMARY KEY ind2(b(1) DESC) KEY_BLOCK_SIZE=32768 COMMENT 'big key_block_size value' 25) ENGINE=rocksdb; 26Warnings: 27Warning 1280 Name 'ind2' ignored for PRIMARY key. 28SHOW INDEX IN t1; 29Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 30t1 0 PRIMARY 1 b A # 1 NULL LSMTREE big key_block_size value 31DROP TABLE t1; 32CREATE TABLE t1 (a INT, 33b CHAR(8), 34pk INT AUTO_INCREMENT PRIMARY KEY, 35KEY a_b(a,b) KEY_BLOCK_SIZE=8192 36) ENGINE=rocksdb; 37SHOW INDEX IN t1; 38Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 39t1 0 PRIMARY 1 pk A # NULL NULL LSMTREE 40t1 1 a_b 1 a A # NULL NULL YES LSMTREE 41t1 1 a_b 2 b A # NULL NULL YES LSMTREE 42DROP TABLE t1; 43CREATE TABLE t1 (a INT, 44b CHAR(8), 45PRIMARY KEY (b) 46) ENGINE=rocksdb; 47INSERT INTO t1 (a,b) VALUES (100,'z'); 48ALTER TABLE t1 ADD KEY(a) KEY_BLOCK_SIZE 8192; 49SHOW INDEX FROM t1; 50Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 51t1 0 PRIMARY 1 b A # NULL NULL LSMTREE 52t1 1 a 1 a A # NULL NULL YES LSMTREE 53DROP TABLE t1; 54