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