1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 DATE NULL UNIQUE);
3
SET TIMESTAMP=1171346973;
4
INSERT INTO t1 (c1) VALUES(NOW());
6
Note 1265 Data truncated for column 'c1' at row 1
7
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
9
Note 1265 Data truncated for column 'c1' at row 1
10
INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
12
Note 1265 Data truncated for column 'c1' at row 1
13
Note 1265 Data truncated for column 'c1' at row 1
19
CREATE TABLE t1(c1 YEAR NULL UNIQUE);
20
INSERT INTO t1 (c1) VALUES(1999);
21
INSERT INTO t1 (c1) VALUES(2000);
22
INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
28
CREATE TABLE t1(c1 TIME NULL UNIQUE);
29
SET TIMESTAMP=1171346973;
30
INSERT INTO t1 (c1) VALUES(NOW());
31
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
32
INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
38
CREATE TABLE t1(c1 YEAR NULL UNIQUE);
39
INSERT INTO t1 (c1) VALUES(1999);
40
INSERT INTO t1 (c1) VALUES(2000);
41
INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
47
CREATE TABLE t1(c1 DATETIME NULL UNIQUE);
48
SET TIMESTAMP=1171346973;
49
INSERT INTO t1 (c1) VALUES(NOW());
50
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
51
INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
57
CREATE TABLE t1(c1 YEAR NULL UNIQUE);
58
INSERT INTO t1 (c1) VALUES(1999);
59
INSERT INTO t1 (c1) VALUES(2000);
60
INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
66
CREATE TABLE t1(c1 TIMESTAMP NULL UNIQUE);
67
SET TIMESTAMP=1171346973;
68
INSERT INTO t1 (c1) VALUES(NOW());
69
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
70
INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
76
CREATE TABLE t1(c1 YEAR NULL UNIQUE);
77
INSERT INTO t1 (c1) VALUES(1999);
78
INSERT INTO t1 (c1) VALUES(2000);
79
INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;