1DROP TABLE IF EXISTS t1; 2DROP TABLE IF EXISTS t2; 3CREATE TABLE t1 ( 4pk INT NOT NULL PRIMARY KEY, 5key1 INT NOT NULL, 6KEY (key1) 7) ENGINE=ROCKSDB; 8INSERT INTO t1 VALUES (12,12); 9INSERT INTO t1 VALUES (6,6); 10BEGIN; 11INSERT INTO t1 VALUES (8,8), (10,10); 12SELECT * FROM t1 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 DESC; 13pk key1 1410 10 158 8 166 6 17SELECT * FROM t1 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 ASC; 18pk key1 196 6 208 8 2110 10 22SELECT * FROM t1 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 DESC; 23pk key1 2410 10 258 8 266 6 27SELECT * FROM t1 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 ASC; 28pk key1 296 6 308 8 3110 10 32ROLLBACK; 33CREATE TABLE t2 ( 34pk INT NOT NULL PRIMARY KEY, 35key1 INT NOT NULL, 36KEY (key1) COMMENT 'rev:cf' 37) ENGINE=ROCKSDB; 38INSERT INTO t2 VALUES (12,12); 39INSERT INTO t2 VALUES (6,6); 40BEGIN; 41INSERT INTO t2 VALUES (8,8), (10,10); 42SELECT * FROM t2 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 DESC; 43pk key1 4410 10 458 8 466 6 47SELECT * FROM t2 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 ASC; 48pk key1 496 6 508 8 5110 10 52SELECT * FROM t2 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 DESC; 53pk key1 5410 10 558 8 566 6 57SELECT * FROM t2 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 ASC; 58pk key1 596 6 608 8 6110 10 62ROLLBACK; 63DROP TABLE t1; 64DROP TABLE t2; 65