1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY);
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());
11
ERROR 23000: Duplicate entry '2007-02-13' for key 'PRIMARY'
17
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
18
INSERT INTO t1 (c1) VALUES(1999);
19
INSERT INTO t1 (c1) VALUES(2000);
20
INSERT INTO t1 (c1) VALUES(1999);
21
ERROR 23000: Duplicate entry '1999' for key 'PRIMARY'
27
CREATE TABLE t1(c1 TIME NOT NULL PRIMARY KEY);
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 INTO t1 (c1) VALUES(NOW());
32
ERROR 23000: Duplicate entry '09:09:33' for key 'PRIMARY'
38
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
39
INSERT INTO t1 (c1) VALUES(1999);
40
INSERT INTO t1 (c1) VALUES(2000);
41
INSERT INTO t1 (c1) VALUES(1999);
42
ERROR 23000: Duplicate entry '1999' for key 'PRIMARY'
48
CREATE TABLE t1(c1 DATETIME NOT NULL PRIMARY KEY);
49
SET TIMESTAMP=1171346973;
50
INSERT INTO t1 (c1) VALUES(NOW());
51
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
52
INSERT INTO t1 (c1) VALUES(NOW());
53
ERROR 23000: Duplicate entry '2007-02-13 09:09:33' for key 'PRIMARY'
59
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
60
INSERT INTO t1 (c1) VALUES(1999);
61
INSERT INTO t1 (c1) VALUES(2000);
62
INSERT INTO t1 (c1) VALUES(1999);
63
ERROR 23000: Duplicate entry '1999' for key 'PRIMARY'
69
CREATE TABLE t1(c1 TIMESTAMP NOT NULL PRIMARY KEY);
70
SET TIMESTAMP=1171346973;
71
INSERT INTO t1 (c1) VALUES(NOW());
72
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
73
INSERT INTO t1 (c1) VALUES(NOW());
74
ERROR 23000: Duplicate entry '2007-02-13 09:09:33' for key 'PRIMARY'
80
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
81
INSERT INTO t1 (c1) VALUES(1999);
82
INSERT INTO t1 (c1) VALUES(2000);
83
INSERT INTO t1 (c1) VALUES(1999);
84
ERROR 23000: Duplicate entry '1999' for key 'PRIMARY'