CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=LevelDB;

INSERT INTO t1 VALUES (10),(11);

SELECT pk FROM t1 WHERE pk > 5 AND pk < 15;

pk

10

10

11

EXPLAIN EXTENDED

SELECT pk FROM t1 WHERE pk > 5 AND pk < 15;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	10	100.00	Using where; Using index

Warnings:

Note	1003	/* select#1 */ select `test`.`t1`.`pk` AS `pk` from `test`.`t1` where ((`test`.`t1`.`pk` > 5) and (`test`.`t1`.`pk` < 15))

SELECT pk FROM t1 WHERE pk BETWEEN 5 AND 15;

pk

10

10

11

EXPLAIN EXTENDED

SELECT pk FROM t1 WHERE pk BETWEEN 5 AND 15;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	10	100.00	Using where; Using index

Warnings:

Note	1003	/* select#1 */ select `test`.`t1`.`pk` AS `pk` from `test`.`t1` where (`test`.`t1`.`pk` between 5 and 15)

SELECT pk FROM t1 WHERE pk > 5;

pk

10

10

11

EXPLAIN EXTENDED

SELECT pk FROM t1 WHERE pk > 5;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	10	100.00	Using where; Using index

Warnings:

Note	1003	/* select#1 */ select `test`.`t1`.`pk` AS `pk` from `test`.`t1` where (`test`.`t1`.`pk` > 5)

SELECT pk FROM t1 WHERE pk < 15;

pk

10

11

EXPLAIN EXTENDED

SELECT pk FROM t1 WHERE pk < 15;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	10	100.00	Using where; Using index

Warnings:

Note	1003	/* select#1 */ select `test`.`t1`.`pk` AS `pk` from `test`.`t1` where (`test`.`t1`.`pk` < 15)

CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=LevelDB;

INSERT INTO t1 VALUES (10),(11);

SELECT pk FROM t1 WHERE pk > 5 AND pk < 15;

SELECT pk FROM t1 WHERE pk BETWEEN 5 AND 15;

SELECT pk FROM t1 WHERE pk > 5;

SELECT pk FROM t1 WHERE pk < 15;

revision-id: psergey@askmonty.org-20130123185233-7xokxc9ck9nosb2l

revno: 4509

branch-nick: mysql-5.6-leveldb