1CREATE TABLE t1 (a INT, b CHAR(8), PRIMARY KEY (a)) ENGINE=ROCKSDB;
2INSERT INTO t1 (a,b) VALUES (100,'foo'),(2, 'b');
3CREATE TABLE t2 (a INT, b CHAR(8), PRIMARY KEY (b)) ENGINE=ROCKSDB CHARACTER SET utf8;
4INSERT INTO t2 (a,b) VALUES (1, 'bar');
5CREATE TABLE t3 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=ROCKSDB CHARACTER SET utf8;
6DESCRIBE t1;
7Field	Type	Null	Key	Default	Extra
8a	int(11)	NO	PRI	NULL
9b	char(8)	YES		NULL
10DESC t2 a;
11Field	Type	Null	Key	Default	Extra
12a	int(11)	YES		NULL
13DESCRIBE t3 '%';
14Field	Type	Null	Key	Default	Extra
15a	int(11)	YES		NULL
16b	char(8)	YES		NULL
17pk	int(11)	NO	PRI	NULL	auto_increment
18DROP TABLE t1, t2, t3;
19