Debian Codegraph @

mysql-test/suite/engines/funcs/r/de_calendar_range.result

raw
1 DROP TABLE IF EXISTS t1,t2,t3;
2 SET TIME_ZONE="+03:00";
3 CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY);
4 SET TIMESTAMP=1171346973;
5 INSERT INTO t1 (c1) VALUES(NOW());
6 Warnings:
7 Note 1265 Data truncated for column 'c1' at row 1
8 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
9 Warnings:
10 Note 1265 Data truncated for column 'c1' at row 1
11 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
12 Warnings:
13 Note 1265 Data truncated for column 'c1' at row 1
14 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
15 Warnings:
16 Note 1265 Data truncated for column 'c1' at row 1
17 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
18 Warnings:
19 Note 1265 Data truncated for column 'c1' at row 1
20 SELECT * FROM t1 ORDER BY c1;
21 c1
22 2007-02-13
23 2007-02-14
24 2007-02-15
25 2007-02-16
26 2007-02-17
27 DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
28 SELECT * FROM t1 ORDER BY c1;
29 c1
30 2007-02-16
31 2007-02-17
32 DROP TABLE t1;
33 CREATE TABLE t1(c1 TIME NOT NULL PRIMARY KEY);
34 SET TIMESTAMP=1171346973;
35 INSERT INTO t1 (c1) VALUES(NOW());
36 Warnings:
37 Note 1265 Data truncated for column 'c1' at row 1
38 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
39 Warnings:
40 Note 1265 Data truncated for column 'c1' at row 1
41 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
42 Warnings:
43 Note 1265 Data truncated for column 'c1' at row 1
44 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
45 Warnings:
46 Note 1265 Data truncated for column 'c1' at row 1
47 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
48 Warnings:
49 Note 1265 Data truncated for column 'c1' at row 1
50 SELECT * FROM t1 ORDER BY c1;
51 c1
52 09:09:33
53 10:10:34
54 11:10:34
55 12:10:34
56 13:10:34
57 DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
58 SELECT * FROM t1 ORDER BY c1;
59 c1
60 DROP TABLE t1;
61 CREATE TABLE t1(c1 DATETIME NOT NULL PRIMARY KEY);
62 SET TIMESTAMP=1171346973;
63 INSERT INTO t1 (c1) VALUES(NOW());
64 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
65 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
66 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
67 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
68 SELECT * FROM t1 ORDER BY c1;
69 c1
70 2007-02-13 09:09:33
71 2007-02-14 10:10:34
72 2007-02-15 11:10:34
73 2007-02-16 12:10:34
74 2007-02-17 13:10:34
75 DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
76 SELECT * FROM t1 ORDER BY c1;
77 c1
78 2007-02-16 12:10:34
79 2007-02-17 13:10:34
80 DROP TABLE t1;
81 CREATE TABLE t1(c1 TIMESTAMP NOT NULL PRIMARY KEY);
82 SET TIMESTAMP=1171346973;
83 INSERT INTO t1 (c1) VALUES(NOW());
84 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
85 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
86 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
87 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
88 SELECT * FROM t1 ORDER BY c1;
89 c1
90 2007-02-13 09:09:33
91 2007-02-14 10:10:34
92 2007-02-15 11:10:34
93 2007-02-16 12:10:34
94 2007-02-17 13:10:34
95 DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
96 SELECT * FROM t1 ORDER BY c1;
97 c1
98 2007-02-16 12:10:34
99 2007-02-17 13:10:34
100 DROP TABLE t1;
101 SET TIME_ZONE= @@global.time_zone;