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 IGNORE INTO t1 (c1) VALUES(NOW());
12
Note 1265 Data truncated for column 'c1' at row 1
18
CREATE TABLE t1(c1 YEAR NULL UNIQUE);
19
INSERT INTO t1 (c1) VALUES(1999);
20
INSERT INTO t1 (c1) VALUES(2000);
21
INSERT IGNORE INTO t1 (c1) VALUES(1999);
27
CREATE TABLE t1(c1 TIME NULL UNIQUE);
28
SET TIMESTAMP=1171346973;
29
INSERT INTO t1 (c1) VALUES(NOW());
30
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
31
INSERT IGNORE INTO t1 (c1) VALUES(NOW());
37
CREATE TABLE t1(c1 YEAR NULL UNIQUE);
38
INSERT INTO t1 (c1) VALUES(1999);
39
INSERT INTO t1 (c1) VALUES(2000);
40
INSERT IGNORE INTO t1 (c1) VALUES(1999);
46
CREATE TABLE t1(c1 DATETIME NULL UNIQUE);
47
SET TIMESTAMP=1171346973;
48
INSERT INTO t1 (c1) VALUES(NOW());
49
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
50
INSERT IGNORE INTO t1 (c1) VALUES(NOW());
56
CREATE TABLE t1(c1 YEAR NULL UNIQUE);
57
INSERT INTO t1 (c1) VALUES(1999);
58
INSERT INTO t1 (c1) VALUES(2000);
59
INSERT IGNORE INTO t1 (c1) VALUES(1999);
65
CREATE TABLE t1(c1 TIMESTAMP NULL UNIQUE);
66
SET TIMESTAMP=1171346973;
67
INSERT INTO t1 (c1) VALUES(NOW());
68
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
69
INSERT IGNORE INTO t1 (c1) VALUES(NOW());
75
CREATE TABLE t1(c1 YEAR NULL UNIQUE);
76
INSERT INTO t1 (c1) VALUES(1999);
77
INSERT INTO t1 (c1) VALUES(2000);
78
INSERT IGNORE INTO t1 (c1) VALUES(1999);