1
DROP TABLE IF EXISTS t1;
2
SET TIME_ZONE="+03:00";
3
CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY);
4
SET TIMESTAMP=1171346973;
5
INSERT INTO t1 (c1) VALUES(NOW());
7
Note 1265 Data truncated for column 'c1' at row 1
8
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
10
Note 1265 Data truncated for column 'c1' at row 1
11
INSERT INTO t1 (c1) VALUES(NOW());
12
ERROR 23000: Duplicate entry '2007-02-13' for key 'PRIMARY'
18
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
19
INSERT INTO t1 (c1) VALUES(1999);
20
INSERT INTO t1 (c1) VALUES(2000);
21
INSERT INTO t1 (c1) VALUES(1999);
22
ERROR 23000: Duplicate entry '1999' for key 'PRIMARY'
28
CREATE TABLE t1(c1 TIME NOT NULL PRIMARY KEY);
29
SET TIMESTAMP=1171346973;
30
INSERT INTO t1 (c1) VALUES(NOW());
32
Note 1265 Data truncated for column 'c1' at row 1
33
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
35
Note 1265 Data truncated for column 'c1' at row 1
36
INSERT INTO t1 (c1) VALUES(NOW());
37
ERROR 23000: Duplicate entry '09:09:33' for key 'PRIMARY'
43
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
44
INSERT INTO t1 (c1) VALUES(1999);
45
INSERT INTO t1 (c1) VALUES(2000);
46
INSERT INTO t1 (c1) VALUES(1999);
47
ERROR 23000: Duplicate entry '1999' for key 'PRIMARY'
53
CREATE TABLE t1(c1 DATETIME NOT NULL PRIMARY KEY);
54
SET TIMESTAMP=1171346973;
55
INSERT INTO t1 (c1) VALUES(NOW());
56
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
57
INSERT INTO t1 (c1) VALUES(NOW());
58
ERROR 23000: Duplicate entry '2007-02-13 09:09:33' for key 'PRIMARY'
64
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
65
INSERT INTO t1 (c1) VALUES(1999);
66
INSERT INTO t1 (c1) VALUES(2000);
67
INSERT INTO t1 (c1) VALUES(1999);
68
ERROR 23000: Duplicate entry '1999' for key 'PRIMARY'
74
CREATE TABLE t1(c1 TIMESTAMP NOT NULL PRIMARY KEY);
75
SET TIMESTAMP=1171346973;
76
INSERT INTO t1 (c1) VALUES(NOW());
77
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
78
INSERT INTO t1 (c1) VALUES(NOW());
79
ERROR 23000: Duplicate entry '2007-02-13 09:09:33' for key 'PRIMARY'
85
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
86
INSERT INTO t1 (c1) VALUES(1999);
87
INSERT INTO t1 (c1) VALUES(2000);
88
INSERT INTO t1 (c1) VALUES(1999);
89
ERROR 23000: Duplicate entry '1999' for key 'PRIMARY'
95
SET TIME_ZONE= @@global.time_zone;