blob: a040ab1ed0e4cd0d5634e1e153d05a519e6d1eb9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
DROP TABLE IF EXISTS ranges;
SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
CREATE TABLE ranges (
id int PRIMARY KEY,
start timestamp,
end timestamp,
UNIQUE KEY range_key(start, end)
);
SET sql_mode = DEFAULT;
INSERT INTO ranges VALUES (1, "2012-10-25 16:18:29", "2038-01-18 15:14:07");
INSERT INTO ranges VALUES (2, "1970-01-01 12:00:00", "2012-10-05 16:18:29");
INSERT INTO ranges VALUES (3, "2038-01-18 15:14:07", "1970-01-01 12:00:00");
INSERT INTO ranges VALUES (4, "1970-01-01 12:00:00", "2038-01-18 15:14:07");
SELECT * FROM ranges FORCE INDEX(range_key)
ORDER BY start, end;
id start end
2 1970-01-01 12:00:00 2012-10-05 16:18:29
4 1970-01-01 12:00:00 2038-01-18 15:14:07
1 2012-10-25 16:18:29 2038-01-18 15:14:07
3 2038-01-18 15:14:07 1970-01-01 12:00:00
DROP TABLE ranges;
|
