blob: c4a1c5f4668821fcbf2de1cbced895cb95fb12e7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
CREATE TABLE t1 (
`id1` int unsigned NOT NULL DEFAULT '0',
`id2` int unsigned NOT NULL DEFAULT '0',
`link_type` int unsigned NOT NULL DEFAULT '0',
`visibility` tinyint NOT NULL DEFAULT '0',
`data` varchar(255) NOT NULL DEFAULT '',
`time` int unsigned NOT NULL DEFAULT '0',
`version` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id1, link_type, visibility, id2) COMMENT 'rev:cf_link_pk'
) ENGINE=RocksDB DEFAULT COLLATE=latin1_bin;
CREATE PROCEDURE select_test()
BEGIN
DECLARE id1_cond INT;
SET id1_cond = 1;
WHILE id1_cond <= 20000 DO
SELECT count(*) AS cnt FROM (SELECT id1 FROM t1 FORCE INDEX (PRIMARY) WHERE id1 = id1_cond AND link_type = 1 AND visibility = 1 ORDER BY id2 DESC) AS t INTO @cnt;
IF @cnt < 1 THEN
SELECT id1_cond, @cnt;
END IF;
SET id1_cond = id1_cond + 1;
END WHILE;
END//
Warnings:
Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead
"Skipping bloom filter"
SET session rocksdb_skip_bloom_filter_on_read=1;
CALL select_test();
"Using bloom filter"
SET session rocksdb_skip_bloom_filter_on_read=0;
CALL select_test();
DROP PROCEDURE select_test;
drop table t1;
|
