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