Debian Codegraph @

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

raw
1 DROP DATABASE IF EXISTS d1;
2 DROP DATABASE IF EXISTS d2;
3 DROP DATABASE IF EXISTS d3;
4 CREATE DATABASE d1;
5 CREATE DATABASE d2;
6 CREATE DATABASE d3;
7 CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
8 CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
9 CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
10 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
11 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
12 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
13 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
14 SELECT * FROM d1.t1 ORDER BY c1;
15 c1 c2
16 1 30
17 2 30
18 3 3
19 4 4
20 5 5
21 SELECT * FROM d2.t2 ORDER BY c1;
22 c1 c2
23 11 40
24 12 1
25 13 40
26 14 40
27 15 6
28 SELECT * FROM d3.t3 ORDER BY c1;
29 c1 c2
30 21 50
31 22 50
32 23 50
33 24 50
34 25 15
35 DROP DATABASE d1;
36 DROP DATABASE d2;
37 DROP DATABASE d3;
38 CREATE DATABASE d1;
39 CREATE DATABASE d2;
40 CREATE DATABASE d3;
41 CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
42 CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
43 CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
44 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
45 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
46 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
47 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
48 SELECT * FROM d1.t1 ORDER BY c1;
49 c1 c2
50 1 30
51 2 30
52 3 3
53 4 4
54 5 5
55 SELECT * FROM d2.t2 ORDER BY c1;
56 c1 c2
57 11 40
58 12 1
59 13 40
60 14 40
61 15 6
62 SELECT * FROM d3.t3 ORDER BY c1;
63 c1 c2
64 21 50
65 22 50
66 23 50
67 24 50
68 25 15
69 DROP DATABASE d1;
70 DROP DATABASE d2;
71 DROP DATABASE d3;
72 CREATE DATABASE d1;
73 CREATE DATABASE d2;
74 CREATE DATABASE d3;
75 CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
76 CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
77 CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
78 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
79 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
80 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
81 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
82 SELECT * FROM d1.t1 ORDER BY c1;
83 c1 c2
84 1 30
85 2 30
86 3 3
87 4 4
88 5 5
89 SELECT * FROM d2.t2 ORDER BY c1;
90 c1 c2
91 11 40
92 12 1
93 13 40
94 14 40
95 15 6
96 SELECT * FROM d3.t3 ORDER BY c1;
97 c1 c2
98 21 50
99 22 50
100 23 50
101 24 50
102 25 15
103 DROP DATABASE d1;
104 DROP DATABASE d2;
105 DROP DATABASE d3;
106 CREATE DATABASE d1;
107 CREATE DATABASE d2;
108 CREATE DATABASE d3;
109 CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
110 CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
111 CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
112 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
113 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
114 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
115 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
116 SELECT * FROM d1.t1 ORDER BY c1;
117 c1 c2
118 1 30
119 2 30
120 3 3
121 4 4
122 5 5
123 SELECT * FROM d2.t2 ORDER BY c1;
124 c1 c2
125 11 40
126 12 1
127 13 40
128 14 40
129 15 6
130 SELECT * FROM d3.t3 ORDER BY c1;
131 c1 c2
132 21 50
133 22 50
134 23 50
135 24 50
136 25 15
137 DROP DATABASE d1;
138 DROP DATABASE d2;
139 DROP DATABASE d3;
140 CREATE DATABASE d1;
141 CREATE DATABASE d2;
142 CREATE DATABASE d3;
143 CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
144 CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
145 CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
146 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
147 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
148 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
149 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
150 SELECT * FROM d1.t1 ORDER BY c1;
151 c1 c2
152 1 30
153 2 30
154 3 3
155 4 4
156 5 5
157 SELECT * FROM d2.t2 ORDER BY c1;
158 c1 c2
159 11 40
160 12 1
161 13 40
162 14 40
163 15 6
164 SELECT * FROM d3.t3 ORDER BY c1;
165 c1 c2
166 21 50
167 22 50
168 23 50
169 24 50
170 25 15
171 DROP DATABASE d1;
172 DROP DATABASE d2;
173 DROP DATABASE d3;
174 CREATE DATABASE d1;
175 CREATE DATABASE d2;
176 CREATE DATABASE d3;
177 CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
178 CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
179 CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
180 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
181 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
182 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
183 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
184 SELECT * FROM d1.t1 ORDER BY c1;
185 c1 c2
186 1 30
187 2 30
188 3 3
189 4 4
190 5 5
191 SELECT * FROM d2.t2 ORDER BY c1;
192 c1 c2
193 11 40
194 12 1
195 13 40
196 14 40
197 15 6
198 SELECT * FROM d3.t3 ORDER BY c1;
199 c1 c2
200 21 50
201 22 50
202 23 50
203 24 50
204 25 15
205 DROP DATABASE d1;
206 DROP DATABASE d2;
207 DROP DATABASE d3;
208 CREATE DATABASE d1;
209 CREATE DATABASE d2;
210 CREATE DATABASE d3;
211 CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
212 CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
213 CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
214 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
215 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
216 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
217 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
218 SELECT * FROM d1.t1 ORDER BY c1;
219 c1 c2
220 1 30
221 2 30
222 3 3
223 4 4
224 5 5
225 SELECT * FROM d2.t2 ORDER BY c1;
226 c1 c2
227 11 40
228 12 1
229 13 40
230 14 40
231 15 6
232 SELECT * FROM d3.t3 ORDER BY c1;
233 c1 c2
234 21 50
235 22 50
236 23 50
237 24 50
238 25 15
239 DROP DATABASE d1;
240 DROP DATABASE d2;
241 DROP DATABASE d3;
242 CREATE DATABASE d1;
243 CREATE DATABASE d2;
244 CREATE DATABASE d3;
245 CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
246 CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
247 CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
248 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
249 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
250 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
251 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
252 SELECT * FROM d1.t1 ORDER BY c1;
253 c1 c2
254 1 30
255 2 30
256 3 3
257 4 4
258 5 5
259 SELECT * FROM d2.t2 ORDER BY c1;
260 c1 c2
261 11 40
262 12 1
263 13 40
264 14 40
265 15 6
266 SELECT * FROM d3.t3 ORDER BY c1;
267 c1 c2
268 21 50
269 22 50
270 23 50
271 24 50
272 25 15
273 DROP DATABASE d1;
274 DROP DATABASE d2;
275 DROP DATABASE d3;
276 CREATE DATABASE d1;
277 CREATE DATABASE d2;
278 CREATE DATABASE d3;
279 CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
280 CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
281 CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
282 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
283 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
284 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
285 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
286 SELECT * FROM d1.t1 ORDER BY c1;
287 c1 c2
288 1 30
289 2 30
290 3 3
291 4 4
292 5 5
293 SELECT * FROM d2.t2 ORDER BY c1;
294 c1 c2
295 11 40
296 12 1
297 13 40
298 14 40
299 15 6
300 SELECT * FROM d3.t3 ORDER BY c1;
301 c1 c2
302 21 50
303 22 50
304 23 50
305 24 50
306 25 15
307 DROP DATABASE d1;
308 DROP DATABASE d2;
309 DROP DATABASE d3;
310 CREATE DATABASE d1;
311 CREATE DATABASE d2;
312 CREATE DATABASE d3;
313 CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
314 CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
315 CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
316 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
317 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
318 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
319 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
320 SELECT * FROM d1.t1 ORDER BY c1;
321 c1 c2
322 1 30
323 2 30
324 3 3
325 4 4
326 5 5
327 SELECT * FROM d2.t2 ORDER BY c1;
328 c1 c2
329 11 40
330 12 1
331 13 40
332 14 40
333 15 6
334 SELECT * FROM d3.t3 ORDER BY c1;
335 c1 c2
336 21 50
337 22 50
338 23 50
339 24 50
340 25 15
341 DROP DATABASE d1;
342 DROP DATABASE d2;
343 DROP DATABASE d3;
344 CREATE DATABASE d1;
345 CREATE DATABASE d2;
346 CREATE DATABASE d3;
347 CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
348 CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
349 CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
350 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
351 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
352 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
353 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
354 SELECT * FROM d1.t1 ORDER BY c1;
355 c1 c2
356 1 30
357 2 30
358 3 3
359 4 4
360 5 5
361 SELECT * FROM d2.t2 ORDER BY c1;
362 c1 c2
363 11 40
364 12 1
365 13 40
366 14 40
367 15 6
368 SELECT * FROM d3.t3 ORDER BY c1;
369 c1 c2
370 21 50
371 22 50
372 23 50
373 24 50
374 25 15
375 DROP DATABASE d1;
376 DROP DATABASE d2;
377 DROP DATABASE d3;
378 CREATE DATABASE d1;
379 CREATE DATABASE d2;
380 CREATE DATABASE d3;
381 CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
382 CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
383 CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
384 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
385 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
386 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
387 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
388 SELECT * FROM d1.t1 ORDER BY c1;
389 c1 c2
390 1 30
391 2 30
392 3 3
393 4 4
394 5 5
395 SELECT * FROM d2.t2 ORDER BY c1;
396 c1 c2
397 11 40
398 12 1
399 13 40
400 14 40
401 15 6
402 SELECT * FROM d3.t3 ORDER BY c1;
403 c1 c2
404 21 50
405 22 50
406 23 50
407 24 50
408 25 15
409 DROP DATABASE d1;
410 DROP DATABASE d2;
411 DROP DATABASE d3;