blob: 820ee4f44658a1482f94d0ee0b0a261b13276c25 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
DROP TABLE IF EXISTS ranges;
CREATE TABLE ranges (
id INT PRIMARY KEY,
start DATE,
end DATE,
UNIQUE KEY range_key(start, end)
);
INSERT IGNORE INTO ranges VALUES (1, "2012-10-25", "9999-12-31");
Warnings:
Warning 1265 Data truncated for column 'end' at row 1
INSERT IGNORE INTO ranges VALUES (2, "1000-01-01", "2012-10-05");
Warnings:
Warning 1265 Data truncated for column 'start' at row 1
INSERT IGNORE INTO ranges VALUES (3, "9999-12-31", "1000-01-01");
Warnings:
Warning 1265 Data truncated for column 'start' at row 1
Warning 1265 Data truncated for column 'end' at row 1
INSERT IGNORE INTO ranges VALUES (4, "1000-01-01", "9999-12-31");
Warnings:
Warning 1265 Data truncated for column 'start' at row 1
Warning 1265 Data truncated for column 'end' at row 1
SELECT * FROM ranges FORCE INDEX(range_key)
ORDER BY start DESC, end DESC;
id start end
3 1970-01-01 1970-01-01
1 2012-10-25 1970-01-01
4 1970-01-01 1970-01-01
2 1970-01-01 2012-10-05
DROP TABLE ranges;
|
