1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4SET sql_mode='NO_ENGINE_SUBSTITUTION'; 5# Set Correct timezone to match result 6SET TIME_ZONE="+03:00"; 7CREATE TABLE t1(c1 DATE NULL UNIQUE); 8SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33 9INSERT INTO t1 (c1) VALUES(NOW()); 10INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 11INSERT IGNORE INTO t1 (c1) VALUES(NOW()); 12SELECT * FROM t1; 13DROP TABLE t1; 14CREATE TABLE t1(c1 YEAR NULL UNIQUE); 15INSERT INTO t1 (c1) VALUES(1999); 16INSERT INTO t1 (c1) VALUES(2000); 17INSERT IGNORE INTO t1 (c1) VALUES(1999); 18SELECT * FROM t1; 19DROP TABLE t1; 20CREATE TABLE t1(c1 TIME NULL UNIQUE); 21SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33 22INSERT INTO t1 (c1) VALUES(NOW()); 23INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 24INSERT IGNORE INTO t1 (c1) VALUES(NOW()); 25SELECT * FROM t1; 26DROP TABLE t1; 27CREATE TABLE t1(c1 YEAR NULL UNIQUE); 28INSERT INTO t1 (c1) VALUES(1999); 29INSERT INTO t1 (c1) VALUES(2000); 30INSERT IGNORE INTO t1 (c1) VALUES(1999); 31SELECT * FROM t1; 32DROP TABLE t1; 33CREATE TABLE t1(c1 DATETIME NULL UNIQUE); 34SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33 35INSERT INTO t1 (c1) VALUES(NOW()); 36INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 37INSERT IGNORE INTO t1 (c1) VALUES(NOW()); 38SELECT * FROM t1; 39DROP TABLE t1; 40CREATE TABLE t1(c1 YEAR NULL UNIQUE); 41INSERT INTO t1 (c1) VALUES(1999); 42INSERT INTO t1 (c1) VALUES(2000); 43INSERT IGNORE INTO t1 (c1) VALUES(1999); 44SELECT * FROM t1; 45DROP TABLE t1; 46CREATE TABLE t1(c1 TIMESTAMP NULL UNIQUE); 47SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33 48INSERT INTO t1 (c1) VALUES(NOW()); 49INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 50INSERT IGNORE INTO t1 (c1) VALUES(NOW()); 51SELECT * FROM t1; 52DROP TABLE t1; 53CREATE TABLE t1(c1 YEAR NULL UNIQUE); 54INSERT INTO t1 (c1) VALUES(1999); 55INSERT INTO t1 (c1) VALUES(2000); 56INSERT IGNORE INTO t1 (c1) VALUES(1999); 57SELECT * FROM t1; 58DROP TABLE t1; 59#restore timezone to default 60SET TIME_ZONE= @@global.time_zone; 61SET sql_mode=default; 62