1 DROP TABLE IF EXISTS t1;
2 SET TIME_ZONE="+03:00";
3 CREATE TABLE t1(c1 DATE NULL, c2 DATE NULL, c3 DATE NULL, UNIQUE(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 'c1'
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 'c1'
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 NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(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 'c1'
43 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
44 ERROR 23000: Duplicate entry '1999-1999-2000' for key 'c1'
52 CREATE TABLE t1(c1 TIME NULL, c2 TIME NULL, c3 TIME NULL, UNIQUE(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 'c1'
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 'c1'
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 NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(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 'c1'
76 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
77 ERROR 23000: Duplicate entry '1999-1999-2000' for key 'c1'
85 CREATE TABLE t1(c1 DATETIME NULL, c2 DATETIME NULL, c3 DATETIME NULL, UNIQUE(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 'c1'
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 'c1'
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 NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(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 'c1'
109 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
110 ERROR 23000: Duplicate entry '1999-1999-2000' for key 'c1'
118 CREATE TABLE t1(c1 TIMESTAMP NULL, c2 TIMESTAMP NULL, c3 TIMESTAMP NULL, UNIQUE(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 'c1'
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 'c1'
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 NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(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 'c1'
142 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
143 ERROR 23000: Duplicate entry '1999-1999-2000' for key 'c1'
151 SET TIME_ZONE= @@global.time_zone;