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;