blob: 92e7f51ff6e2ba5ab69272663811663926fb62ae (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
DROP TABLE IF EXISTS ranges;
CREATE TABLE ranges (
id INT PRIMARY KEY,
start DATE,
end DATE,
UNIQUE KEY range_key(start, end)
);
INSERT INTO ranges VALUES (1, "2012-10-25", "9999-12-31");
INSERT INTO ranges VALUES (2, "1000-01-01", "2012-10-05");
INSERT INTO ranges VALUES (3, "9999-12-31", "1000-01-01");
INSERT INTO ranges VALUES (4, "1000-01-01", "9999-12-31");
SELECT * FROM ranges FORCE INDEX(range_key)
ORDER BY start, end;
id start end
2 1000-01-01 2012-10-05
4 1000-01-01 9999-12-31
1 2012-10-25 9999-12-31
3 9999-12-31 1000-01-01
DROP TABLE ranges;
|