EVOLUTION-MANAGER

Edit File: index_primary.result

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a INT PRIMARY KEY,
b CHAR(8)
) 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	a	A	#	NULL	NULL		LSMTREE		
INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
INSERT INTO t1 (a,b) VALUES (1,'c');
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
DROP TABLE t1;
CREATE TABLE t1 (a INT PRIMARY KEY,
b CHAR(8) PRIMARY KEY
) ENGINE=rocksdb;
ERROR 42000: Multiple primary key defined
CREATE TABLE t1 (a INT,
b CHAR(8),
PRIMARY KEY (a,b)
) ENGINE=rocksdb;
SHOW INDEX 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	a	A	#	NULL	NULL		LSMTREE		
t1	0	PRIMARY	2	b	A	#	NULL	NULL		LSMTREE		
INSERT INTO t1 (a,b) VALUES (1,'a'),(1,'b'),(2,'a'),(2,'b');
INSERT INTO t1 (a,b) VALUES (1,'b');
ERROR 23000: Duplicate entry '1-b' for key 'PRIMARY'
DROP TABLE t1;
CREATE TABLE t1 (a INT KEY,
b CHAR(8),
KEY (b)
) ENGINE=rocksdb;
SHOW INDEX 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	a	A	#	NULL	NULL		LSMTREE		
t1	1	b	1	b	A	#	NULL	NULL	YES	LSMTREE		
DROP TABLE t1;
CREATE TABLE t1 (a INT,
b CHAR(8) PRIMARY KEY
) ENGINE=rocksdb;
SHOW INDEX 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	b	A	#	NULL	NULL		LSMTREE		
ALTER TABLE t1 ADD CONSTRAINT PRIMARY KEY pk (a);
ERROR 42000: Multiple primary key defined
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	b	A	#	NULL	NULL		LSMTREE		
DROP TABLE t1;
set global rocksdb_large_prefix=0;
CREATE TABLE t1 (
a BLOB(1024),
PRIMARY KEY (a(767))
) ENGINE=rocksdb;
DROP TABLE t1;
CREATE TABLE t1 (
a BLOB(1024),
PRIMARY KEY (a(768))
) ENGINE=rocksdb;
ERROR 42000: Specified key was too long; max key length is 767 bytes
set global rocksdb_large_prefix=1;
CREATE TABLE t1 (
a BLOB(4096),
PRIMARY KEY (a(3072))
) ENGINE=rocksdb;
DROP TABLE t1;
CREATE TABLE t1 (
a BLOB(4096),
PRIMARY KEY (a(3073))
) ENGINE=rocksdb;
ERROR 42000: Specified key was too long; max key length is 3072 bytes
set global rocksdb_large_prefix=DEFAULT;