1--source include/have_rocksdb.inc 2 3# 4# DELETE statements for tables with keys 5# 6 7--disable_warnings 8DROP TABLE IF EXISTS t1; 9--enable_warnings 10 11CREATE TABLE t1 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY, KEY(b)) ENGINE=rocksdb; 12INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'x'),(7,'y'),(8,'z'); 13DELETE FROM t1 WHERE b > 'y'; 14DELETE FROM t1 WHERE a=2; 15 16--sorted_result 17SELECT a,b FROM t1; 18DELETE FROM t1; 19 20DROP TABLE t1; 21 22CREATE TABLE t1 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=rocksdb; 23INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'x'),(7,'y'),(8,'z'); 24DELETE FROM t1 WHERE b > 'y'; 25DELETE FROM t1 WHERE a=2; 26 27--sorted_result 28SELECT a,b FROM t1; 29DELETE FROM t1; 30DROP TABLE t1; 31 32CREATE TABLE t1 (a INT, b INT, c INT, pk INT AUTO_INCREMENT PRIMARY KEY, KEY(a), KEY (b)) ENGINE=rocksdb; 33 34INSERT INTO t1 (a,b,c) VALUES (1,2,3),(4,5,6),(7,8,9); 35DELETE FROM t1 WHERE a = 10 OR b = 20 ORDER BY c LIMIT 1; 36--sorted_result 37SELECT a,b,c FROM t1; 38DROP TABLE t1; 39 40