Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NULL, c2 TINYINT NULL, c3 TINYINT NULL, UNIQUE(c1,c2,c3));
3 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
4 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
5 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
6 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
7 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
8 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
9 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
10 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
11 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
12 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
13 SELECT * FROM t1;
14 c1 c2 c3
15 10 100 100
16 10 11 10
17 100 100 100
18 100 100 11
19 11 10 10
20 11 10 11
21 11 11 10
22 DROP TABLE t1;
23 CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL, c3 SMALLINT NULL, UNIQUE(c1,c2,c3));
24 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
25 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
26 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
27 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
28 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
29 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
30 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
31 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
32 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
33 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
34 SELECT * FROM t1;
35 c1 c2 c3
36 10 100 100
37 10 11 10
38 100 100 100
39 100 100 11
40 11 10 10
41 11 10 11
42 11 11 10
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL, c3 MEDIUMINT NULL, UNIQUE(c1,c2,c3));
45 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
46 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
47 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
48 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
49 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
50 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
51 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
52 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
53 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
54 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
55 SELECT * FROM t1;
56 c1 c2 c3
57 10 100 100
58 10 11 10
59 100 100 100
60 100 100 11
61 11 10 10
62 11 10 11
63 11 11 10
64 DROP TABLE t1;
65 CREATE TABLE t1(c1 INT NULL, c2 INT NULL, c3 INT NULL, UNIQUE(c1,c2,c3));
66 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
67 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
68 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
69 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
70 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
71 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
72 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
73 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
74 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
75 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
76 SELECT * FROM t1;
77 c1 c2 c3
78 10 100 100
79 10 11 10
80 100 100 100
81 100 100 11
82 11 10 10
83 11 10 11
84 11 11 10
85 DROP TABLE t1;
86 CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL, c3 INTEGER NULL, UNIQUE(c1,c2,c3));
87 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
88 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
89 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
90 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
91 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
92 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
93 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
94 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
95 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
96 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
97 SELECT * FROM t1;
98 c1 c2 c3
99 10 100 100
100 10 11 10
101 100 100 100
102 100 100 11
103 11 10 10
104 11 10 11
105 11 11 10
106 DROP TABLE t1;
107 CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL, c3 BIGINT NULL, UNIQUE(c1,c2,c3));
108 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
109 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
110 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
111 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
112 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
113 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
114 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
115 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
116 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
117 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
118 SELECT * FROM t1;
119 c1 c2 c3
120 10 100 100
121 10 11 10
122 100 100 100
123 100 100 11
124 11 10 10
125 11 10 11
126 11 11 10
127 DROP TABLE t1;
128 CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL, c3 DECIMAL NULL, UNIQUE(c1,c2,c3));
129 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
130 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
131 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
132 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
133 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
134 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
135 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
136 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
137 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
138 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
139 SELECT * FROM t1;
140 c1 c2 c3
141 10 100 100
142 10 11 10
143 100 100 100
144 100 100 11
145 11 10 10
146 11 10 11
147 11 11 10
148 DROP TABLE t1;
149 CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL, c3 DEC NULL, UNIQUE(c1,c2,c3));
150 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
151 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
152 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
153 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
154 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
155 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
156 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
157 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
158 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
159 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
160 SELECT * FROM t1;
161 c1 c2 c3
162 10 100 100
163 10 11 10
164 100 100 100
165 100 100 11
166 11 10 10
167 11 10 11
168 11 11 10
169 DROP TABLE t1;
170 CREATE TABLE t1(c1 FIXED NULL, c2 FIXED NULL, c3 FIXED NULL, UNIQUE(c1,c2,c3));
171 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
172 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
173 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
174 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
175 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
176 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
177 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
178 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
179 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
180 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
181 SELECT * FROM t1;
182 c1 c2 c3
183 10 100 100
184 10 11 10
185 100 100 100
186 100 100 11
187 11 10 10
188 11 10 11
189 11 11 10
190 DROP TABLE t1;
191 CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL, c3 NUMERIC NULL, UNIQUE(c1,c2,c3));
192 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
193 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
194 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
195 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
196 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
197 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
198 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
199 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
200 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
201 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
202 SELECT * FROM t1;
203 c1 c2 c3
204 10 100 100
205 10 11 10
206 100 100 100
207 100 100 11
208 11 10 10
209 11 10 11
210 11 11 10
211 DROP TABLE t1;
212 CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL, c3 DOUBLE NULL, UNIQUE(c1,c2,c3));
213 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
214 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
215 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
216 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
217 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
218 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
219 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
220 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
221 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
222 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
223 SELECT * FROM t1;
224 c1 c2 c3
225 10 100 100
226 10 11 10
227 100 100 100
228 100 100 11
229 11 10 10
230 11 10 11
231 11 11 10
232 DROP TABLE t1;
233 CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL, c3 REAL NULL, UNIQUE(c1,c2,c3));
234 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
235 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
236 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
237 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
238 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
239 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
240 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
241 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
242 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
243 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
244 SELECT * FROM t1;
245 c1 c2 c3
246 10 100 100
247 10 11 10
248 100 100 100
249 100 100 11
250 11 10 10
251 11 10 11
252 11 11 10
253 DROP TABLE t1;
254 CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL, c3 DOUBLE PRECISION NULL, UNIQUE(c1,c2,c3));
255 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
256 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
257 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
258 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
259 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
260 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
261 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
262 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
263 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
264 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
265 SELECT * FROM t1;
266 c1 c2 c3
267 10 100 100
268 10 11 10
269 100 100 100
270 100 100 11
271 11 10 10
272 11 10 11
273 11 11 10
274 DROP TABLE t1;
275 CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL, c3 FLOAT NULL, UNIQUE(c1,c2,c3));
276 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
277 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
278 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
279 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
280 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
281 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
282 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
283 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
284 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
285 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
286 SELECT * FROM t1;
287 c1 c2 c3
288 10 100 100
289 10 11 10
290 100 100 100
291 100 100 11
292 11 10 10
293 11 10 11
294 11 11 10
295 DROP TABLE t1;