Debian Codegraph @

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

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