EVOLUTION-MANAGER

Edit File: optimization_count_skip_index_greater.result

DROP TABLE IF EXISTS users; FLUSH STATUS; CREATE TABLE users ( age INT, INDEX (age) ) DEFAULT CHARSET=UTF8; INSERT INTO users (age) VALUES (27); INSERT INTO users (age) VALUES (28); INSERT INTO users (age) VALUES (29); INSERT INTO users (age) VALUES (30); INSERT INTO users (age) VALUES (31); SELECT COUNT(*) FROM users WHERE age > 29; COUNT(*) 2 SHOW STATUS LIKE 'mroonga_count_skip'; Variable_name Value Mroonga_count_skip 1 DROP TABLE users;