1DROP TABLE IF EXISTS ids;
2CREATE TABLE ids (
3id DOUBLE,
4value DOUBLE,
5KEY (id, value)
6);
7INSERT INTO ids VALUES ( -1.1,  16.16);
8INSERT INTO ids VALUES ( -2.2,   8.8);
9INSERT INTO ids VALUES ( -4.4,   4.4);
10INSERT INTO ids VALUES ( -8.8,   2.2);
11INSERT INTO ids VALUES (-16.6,   1.1);
12INSERT INTO ids VALUES ( 16.6,  -1.1);
13INSERT INTO ids VALUES (  8.8,  -2.2);
14INSERT INTO ids VALUES (  4.4,  -4.4);
15INSERT INTO ids VALUES (  2.2,  -8.8);
16INSERT INTO ids VALUES (  1.1, -16.16);
17SELECT * FROM ids;
18id	value
19-16.6	1.1
20-8.8	2.2
21-4.4	4.4
22-2.2	8.8
23-1.1	16.16
241.1	-16.16
252.2	-8.8
264.4	-4.4
278.8	-2.2
2816.6	-1.1
29SELECT * FROM ids WHERE id BETWEEN -4.5 AND 8.9;
30id	value
31-4.4	4.4
32-2.2	8.8
33-1.1	16.16
341.1	-16.16
352.2	-8.8
364.4	-4.4
378.8	-2.2
38DROP TABLE ids;
39