diff options
Diffstat (limited to '')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/index_type_hash.result | 69 |
1 files changed, 69 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/index_type_hash.result b/storage/rocksdb/mysql-test/rocksdb/r/index_type_hash.result new file mode 100644 index 00000000..bc1a96fa --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/index_type_hash.result @@ -0,0 +1,69 @@ +CREATE TABLE t1 (a INT, +b CHAR(8), +pk INT PRIMARY KEY, +KEY USING HASH (a) +) ENGINE=rocksdb; +SHOW KEYS IN t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment +t1 0 PRIMARY 1 pk A # NULL NULL LSMTREE +t1 1 a 1 a A # NULL NULL YES LSMTREE +DROP TABLE t1; +CREATE TABLE t1 (a INT, +b CHAR(8), +pk INT PRIMARY KEY, +KEY a_b USING HASH (a,b) COMMENT 'a_b index' +) ENGINE=rocksdb; +SHOW KEYS IN t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment +t1 0 PRIMARY 1 pk A # NULL NULL LSMTREE +t1 1 a_b 1 a A # NULL NULL YES LSMTREE a_b index +t1 1 a_b 2 b A # NULL NULL YES LSMTREE a_b index +DROP TABLE t1; +CREATE TABLE t1 (a INT, +b CHAR(8), +pk INT PRIMARY KEY, +KEY USING HASH (a), +KEY USING HASH (b) +) ENGINE=rocksdb; +SHOW KEYS IN t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment +t1 0 PRIMARY 1 pk A # NULL NULL LSMTREE +t1 1 a 1 a A # NULL NULL YES LSMTREE +t1 1 b 1 b A # NULL NULL YES LSMTREE +DROP TABLE t1; +CREATE TABLE t1 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb; +INSERT INTO t1 (a,b) VALUES (100,'z'); +ALTER TABLE t1 ADD KEY (a) USING HASH COMMENT 'simple index on a'; +SHOW INDEX FROM t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment +t1 0 PRIMARY 1 pk A # NULL NULL LSMTREE +t1 1 a 1 a A # NULL NULL YES LSMTREE simple index on a +ALTER TABLE t1 DROP KEY a; +DROP TABLE t1; +set global rocksdb_large_prefix=0; +CREATE TABLE t1 ( +a BLOB(1024), +KEY (a(767)) +) ENGINE=rocksdb; +DROP TABLE t1; +CREATE TABLE t1 ( +a BLOB(1024), +KEY (a(768)) +) ENGINE=rocksdb; +Warnings: +Note 1071 Specified key was too long; max key length is 767 bytes +DROP TABLE t1; +set global rocksdb_large_prefix=1; +CREATE TABLE t1 ( +a BLOB(4096), +KEY (a(3072)) +) ENGINE=rocksdb; +DROP TABLE t1; +CREATE TABLE t1 ( +a BLOB(4096), +KEY (a(3073)) +) ENGINE=rocksdb; +Warnings: +Note 1071 Specified key was too long; max key length is 3072 bytes +DROP TABLE t1; +set global rocksdb_large_prefix=DEFAULT; |