Debian Codegraph @

mysql-test/suite/engines/funcs/r/up_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);
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 UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
28 Warnings:
29 Note 1265 Data truncated for column 'c1' at row 4
30 Note 1265 Data truncated for column 'c1' at row 5
31 SELECT * FROM t1 ORDER BY c1;
32 c1
33 2007-02-13
34 2007-02-13
35 2007-02-13
36 2007-02-14
37 2007-02-15
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 TIME NOT NULL);
40 SET TIMESTAMP=1171346973;
41 INSERT INTO t1 (c1) VALUES(NOW());
42 Warnings:
43 Note 1265 Data truncated for column 'c1' at row 1
44 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
45 Warnings:
46 Note 1265 Data truncated for column 'c1' at row 1
47 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
48 Warnings:
49 Note 1265 Data truncated for column 'c1' at row 1
50 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
51 Warnings:
52 Note 1265 Data truncated for column 'c1' at row 1
53 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
54 Warnings:
55 Note 1265 Data truncated for column 'c1' at row 1
56 SELECT * FROM t1 ORDER BY c1;
57 c1
58 09:09:33
59 10:10:34
60 11:10:34
61 12:10:34
62 13:10:34
63 UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
64 SELECT * FROM t1 ORDER BY c1;
65 c1
66 09:09:33
67 10:10:34
68 11:10:34
69 12:10:34
70 13:10:34
71 DROP TABLE t1;
72 CREATE TABLE t1(c1 DATETIME NOT NULL);
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 UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
87 SELECT * FROM t1 ORDER BY c1;
88 c1
89 2007-02-13 09:09:33
90 2007-02-13 09:09:33
91 2007-02-13 09:09:33
92 2007-02-13 09:09:33
93 2007-02-14 10:10:34
94 DROP TABLE t1;
95 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
96 SET TIMESTAMP=1171346973;
97 INSERT INTO t1 (c1) VALUES(NOW());
98 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
99 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
100 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
101 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
102 SELECT * FROM t1 ORDER BY c1;
103 c1
104 2007-02-13 09:09:33
105 2007-02-14 10:10:34
106 2007-02-15 11:10:34
107 2007-02-16 12:10:34
108 2007-02-17 13:10:34
109 UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
110 SELECT * FROM t1 ORDER BY c1;
111 c1
112 2007-02-13 09:09:33
113 2007-02-13 09:09:33
114 2007-02-13 09:09:33
115 2007-02-13 09:09:33
116 2007-02-14 10:10:34
117 DROP TABLE t1;
118 SET TIME_ZONE= @@global.time_zone;