1
DROP TABLE IF EXISTS t1;
2
SET TIME_ZONE="+03:00";
3
CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 DATE NOT NULL, PRIMARY KEY(c1,c2,c3));
4
SET TIMESTAMP=1171346973;
5
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
7
Note 1265 Data truncated for column 'c1' at row 1
8
Note 1265 Data truncated for column 'c2' at row 1
9
Note 1265 Data truncated for column 'c3' at row 1
10
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
12
Note 1265 Data truncated for column 'c1' at row 1
13
Note 1265 Data truncated for column 'c2' at row 1
14
Note 1265 Data truncated for column 'c3' at row 1
15
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
17
Note 1265 Data truncated for column 'c1' at row 1
18
Note 1265 Data truncated for column 'c2' at row 1
19
Note 1265 Data truncated for column 'c3' at row 1
20
INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
22
Note 1265 Data truncated for column 'c1' at row 1
23
Note 1265 Data truncated for column 'c2' at row 1
24
Note 1265 Data truncated for column 'c3' at row 1
25
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
26
ERROR 23000: Duplicate entry '2007-02-13-2007-02-13-2007-02-13' for key 'PRIMARY'
27
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
28
ERROR 23000: Duplicate entry '2007-02-13-2007-02-13-2007-02-14' for key 'PRIMARY'
31
2007-02-13 2007-02-13 2007-02-13
32
2007-02-13 2007-02-13 2007-02-14
33
2007-02-13 2007-02-14 2007-02-13
34
2007-02-14 2007-02-13 2007-02-13
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);
42
ERROR 23000: Duplicate entry '1999-1999-1999' for key 'PRIMARY'
43
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
44
ERROR 23000: Duplicate entry '1999-1999-2000' for key 'PRIMARY'
52
CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL, PRIMARY KEY(c1,c2,c3));
53
SET TIMESTAMP=1171346973;
54
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
55
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
56
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
57
INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
58
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
59
ERROR 23000: Duplicate entry '09:09:33-09:09:33-09:09:33' for key 'PRIMARY'
60
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
61
ERROR 23000: Duplicate entry '09:09:33-09:09:33-10:10:34' for key 'PRIMARY'
64
09:09:33 09:09:33 09:09:33
65
09:09:33 09:09:33 10:10:34
66
09:09:33 10:10:34 09:09:33
67
10:10:34 09:09:33 09:09:33
69
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
70
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
71
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
72
INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
73
INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
74
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
75
ERROR 23000: Duplicate entry '1999-1999-1999' for key 'PRIMARY'
76
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
77
ERROR 23000: Duplicate entry '1999-1999-2000' for key 'PRIMARY'
85
CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NOT NULL, c3 DATETIME NOT NULL, PRIMARY KEY(c1,c2,c3));
86
SET TIMESTAMP=1171346973;
87
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
88
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
89
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
90
INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
91
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
92
ERROR 23000: Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-13 09:09:33' for key 'PRIMARY'
93
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
94
ERROR 23000: Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-14 10:10:34' for key 'PRIMARY'
97
2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-13 09:09:33
98
2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-14 10:10:34
99
2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
100
2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
102
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
103
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
104
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
105
INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
106
INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
107
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
108
ERROR 23000: Duplicate entry '1999-1999-1999' for key 'PRIMARY'
109
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
110
ERROR 23000: Duplicate entry '1999-1999-2000' for key 'PRIMARY'
118
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL, PRIMARY KEY(c1,c2,c3));
119
SET TIMESTAMP=1171346973;
120
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
121
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
122
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
123
INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
124
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
125
ERROR 23000: Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-13 09:09:33' for key 'PRIMARY'
126
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
127
ERROR 23000: Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-14 10:10:34' for key 'PRIMARY'
130
2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-13 09:09:33
131
2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-14 10:10:34
132
2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
133
2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
135
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
136
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
137
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
138
INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
139
INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
140
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
141
ERROR 23000: Duplicate entry '1999-1999-1999' for key 'PRIMARY'
142
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
143
ERROR 23000: Duplicate entry '1999-1999-2000' for key 'PRIMARY'
151
SET TIME_ZONE= @@global.time_zone;