2 DROP TABLE IF EXISTS t1;
4 # Set Correct timezone to match result
5 SET TIME_ZONE="+03:00";
6 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 DATE NOT NULL, PRIMARY KEY(c1,c2,c3));
7 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
8 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
9 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
10 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
11 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
12 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
13 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
17 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
18 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
19 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
20 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
21 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
22 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
23 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
27 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL, PRIMARY KEY(c1,c2,c3));
28 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
29 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
30 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
31 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
32 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
33 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
34 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
38 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
39 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
40 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
41 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
42 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
43 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
44 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
48 CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NOT NULL, c3 DATETIME NOT NULL, PRIMARY KEY(c1,c2,c3));
49 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
50 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
51 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
52 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
53 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
54 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
55 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
59 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
60 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
61 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
62 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
63 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
64 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
65 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
69 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL, PRIMARY KEY(c1,c2,c3));
70 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
71 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
72 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
73 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
74 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
75 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
76 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
80 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
81 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
82 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
83 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
84 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
85 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
86 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
90 # Restore timezone to default
91 SET TIME_ZONE= @@global.time_zone;