1DROP TABLE IF EXISTS t1, t2; 2CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, c CHAR(8)) ENGINE=rocksdb; 3INSERT INTO t1 VALUES (1,1,'a'),(2,5,'z'); 4ALTER TABLE t1 ADD COLUMN b INT; 5SHOW CREATE TABLE t1; 6Table Create Table 7t1 CREATE TABLE `t1` ( 8 `pk` int(11) NOT NULL, 9 `a` int(11) DEFAULT NULL, 10 `c` char(8) DEFAULT NULL, 11 `b` int(11) DEFAULT NULL, 12 PRIMARY KEY (`pk`) 13) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 14ALTER TABLE t1 ALTER COLUMN a SET DEFAULT '0'; 15SHOW CREATE TABLE t1; 16Table Create Table 17t1 CREATE TABLE `t1` ( 18 `pk` int(11) NOT NULL, 19 `a` int(11) DEFAULT 0, 20 `c` char(8) DEFAULT NULL, 21 `b` int(11) DEFAULT NULL, 22 PRIMARY KEY (`pk`) 23) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 24ALTER TABLE t1 ALTER a DROP DEFAULT; 25SHOW CREATE TABLE t1; 26Table Create Table 27t1 CREATE TABLE `t1` ( 28 `pk` int(11) NOT NULL, 29 `a` int(11), 30 `c` char(8) DEFAULT NULL, 31 `b` int(11) DEFAULT NULL, 32 PRIMARY KEY (`pk`) 33) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 34ALTER TABLE t1 CHANGE COLUMN b b1 CHAR(8) FIRST; 35SHOW CREATE TABLE t1; 36Table Create Table 37t1 CREATE TABLE `t1` ( 38 `b1` char(8) DEFAULT NULL, 39 `pk` int(11) NOT NULL, 40 `a` int(11), 41 `c` char(8) DEFAULT NULL, 42 PRIMARY KEY (`pk`) 43) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 44ALTER TABLE t1 CHANGE b1 b INT AFTER c; 45SHOW CREATE TABLE t1; 46Table Create Table 47t1 CREATE TABLE `t1` ( 48 `pk` int(11) NOT NULL, 49 `a` int(11), 50 `c` char(8) DEFAULT NULL, 51 `b` int(11) DEFAULT NULL, 52 PRIMARY KEY (`pk`) 53) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 54ALTER TABLE t1 CHANGE b b CHAR(8); 55SHOW CREATE TABLE t1; 56Table Create Table 57t1 CREATE TABLE `t1` ( 58 `pk` int(11) NOT NULL, 59 `a` int(11), 60 `c` char(8) DEFAULT NULL, 61 `b` char(8) DEFAULT NULL, 62 PRIMARY KEY (`pk`) 63) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 64ALTER TABLE t1 MODIFY COLUMN b INT; 65SHOW CREATE TABLE t1; 66Table Create Table 67t1 CREATE TABLE `t1` ( 68 `pk` int(11) NOT NULL, 69 `a` int(11), 70 `c` char(8) DEFAULT NULL, 71 `b` int(11) DEFAULT NULL, 72 PRIMARY KEY (`pk`) 73) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 74ALTER TABLE t1 MODIFY COLUMN b CHAR(8) FIRST; 75SHOW CREATE TABLE t1; 76Table Create Table 77t1 CREATE TABLE `t1` ( 78 `b` char(8) DEFAULT NULL, 79 `pk` int(11) NOT NULL, 80 `a` int(11), 81 `c` char(8) DEFAULT NULL, 82 PRIMARY KEY (`pk`) 83) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 84ALTER TABLE t1 MODIFY COLUMN b INT AFTER a; 85SHOW CREATE TABLE t1; 86Table Create Table 87t1 CREATE TABLE `t1` ( 88 `pk` int(11) NOT NULL, 89 `a` int(11), 90 `b` int(11) DEFAULT NULL, 91 `c` char(8) DEFAULT NULL, 92 PRIMARY KEY (`pk`) 93) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 94ALTER TABLE t1 DROP COLUMN b; 95SHOW CREATE TABLE t1; 96Table Create Table 97t1 CREATE TABLE `t1` ( 98 `pk` int(11) NOT NULL, 99 `a` int(11), 100 `c` char(8) DEFAULT NULL, 101 PRIMARY KEY (`pk`) 102) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 103ALTER TABLE t1 RENAME TO t2; 104SHOW CREATE TABLE t1; 105ERROR 42S02: Table 'test.t1' doesn't exist 106SHOW CREATE TABLE t2; 107Table Create Table 108t2 CREATE TABLE `t2` ( 109 `pk` int(11) NOT NULL, 110 `a` int(11), 111 `c` char(8) DEFAULT NULL, 112 PRIMARY KEY (`pk`) 113) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 114DROP TABLE t2; 115CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b INT) ENGINE=rocksdb; 116INSERT INTO t1 VALUES (1,1,5),(2,2,2),(3,4,3); 117SHOW CREATE TABLE t1; 118Table Create Table 119t1 CREATE TABLE `t1` ( 120 `pk` int(11) NOT NULL, 121 `a` int(11) DEFAULT NULL, 122 `b` int(11) DEFAULT NULL, 123 PRIMARY KEY (`pk`) 124) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 125ALTER TABLE t1 ORDER BY b ASC, a DESC, pk DESC; 126Warnings: 127Warning 1105 ORDER BY ignored as there is a user-defined clustered index in the table 't1' 128SHOW CREATE TABLE t1; 129Table Create Table 130t1 CREATE TABLE `t1` ( 131 `pk` int(11) NOT NULL, 132 `a` int(11) DEFAULT NULL, 133 `b` int(11) DEFAULT NULL, 134 PRIMARY KEY (`pk`) 135) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 136SELECT * FROM t1; 137pk a b 1381 1 5 1392 2 2 1403 4 3 141DROP TABLE t1; 142CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b CHAR(8), c CHAR(8)) ENGINE=rocksdb CHARACTER SET latin1 COLLATE latin1_general_cs; 143INSERT INTO t1 VALUES (1,5,'z','t'); 144SHOW CREATE TABLE t1; 145Table Create Table 146t1 CREATE TABLE `t1` ( 147 `pk` int(11) NOT NULL, 148 `a` int(11) DEFAULT NULL, 149 `b` char(8) COLLATE latin1_general_cs DEFAULT NULL, 150 `c` char(8) COLLATE latin1_general_cs DEFAULT NULL, 151 PRIMARY KEY (`pk`) 152) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs 153ALTER TABLE t1 CONVERT TO CHARACTER SET utf8; 154SHOW CREATE TABLE t1; 155Table Create Table 156t1 CREATE TABLE `t1` ( 157 `pk` int(11) NOT NULL, 158 `a` int(11) DEFAULT NULL, 159 `b` char(8) DEFAULT NULL, 160 `c` char(8) DEFAULT NULL, 161 PRIMARY KEY (`pk`) 162) ENGINE=ROCKSDB DEFAULT CHARSET=utf8 163ALTER TABLE t1 DEFAULT CHARACTER SET = latin1 COLLATE latin1_general_ci; 164SHOW CREATE TABLE t1; 165Table Create Table 166t1 CREATE TABLE `t1` ( 167 `pk` int(11) NOT NULL, 168 `a` int(11) DEFAULT NULL, 169 `b` char(8) CHARACTER SET utf8 DEFAULT NULL, 170 `c` char(8) CHARACTER SET utf8 DEFAULT NULL, 171 PRIMARY KEY (`pk`) 172) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci 173ALTER TABLE t1 FORCE; 174SHOW CREATE TABLE t1; 175Table Create Table 176t1 CREATE TABLE `t1` ( 177 `pk` int(11) NOT NULL, 178 `a` int(11) DEFAULT NULL, 179 `b` char(8) CHARACTER SET utf8 DEFAULT NULL, 180 `c` char(8) CHARACTER SET utf8 DEFAULT NULL, 181 PRIMARY KEY (`pk`) 182) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci 183DROP TABLE t1; 184