1--source include/have_rocksdb.inc 2 3# Tests the Apply_changes_iter class for walking forward and backwards 4# with data in both the transaction class and in the rocksdb storage layer 5 6--disable_warnings 7DROP TABLE IF EXISTS t1; 8DROP TABLE IF EXISTS t2; 9--enable_warnings 10 11CREATE TABLE t1 ( 12 pk INT NOT NULL PRIMARY KEY, 13 key1 INT NOT NULL, 14 KEY (key1) 15) ENGINE=ROCKSDB; 16 17INSERT INTO t1 VALUES (12,12); 18INSERT INTO t1 VALUES (6,6); 19BEGIN; 20INSERT INTO t1 VALUES (8,8), (10,10); 21SELECT * FROM t1 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 DESC; 22SELECT * FROM t1 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 ASC; 23SELECT * FROM t1 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 DESC; 24SELECT * FROM t1 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 ASC; 25ROLLBACK; 26 27CREATE TABLE t2 ( 28 pk INT NOT NULL PRIMARY KEY, 29 key1 INT NOT NULL, 30 KEY (key1) COMMENT 'rev:cf' 31) ENGINE=ROCKSDB; 32 33INSERT INTO t2 VALUES (12,12); 34INSERT INTO t2 VALUES (6,6); 35BEGIN; 36INSERT INTO t2 VALUES (8,8), (10,10); 37SELECT * FROM t2 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 DESC; 38SELECT * FROM t2 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 ASC; 39SELECT * FROM t2 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 DESC; 40SELECT * FROM t2 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 ASC; 41ROLLBACK; 42 43DROP TABLE t1; 44DROP TABLE t2; 45