1DROP TABLE IF EXISTS t1; 2SET sql_mode='NO_ENGINE_SUBSTITUTION'; 3SET TIME_ZONE="+03:00"; 4CREATE TABLE t1(c1 DATE NULL UNIQUE); 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(NOW()); 13ERROR 23000: Duplicate entry '2007-02-13' for key 't1.c1' 14SELECT * FROM t1; 15c1 162007-02-13 172007-02-14 18DROP TABLE t1; 19CREATE TABLE t1(c1 YEAR NULL UNIQUE); 20INSERT INTO t1 (c1) VALUES(1999); 21INSERT INTO t1 (c1) VALUES(2000); 22INSERT INTO t1 (c1) VALUES(1999); 23ERROR 23000: Duplicate entry '1999' for key 't1.c1' 24SELECT * FROM t1; 25c1 261999 272000 28DROP TABLE t1; 29CREATE TABLE t1(c1 TIME NULL UNIQUE); 30SET TIMESTAMP=1171346973; 31INSERT INTO t1 (c1) VALUES(NOW()); 32INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 33INSERT INTO t1 (c1) VALUES(NOW()); 34ERROR 23000: Duplicate entry '09:09:33' for key 't1.c1' 35SELECT * FROM t1; 36c1 3709:09:33 3810:10:34 39DROP TABLE t1; 40CREATE TABLE t1(c1 YEAR NULL UNIQUE); 41INSERT INTO t1 (c1) VALUES(1999); 42INSERT INTO t1 (c1) VALUES(2000); 43INSERT INTO t1 (c1) VALUES(1999); 44ERROR 23000: Duplicate entry '1999' for key 't1.c1' 45SELECT * FROM t1; 46c1 471999 482000 49DROP TABLE t1; 50CREATE TABLE t1(c1 DATETIME NULL UNIQUE); 51SET TIMESTAMP=1171346973; 52INSERT INTO t1 (c1) VALUES(NOW()); 53INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 54INSERT INTO t1 (c1) VALUES(NOW()); 55ERROR 23000: Duplicate entry '2007-02-13 09:09:33' for key 't1.c1' 56SELECT * FROM t1; 57c1 582007-02-13 09:09:33 592007-02-14 10:10:34 60DROP TABLE t1; 61CREATE TABLE t1(c1 YEAR NULL UNIQUE); 62INSERT INTO t1 (c1) VALUES(1999); 63INSERT INTO t1 (c1) VALUES(2000); 64INSERT INTO t1 (c1) VALUES(1999); 65ERROR 23000: Duplicate entry '1999' for key 't1.c1' 66SELECT * FROM t1; 67c1 681999 692000 70DROP TABLE t1; 71CREATE TABLE t1(c1 TIMESTAMP NULL UNIQUE); 72SET TIMESTAMP=1171346973; 73INSERT INTO t1 (c1) VALUES(NOW()); 74INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 75INSERT INTO t1 (c1) VALUES(NOW()); 76ERROR 23000: Duplicate entry '2007-02-13 09:09:33' for key 't1.c1' 77SELECT * FROM t1; 78c1 792007-02-13 09:09:33 802007-02-14 10:10:34 81DROP TABLE t1; 82CREATE TABLE t1(c1 YEAR NULL UNIQUE); 83INSERT INTO t1 (c1) VALUES(1999); 84INSERT INTO t1 (c1) VALUES(2000); 85INSERT INTO t1 (c1) VALUES(1999); 86ERROR 23000: Duplicate entry '1999' for key 't1.c1' 87SELECT * FROM t1; 88c1 891999 902000 91DROP TABLE t1; 92SET TIME_ZONE= @@global.time_zone; 93SET sql_mode=default; 94