1DROP TABLE IF EXISTS t1, t2; 2CREATE TABLE t1 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb; 3INSERT INTO t1 VALUES (100,'foobar',100),(1,'a',101),(2,'b',103),(3,'c',104),(4,'d',105),(5,'e',106); 4SELECT a,b FROM t1; 5a b 61 a 7100 foobar 82 b 93 c 104 d 115 e 12INSERT t1 VALUE (10,'foo',107),(11,'abc',108); 13SELECT a,b FROM t1; 14a b 151 a 1610 foo 17100 foobar 1811 abc 192 b 203 c 214 d 225 e 23INSERT INTO t1 (b,a) VALUES ('test',0); 24SELECT a,b FROM t1; 25a b 260 test 271 a 2810 foo 29100 foobar 3011 abc 312 b 323 c 334 d 345 e 35INSERT INTO t1 VALUES (DEFAULT,DEFAULT,NULL); 36SELECT a,b FROM t1; 37a b 380 test 391 a 4010 foo 41100 foobar 4211 abc 432 b 443 c 454 d 465 e 47NULL NULL 48INSERT t1 (a) VALUE (10),(20); 49SELECT a,b FROM t1; 50a b 510 test 521 a 5310 NULL 5410 foo 55100 foobar 5611 abc 572 b 5820 NULL 593 c 604 d 615 e 62NULL NULL 63INSERT INTO t1 SET a = 11, b = 'f'; 64SELECT a,b FROM t1; 65a b 660 test 671 a 6810 NULL 6910 foo 70100 foobar 7111 abc 7211 f 732 b 7420 NULL 753 c 764 d 775 e 78NULL NULL 79INSERT t1 SET b = DEFAULT; 80SELECT a,b FROM t1; 81a b 820 test 831 a 8410 NULL 8510 foo 86100 foobar 8711 abc 8811 f 892 b 9020 NULL 913 c 924 d 935 e 94NULL NULL 95NULL NULL 96CREATE TABLE t2 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb; 97INSERT INTO t2 SELECT a,b,pk FROM t1; 98INSERT INTO t1 (a) SELECT a FROM t2 WHERE b = 'foo'; 99SELECT a,b FROM t1; 100a b 1010 test 1021 a 10310 NULL 10410 NULL 10510 foo 106100 foobar 10711 abc 10811 f 1092 b 11020 NULL 1113 c 1124 d 1135 e 114NULL NULL 115NULL NULL 116INSERT t1 (a,b) SELECT a,b FROM t1; 117SELECT a,b FROM t1; 118a b 1190 test 1200 test 1211 a 1221 a 12310 NULL 12410 NULL 12510 NULL 12610 NULL 12710 foo 12810 foo 129100 foobar 130100 foobar 13111 abc 13211 abc 13311 f 13411 f 1352 b 1362 b 13720 NULL 13820 NULL 1393 c 1403 c 1414 d 1424 d 1435 e 1445 e 145NULL NULL 146NULL NULL 147NULL NULL 148NULL NULL 149DROP TABLE t1, t2; 150CREATE TABLE t1 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb; 151BEGIN; 152INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(100,'foo'); 153INSERT t1 (a,b) VALUE (10,'foo'),(11,'abc'); 154COMMIT; 155SELECT a,b FROM t1; 156a b 1571 a 15810 foo 159100 foo 16011 abc 1612 b 1623 c 1634 d 1645 e 165BEGIN; 166INSERT INTO t1 (b,a) VALUES ('test',0); 167SAVEPOINT spt1; 168INSERT INTO t1 (a,b) VALUES (DEFAULT,DEFAULT); 169RELEASE SAVEPOINT spt1; 170INSERT INTO t1 (a,b) VALUES (DEFAULT,DEFAULT); 171ROLLBACK; 172SELECT a,b FROM t1; 173a b 1741 a 17510 foo 176100 foo 17711 abc 1782 b 1793 c 1804 d 1815 e 182BEGIN; 183INSERT t1 (a) VALUE (10),(20); 184SAVEPOINT spt1; 185INSERT INTO t1 SET a = 11, b = 'f'; 186INSERT t1 SET b = DEFAULT; 187ROLLBACK TO SAVEPOINT spt1; 188ERROR HY000: MyRocks currently does not support ROLLBACK TO SAVEPOINT if modifying rows. 189INSERT INTO t1 (b,a) VALUES ('test1',10); 190COMMIT; 191ERROR HY000: This transaction was rolled back and cannot be committed. Only supported operation is to roll it back, so all pending changes will be discarded. Please restart another transaction. 192SELECT a,b FROM t1; 193a b 1941 a 19510 foo 196100 foo 19711 abc 1982 b 1993 c 2004 d 2015 e 202DROP TABLE t1; 203