Debian Codegraph @

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