1--source include/have_rocksdb.inc 2 3# 4# Basic HANDLER counts 5# 6 7--disable_warnings 8DROP TABLE IF EXISTS t1; 9--enable_warnings 10 11FLUSH STATUS; 12CREATE TABLE t1 (id INT PRIMARY KEY, a VARCHAR(100), b INT, 13INDEX b(b)) ENGINE=rocksdb; 14INSERT INTO t1 (id,a,b) VALUES (1,'foobar',100),(2,'z',0),(3,'bar',50); 15SHOW SESSION STATUS LIKE 'Handler_write%'; 16 17UPDATE t1 SET b=1000 WHERE id=1; 18SHOW SESSION STATUS LIKE 'Handler_update%'; 19 20DELETE FROM t1 WHERE id=2; 21SHOW SESSION STATUS LIKE 'Handler_delete%'; 22 23INSERT INTO t1 (id,b) VALUES(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10); 24SHOW SESSION STATUS LIKE 'Handler_write%'; 25 26FLUSH STATUS; 27SELECT * FROM t1 WHERE id=8; 28SHOW SESSION STATUS LIKE 'Handler_read%'; 29 30FLUSH STATUS; 31SELECT * FROM t1 WHERE b=6; 32SHOW SESSION STATUS LIKE 'Handler_read%'; 33 34FLUSH STATUS; 35--sorted_result 36SELECT * FROM t1; 37SHOW SESSION STATUS LIKE 'Handler_read%'; 38 39FLUSH STATUS; 40SELECT * FROM t1 FORCE INDEX(b) WHERE b <=5 ORDER BY b; 41SHOW SESSION STATUS LIKE 'Handler_read%'; 42 43FLUSH STATUS; 44SELECT * FROM t1 WHERE id >=8 ORDER BY id; 45SHOW SESSION STATUS LIKE 'Handler_read%'; 46 47FLUSH STATUS; 48SELECT * FROM t1 WHERE id < 8 ORDER BY id; 49SHOW SESSION STATUS LIKE 'Handler_read%'; 50 51# Cleanup 52DROP TABLE t1; 53