Debian Codegraph @

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

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