1DROP TABLE IF EXISTS t1,t2,t3;
2SET sql_mode='NO_ENGINE_SUBSTITUTION';
3SET TIME_ZONE="+03:00";
4CREATE TABLE t1(c1 DATE NOT NULL);
5SET TIMESTAMP=1171346973;
6INSERT INTO t1 (c1) VALUES(NOW());
7Warnings:
8Note	1265	Data truncated for column 'c1' at row 1
9INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
10Warnings:
11Note	1265	Data truncated for column 'c1' at row 1
12INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
13Warnings:
14Note	1265	Data truncated for column 'c1' at row 1
15INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
16Warnings:
17Note	1265	Data truncated for column 'c1' at row 1
18INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
19Warnings:
20Note	1265	Data truncated for column 'c1' at row 1
21SELECT * FROM t1 ORDER BY c1;
22c1
232007-02-13
242007-02-14
252007-02-15
262007-02-16
272007-02-17
28UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
29Warnings:
30Note	1265	Data truncated for column 'c1' at row 4
31Note	1265	Data truncated for column 'c1' at row 5
32SELECT * FROM t1 ORDER BY c1;
33c1
342007-02-13
352007-02-13
362007-02-13
372007-02-14
382007-02-15
39DROP TABLE t1;
40CREATE TABLE t1(c1 TIME NOT NULL);
41SET TIMESTAMP=1171346973;
42INSERT INTO t1 (c1) VALUES(NOW());
43INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
44INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
45INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
46INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
47SELECT * FROM t1 ORDER BY c1;
48c1
4909:09:33
5010:10:34
5111:10:34
5212:10:34
5313:10:34
54UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
55SELECT * FROM t1 ORDER BY c1;
56c1
5709:09:33
5809:09:33
5909:09:33
6009:09:33
6110:10:34
62DROP TABLE t1;
63CREATE TABLE t1(c1 DATETIME NOT NULL);
64SET TIMESTAMP=1171346973;
65INSERT INTO t1 (c1) VALUES(NOW());
66INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
67INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
68INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
69INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
70SELECT * FROM t1 ORDER BY c1;
71c1
722007-02-13 09:09:33
732007-02-14 10:10:34
742007-02-15 11:10:34
752007-02-16 12:10:34
762007-02-17 13:10:34
77UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
78SELECT * FROM t1 ORDER BY c1;
79c1
802007-02-13 09:09:33
812007-02-13 09:09:33
822007-02-13 09:09:33
832007-02-13 09:09:33
842007-02-14 10:10:34
85DROP TABLE t1;
86CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
87SET TIMESTAMP=1171346973;
88INSERT INTO t1 (c1) VALUES(NOW());
89INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
90INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
91INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
92INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
93SELECT * FROM t1 ORDER BY c1;
94c1
952007-02-13 09:09:33
962007-02-14 10:10:34
972007-02-15 11:10:34
982007-02-16 12:10:34
992007-02-17 13:10:34
100UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
101SELECT * FROM t1 ORDER BY c1;
102c1
1032007-02-13 09:09:33
1042007-02-13 09:09:33
1052007-02-13 09:09:33
1062007-02-13 09:09:33
1072007-02-14 10:10:34
108DROP TABLE t1;
109SET TIME_ZONE= @@global.time_zone;
110SET sql_mode=default;
111