Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_multicolumn_calendar_unique_constraint_ignore.result

raw
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());
6 Warnings:
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'));
11 Warnings:
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());
16 Warnings:
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());
21 Warnings:
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 IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
26 Warnings:
27 Note 1265 Data truncated for column 'c1' at row 1
28 Note 1265 Data truncated for column 'c2' at row 1
29 Note 1265 Data truncated for column 'c3' at row 1
30 Warning 1062 Duplicate entry '2007-02-13-2007-02-13-2007-02-13' for key 'c1'
31 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
32 Warnings:
33 Note 1265 Data truncated for column 'c1' at row 1
34 Note 1265 Data truncated for column 'c2' at row 1
35 Note 1265 Data truncated for column 'c3' at row 1
36 Warning 1062 Duplicate entry '2007-02-13-2007-02-13-2007-02-14' for key 'c1'
37 SELECT * FROM t1;
38 c1 c2 c3
39 2007-02-13 2007-02-13 2007-02-13
40 2007-02-13 2007-02-13 2007-02-14
41 2007-02-13 2007-02-14 2007-02-13
42 2007-02-14 2007-02-13 2007-02-13
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 YEAR NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(c1,c2,c3));
45 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
46 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
47 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
48 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
49 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
50 Warnings:
51 Warning 1062 Duplicate entry '1999-1999-1999' for key 'c1'
52 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
53 Warnings:
54 Warning 1062 Duplicate entry '1999-1999-2000' for key 'c1'
55 SELECT * FROM t1;
56 c1 c2 c3
57 1999 1999 1999
58 1999 1999 2000
59 1999 2000 1999
60 2000 1999 1999
61 DROP TABLE t1;
62 CREATE TABLE t1(c1 TIME NULL, c2 TIME NULL, c3 TIME NULL, UNIQUE(c1,c2,c3));
63 SET TIMESTAMP=1171346973;
64 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
65 Warnings:
66 Note 1265 Data truncated for column 'c1' at row 1
67 Note 1265 Data truncated for column 'c2' at row 1
68 Note 1265 Data truncated for column 'c3' at row 1
69 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
70 Warnings:
71 Note 1265 Data truncated for column 'c1' at row 1
72 Note 1265 Data truncated for column 'c2' at row 1
73 Note 1265 Data truncated for column 'c3' at row 1
74 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
75 Warnings:
76 Note 1265 Data truncated for column 'c1' at row 1
77 Note 1265 Data truncated for column 'c2' at row 1
78 Note 1265 Data truncated for column 'c3' at row 1
79 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
80 Warnings:
81 Note 1265 Data truncated for column 'c1' at row 1
82 Note 1265 Data truncated for column 'c2' at row 1
83 Note 1265 Data truncated for column 'c3' at row 1
84 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
85 Warnings:
86 Note 1265 Data truncated for column 'c1' at row 1
87 Note 1265 Data truncated for column 'c2' at row 1
88 Note 1265 Data truncated for column 'c3' at row 1
89 Warning 1062 Duplicate entry '09:09:33-09:09:33-09:09:33' for key 'c1'
90 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
91 Warnings:
92 Note 1265 Data truncated for column 'c1' at row 1
93 Note 1265 Data truncated for column 'c2' at row 1
94 Note 1265 Data truncated for column 'c3' at row 1
95 Warning 1062 Duplicate entry '09:09:33-09:09:33-10:10:34' for key 'c1'
96 SELECT * FROM t1;
97 c1 c2 c3
98 09:09:33 09:09:33 09:09:33
99 09:09:33 09:09:33 10:10:34
100 09:09:33 10:10:34 09:09:33
101 10:10:34 09:09:33 09:09:33
102 DROP TABLE t1;
103 CREATE TABLE t1(c1 YEAR NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(c1,c2,c3));
104 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
105 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
106 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
107 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
108 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
109 Warnings:
110 Warning 1062 Duplicate entry '1999-1999-1999' for key 'c1'
111 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
112 Warnings:
113 Warning 1062 Duplicate entry '1999-1999-2000' for key 'c1'
114 SELECT * FROM t1;
115 c1 c2 c3
116 1999 1999 1999
117 1999 1999 2000
118 1999 2000 1999
119 2000 1999 1999
120 DROP TABLE t1;
121 CREATE TABLE t1(c1 DATETIME NULL, c2 DATETIME NULL, c3 DATETIME NULL, UNIQUE(c1,c2,c3));
122 SET TIMESTAMP=1171346973;
123 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
124 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
125 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
126 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
127 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
128 Warnings:
129 Warning 1062 Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-13 09:09:33' for key 'c1'
130 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
131 Warnings:
132 Warning 1062 Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-14 10:10:34' for key 'c1'
133 SELECT * FROM t1;
134 c1 c2 c3
135 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-13 09:09:33
136 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-14 10:10:34
137 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
138 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
139 DROP TABLE t1;
140 CREATE TABLE t1(c1 YEAR NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(c1,c2,c3));
141 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
142 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
143 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
144 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
145 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
146 Warnings:
147 Warning 1062 Duplicate entry '1999-1999-1999' for key 'c1'
148 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
149 Warnings:
150 Warning 1062 Duplicate entry '1999-1999-2000' for key 'c1'
151 SELECT * FROM t1;
152 c1 c2 c3
153 1999 1999 1999
154 1999 1999 2000
155 1999 2000 1999
156 2000 1999 1999
157 DROP TABLE t1;
158 CREATE TABLE t1(c1 TIMESTAMP NULL, c2 TIMESTAMP NULL, c3 TIMESTAMP NULL, UNIQUE(c1,c2,c3));
159 SET TIMESTAMP=1171346973;
160 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
161 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
162 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
163 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
164 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
165 Warnings:
166 Warning 1062 Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-13 09:09:33' for key 'c1'
167 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
168 Warnings:
169 Warning 1062 Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-14 10:10:34' for key 'c1'
170 SELECT * FROM t1;
171 c1 c2 c3
172 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-13 09:09:33
173 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-14 10:10:34
174 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
175 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
176 DROP TABLE t1;
177 CREATE TABLE t1(c1 YEAR NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(c1,c2,c3));
178 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
179 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
180 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
181 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
182 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
183 Warnings:
184 Warning 1062 Duplicate entry '1999-1999-1999' for key 'c1'
185 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
186 Warnings:
187 Warning 1062 Duplicate entry '1999-1999-2000' for key 'c1'
188 SELECT * FROM t1;
189 c1 c2 c3
190 1999 1999 1999
191 1999 1999 2000
192 1999 2000 1999
193 2000 1999 1999
194 DROP TABLE t1;
195 SET TIME_ZONE= @@global.time_zone;