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