summaryrefslogtreecommitdiff
path: root/storage/mroonga/mysql-test/mroonga/storage/r/index_range_primary_greater_than_or_equal_asc.result
blob: 4c1ff997d79fe4a0b4c0011774f55e664fe4bc91 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
DROP TABLE IF EXISTS ids;
SET NAMES UTF8;
CREATE TABLE ids (
id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT
) ENGINE=Mroonga DEFAULT CHARSET=utf8;
INSERT INTO ids VALUES();
INSERT INTO ids VALUES();
INSERT INTO ids VALUES();
INSERT INTO ids VALUES();
INSERT INTO ids VALUES();
SELECT * FROM ids WHERE ids.id >= 2 ORDER BY ids.id ASC LIMIT 3;
id
2
3
4
DROP TABLE ids;