Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1,t2,t3;
2 CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT);
3 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
4 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 TINYINT, new1 TINYINT, old2 TINYINT, new2 TINYINT);
5 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT);
6 INSERT INTO t3 VALUES(1,0);
7 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
8 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
9 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
10 SET NEW.c2=100;
11 END//
12 ERROR HY000: Updating of NEW row is not allowed in after trigger
13 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
14 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
15 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
16 SET NEW.c2=100;
17 END//
18 INSERT INTO t1(c1,c2) VALUES(11,11);
19 REPLACE INTO t1(c1,c2) VALUES(12,12);
20 REPLACE INTO t1(c1,c2) VALUES(1,11);
21 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
22 SELECT * FROM t1 ORDER BY c1;
23 c1 c2
24 1 100
25 2 2
26 3 100
27 4 100
28 6 6
29 7 7
30 8 8
31 9 9
32 10 10
33 11 100
34 12 100
35 SELECT * FROM t2 ORDER BY c1;
36 c1 old1 new1 old2 new2
37 1 0 11 0 11
38 2 0 12 0 12
39 3 0 1 0 11
40 4 0 3 0 11
41 5 0 4 0 11
42 SELECT * FROM t3 ORDER BY c1;
43 c1 c2
44 1 56
45 DROP TABLE t1,t2,t3;
46 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
47 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
48 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 SMALLINT, new1 SMALLINT, old2 SMALLINT, new2 SMALLINT);
49 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
50 INSERT INTO t3 VALUES(1,0);
51 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
52 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
53 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
54 SET NEW.c2=100;
55 END//
56 ERROR HY000: Updating of NEW row is not allowed in after trigger
57 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
58 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
59 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
60 SET NEW.c2=100;
61 END//
62 INSERT INTO t1(c1,c2) VALUES(11,11);
63 REPLACE INTO t1(c1,c2) VALUES(12,12);
64 REPLACE INTO t1(c1,c2) VALUES(1,11);
65 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
66 SELECT * FROM t1 ORDER BY c1;
67 c1 c2
68 1 100
69 2 2
70 3 100
71 4 100
72 6 6
73 7 7
74 8 8
75 9 9
76 10 10
77 11 100
78 12 100
79 SELECT * FROM t2 ORDER BY c1;
80 c1 old1 new1 old2 new2
81 1 0 11 0 11
82 2 0 12 0 12
83 3 0 1 0 11
84 4 0 3 0 11
85 5 0 4 0 11
86 SELECT * FROM t3 ORDER BY c1;
87 c1 c2
88 1 56
89 DROP TABLE t1,t2,t3;
90 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
91 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
92 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 MEDIUMINT, new1 MEDIUMINT, old2 MEDIUMINT, new2 MEDIUMINT);
93 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
94 INSERT INTO t3 VALUES(1,0);
95 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
96 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
97 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
98 SET NEW.c2=100;
99 END//
100 ERROR HY000: Updating of NEW row is not allowed in after trigger
101 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
102 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
103 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
104 SET NEW.c2=100;
105 END//
106 INSERT INTO t1(c1,c2) VALUES(11,11);
107 REPLACE INTO t1(c1,c2) VALUES(12,12);
108 REPLACE INTO t1(c1,c2) VALUES(1,11);
109 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
110 SELECT * FROM t1 ORDER BY c1;
111 c1 c2
112 1 100
113 2 2
114 3 100
115 4 100
116 6 6
117 7 7
118 8 8
119 9 9
120 10 10
121 11 100
122 12 100
123 SELECT * FROM t2 ORDER BY c1;
124 c1 old1 new1 old2 new2
125 1 0 11 0 11
126 2 0 12 0 12
127 3 0 1 0 11
128 4 0 3 0 11
129 5 0 4 0 11
130 SELECT * FROM t3 ORDER BY c1;
131 c1 c2
132 1 56
133 DROP TABLE t1,t2,t3;
134 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT);
135 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
136 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INT, new1 INT, old2 INT, new2 INT);
137 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY, c2 INT);
138 INSERT INTO t3 VALUES(1,0);
139 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
140 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
141 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
142 SET NEW.c2=100;
143 END//
144 ERROR HY000: Updating of NEW row is not allowed in after trigger
145 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
146 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
147 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
148 SET NEW.c2=100;
149 END//
150 INSERT INTO t1(c1,c2) VALUES(11,11);
151 REPLACE INTO t1(c1,c2) VALUES(12,12);
152 REPLACE INTO t1(c1,c2) VALUES(1,11);
153 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
154 SELECT * FROM t1 ORDER BY c1;
155 c1 c2
156 1 100
157 2 2
158 3 100
159 4 100
160 6 6
161 7 7
162 8 8
163 9 9
164 10 10
165 11 100
166 12 100
167 SELECT * FROM t2 ORDER BY c1;
168 c1 old1 new1 old2 new2
169 1 0 11 0 11
170 2 0 12 0 12
171 3 0 1 0 11
172 4 0 3 0 11
173 5 0 4 0 11
174 SELECT * FROM t3 ORDER BY c1;
175 c1 c2
176 1 56
177 DROP TABLE t1,t2,t3;
178 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
179 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
180 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INTEGER, new1 INTEGER, old2 INTEGER, new2 INTEGER);
181 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
182 INSERT INTO t3 VALUES(1,0);
183 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
184 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
185 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
186 SET NEW.c2=100;
187 END//
188 ERROR HY000: Updating of NEW row is not allowed in after trigger
189 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
190 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
191 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
192 SET NEW.c2=100;
193 END//
194 INSERT INTO t1(c1,c2) VALUES(11,11);
195 REPLACE INTO t1(c1,c2) VALUES(12,12);
196 REPLACE INTO t1(c1,c2) VALUES(1,11);
197 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
198 SELECT * FROM t1 ORDER BY c1;
199 c1 c2
200 1 100
201 2 2
202 3 100
203 4 100
204 6 6
205 7 7
206 8 8
207 9 9
208 10 10
209 11 100
210 12 100
211 SELECT * FROM t2 ORDER BY c1;
212 c1 old1 new1 old2 new2
213 1 0 11 0 11
214 2 0 12 0 12
215 3 0 1 0 11
216 4 0 3 0 11
217 5 0 4 0 11
218 SELECT * FROM t3 ORDER BY c1;
219 c1 c2
220 1 56
221 DROP TABLE t1,t2,t3;
222 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
223 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
224 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 BIGINT, new1 BIGINT, old2 BIGINT, new2 BIGINT);
225 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
226 INSERT INTO t3 VALUES(1,0);
227 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
228 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
229 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
230 SET NEW.c2=100;
231 END//
232 ERROR HY000: Updating of NEW row is not allowed in after trigger
233 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
234 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
235 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
236 SET NEW.c2=100;
237 END//
238 INSERT INTO t1(c1,c2) VALUES(11,11);
239 REPLACE INTO t1(c1,c2) VALUES(12,12);
240 REPLACE INTO t1(c1,c2) VALUES(1,11);
241 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
242 SELECT * FROM t1 ORDER BY c1;
243 c1 c2
244 1 100
245 2 2
246 3 100
247 4 100
248 6 6
249 7 7
250 8 8
251 9 9
252 10 10
253 11 100
254 12 100
255 SELECT * FROM t2 ORDER BY c1;
256 c1 old1 new1 old2 new2
257 1 0 11 0 11
258 2 0 12 0 12
259 3 0 1 0 11
260 4 0 3 0 11
261 5 0 4 0 11
262 SELECT * FROM t3 ORDER BY c1;
263 c1 c2
264 1 56
265 DROP TABLE t1,t2,t3;
266 CREATE TABLE t1 (c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
267 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
268 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 REAL, new1 REAL, old2 REAL, new2 REAL);
269 CREATE TABLE t3(c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
270 INSERT INTO t3 VALUES(1,0);
271 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
272 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
273 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
274 SET NEW.c2=100;
275 END//
276 ERROR HY000: Updating of NEW row is not allowed in after trigger
277 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
278 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
279 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
280 SET NEW.c2=100;
281 END//
282 INSERT INTO t1(c1,c2) VALUES(11,11);
283 REPLACE INTO t1(c1,c2) VALUES(12,12);
284 REPLACE INTO t1(c1,c2) VALUES(1,11);
285 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
286 SELECT * FROM t1 ORDER BY c1;
287 c1 c2
288 1 100
289 2 2
290 3 100
291 4 100
292 6 6
293 7 7
294 8 8
295 9 9
296 10 10
297 11 100
298 12 100
299 SELECT * FROM t2 ORDER BY c1;
300 c1 old1 new1 old2 new2
301 1 0 11 0 11
302 2 0 12 0 12
303 3 0 1 0 11
304 4 0 3 0 11
305 5 0 4 0 11
306 SELECT * FROM t3 ORDER BY c1;
307 c1 c2
308 1 56
309 DROP TABLE t1,t2,t3;
310 CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
311 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
312 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DOUBLE, new1 DOUBLE, old2 DOUBLE, new2 DOUBLE);
313 CREATE TABLE t3(c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
314 INSERT INTO t3 VALUES(1,0);
315 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
316 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
317 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
318 SET NEW.c2=100;
319 END//
320 ERROR HY000: Updating of NEW row is not allowed in after trigger
321 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
322 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
323 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
324 SET NEW.c2=100;
325 END//
326 INSERT INTO t1(c1,c2) VALUES(11,11);
327 REPLACE INTO t1(c1,c2) VALUES(12,12);
328 REPLACE INTO t1(c1,c2) VALUES(1,11);
329 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
330 SELECT * FROM t1 ORDER BY c1;
331 c1 c2
332 1 100
333 2 2
334 3 100
335 4 100
336 6 6
337 7 7
338 8 8
339 9 9
340 10 10
341 11 100
342 12 100
343 SELECT * FROM t2 ORDER BY c1;
344 c1 old1 new1 old2 new2
345 1 0 11 0 11
346 2 0 12 0 12
347 3 0 1 0 11
348 4 0 3 0 11
349 5 0 4 0 11
350 SELECT * FROM t3 ORDER BY c1;
351 c1 c2
352 1 56
353 DROP TABLE t1,t2,t3;
354 CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
355 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
356 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 FLOAT, new1 FLOAT, old2 FLOAT, new2 FLOAT);
357 CREATE TABLE t3(c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
358 INSERT INTO t3 VALUES(1,0);
359 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
360 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
361 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
362 SET NEW.c2=100;
363 END//
364 ERROR HY000: Updating of NEW row is not allowed in after trigger
365 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
366 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
367 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
368 SET NEW.c2=100;
369 END//
370 INSERT INTO t1(c1,c2) VALUES(11,11);
371 REPLACE INTO t1(c1,c2) VALUES(12,12);
372 REPLACE INTO t1(c1,c2) VALUES(1,11);
373 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
374 SELECT * FROM t1 ORDER BY c1;
375 c1 c2
376 1 100
377 2 2
378 3 100
379 4 100
380 6 6
381 7 7
382 8 8
383 9 9
384 10 10
385 11 100
386 12 100
387 SELECT * FROM t2 ORDER BY c1;
388 c1 old1 new1 old2 new2
389 1 0 11 0 11
390 2 0 12 0 12
391 3 0 1 0 11
392 4 0 3 0 11
393 5 0 4 0 11
394 SELECT * FROM t3 ORDER BY c1;
395 c1 c2
396 1 56
397 DROP TABLE t1,t2,t3;
398 CREATE TABLE t1 (c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
399 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
400 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DECIMAL, new1 DECIMAL, old2 DECIMAL, new2 DECIMAL);
401 CREATE TABLE t3(c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
402 INSERT INTO t3 VALUES(1,0);
403 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
404 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
405 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
406 SET NEW.c2=100;
407 END//
408 ERROR HY000: Updating of NEW row is not allowed in after trigger
409 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
410 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
411 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
412 SET NEW.c2=100;
413 END//
414 INSERT INTO t1(c1,c2) VALUES(11,11);
415 REPLACE INTO t1(c1,c2) VALUES(12,12);
416 REPLACE INTO t1(c1,c2) VALUES(1,11);
417 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
418 SELECT * FROM t1 ORDER BY c1;
419 c1 c2
420 1 100
421 2 2
422 3 100
423 4 100
424 6 6
425 7 7
426 8 8
427 9 9
428 10 10
429 11 100
430 12 100
431 SELECT * FROM t2 ORDER BY c1;
432 c1 old1 new1 old2 new2
433 1 0 11 0 11
434 2 0 12 0 12
435 3 0 1 0 11
436 4 0 3 0 11
437 5 0 4 0 11
438 SELECT * FROM t3 ORDER BY c1;
439 c1 c2
440 1 56
441 DROP TABLE t1,t2,t3;
442 CREATE TABLE t1 (c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
443 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
444 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 NUMERIC, new1 NUMERIC, old2 NUMERIC, new2 NUMERIC);
445 CREATE TABLE t3(c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
446 INSERT INTO t3 VALUES(1,0);
447 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
448 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
449 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
450 SET NEW.c2=100;
451 END//
452 ERROR HY000: Updating of NEW row is not allowed in after trigger
453 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
454 INSERT INTO t2 (old1,new1,old2,new2) VALUES(0,NEW.c1,0,NEW.c2);
455 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
456 SET NEW.c2=100;
457 END//
458 INSERT INTO t1(c1,c2) VALUES(11,11);
459 REPLACE INTO t1(c1,c2) VALUES(12,12);
460 REPLACE INTO t1(c1,c2) VALUES(1,11);
461 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
462 SELECT * FROM t1 ORDER BY c1;
463 c1 c2
464 1 100
465 2 2
466 3 100
467 4 100
468 6 6
469 7 7
470 8 8
471 9 9
472 10 10
473 11 100
474 12 100
475 SELECT * FROM t2 ORDER BY c1;
476 c1 old1 new1 old2 new2
477 1 0 11 0 11
478 2 0 12 0 12
479 3 0 1 0 11
480 4 0 3 0 11
481 5 0 4 0 11
482 SELECT * FROM t3 ORDER BY c1;
483 c1 c2
484 1 56
485 DROP TABLE t1,t2,t3;