mirror of
https://github.com/MariaDB/server.git
synced 2025-11-14 17:56:17 +01:00
0a5e4a0191
Updated tests: cases with bugs or which cannot be run with the cursor-protocol were excluded with "--disable_cursor_protocol"/"--enable_cursor_protocol" Fix for v.10.5
57 lines
1.3 KiB
Text
57 lines
1.3 KiB
Text
--source include/have_rocksdb.inc
|
|
|
|
#
|
|
# Basic HANDLER counts
|
|
#
|
|
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS t1;
|
|
--enable_warnings
|
|
|
|
--disable_cursor_protocol
|
|
|
|
FLUSH STATUS;
|
|
CREATE TABLE t1 (id INT PRIMARY KEY, a VARCHAR(100), b INT,
|
|
INDEX b(b)) ENGINE=rocksdb;
|
|
INSERT INTO t1 (id,a,b) VALUES (1,'foobar',100),(2,'z',0),(3,'bar',50);
|
|
SHOW SESSION STATUS LIKE 'Handler_write%';
|
|
|
|
UPDATE t1 SET b=1000 WHERE id=1;
|
|
SHOW SESSION STATUS LIKE 'Handler_update%';
|
|
|
|
DELETE FROM t1 WHERE id=2;
|
|
SHOW SESSION STATUS LIKE 'Handler_delete%';
|
|
|
|
INSERT INTO t1 (id,b) VALUES(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);
|
|
SHOW SESSION STATUS LIKE 'Handler_write%';
|
|
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 WHERE id=8;
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
|
|
FLUSH STATUS;
|
|
SET GLOBAL rocksdb_force_flush_memtable_and_lzero_now=1;
|
|
SELECT * FROM t1 WHERE b=6;
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
|
|
FLUSH STATUS;
|
|
--sorted_result
|
|
SELECT * FROM t1;
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 FORCE INDEX(b) WHERE b <=5 ORDER BY b;
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 WHERE id >=8 ORDER BY id;
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 WHERE id < 8 ORDER BY id;
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
|
|
--enable_cursor_protocol
|
|
|
|
# Cleanup
|
|
DROP TABLE t1;
|