2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 DATE NOT NULL, PRIMARY KEY(c1,c2,c3));
5
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
6
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
7
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
8
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
9
INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
10
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');
11
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');
15
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
16
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
17
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
18
INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
19
INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
20
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
21
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
25
CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL, PRIMARY KEY(c1,c2,c3));
26
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
27
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
28
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
29
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
30
INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
31
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');
32
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');
36
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
37
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
38
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
39
INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
40
INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
41
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
42
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
46
CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NOT NULL, c3 DATETIME NOT NULL, PRIMARY KEY(c1,c2,c3));
47
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
48
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
49
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
50
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
51
INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
52
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');
53
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');
57
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
58
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
59
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
60
INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
61
INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
62
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
63
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
67
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL, PRIMARY KEY(c1,c2,c3));
68
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
69
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
70
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
71
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
72
INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
73
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');
74
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');
78
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
79
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
80
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
81
INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
82
INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
83
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
84
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;