2 DROP TABLE IF EXISTS t1,t2,t3;
4 CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT);
5 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
6 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 TINYINT, new1 TINYINT, old2 TINYINT, new2 TINYINT);
7 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT);
8 INSERT INTO t3 VALUES(1,0);
11 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
12 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
13 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
16 REPLACE INTO t1(c1,c2) VALUES(12,12);
17 REPLACE INTO t1(c1,c2) VALUES(1,11);
18 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
19 SELECT * FROM t1 ORDER BY c1;
20 SELECT * FROM t2 ORDER BY c1;
21 SELECT * FROM t3 ORDER BY c1;
22 DELETE FROM t1 WHERE c1=1;
23 DELETE FROM t1 WHERE c1=0;
24 DELETE FROM t1 WHERE c1=NULL;
25 DELETE FROM t1 WHERE c1=6 OR c1=7;
26 DELETE FROM t1 WHERE c2=3;
27 SELECT * FROM t1 ORDER BY c1;
28 SELECT * FROM t2 ORDER BY c1;
29 SELECT * FROM t3 ORDER BY c1;
31 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
32 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
33 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 SMALLINT, new1 SMALLINT, old2 SMALLINT, new2 SMALLINT);
34 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
35 INSERT INTO t3 VALUES(1,0);
38 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
39 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
40 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
43 REPLACE INTO t1(c1,c2) VALUES(12,12);
44 REPLACE INTO t1(c1,c2) VALUES(1,11);
45 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
46 SELECT * FROM t1 ORDER BY c1;
47 SELECT * FROM t2 ORDER BY c1;
48 SELECT * FROM t3 ORDER BY c1;
49 DELETE FROM t1 WHERE c1=1;
50 DELETE FROM t1 WHERE c1=0;
51 DELETE FROM t1 WHERE c1=NULL;
52 DELETE FROM t1 WHERE c1=6 OR c1=7;
53 DELETE FROM t1 WHERE c2=3;
54 SELECT * FROM t1 ORDER BY c1;
55 SELECT * FROM t2 ORDER BY c1;
56 SELECT * FROM t3 ORDER BY c1;
58 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
59 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
60 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 MEDIUMINT, new1 MEDIUMINT, old2 MEDIUMINT, new2 MEDIUMINT);
61 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
62 INSERT INTO t3 VALUES(1,0);
65 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
66 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
67 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
70 REPLACE INTO t1(c1,c2) VALUES(12,12);
71 REPLACE INTO t1(c1,c2) VALUES(1,11);
72 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
73 SELECT * FROM t1 ORDER BY c1;
74 SELECT * FROM t2 ORDER BY c1;
75 SELECT * FROM t3 ORDER BY c1;
76 DELETE FROM t1 WHERE c1=1;
77 DELETE FROM t1 WHERE c1=0;
78 DELETE FROM t1 WHERE c1=NULL;
79 DELETE FROM t1 WHERE c1=6 OR c1=7;
80 DELETE FROM t1 WHERE c2=3;
81 SELECT * FROM t1 ORDER BY c1;
82 SELECT * FROM t2 ORDER BY c1;
83 SELECT * FROM t3 ORDER BY c1;
85 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT);
86 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
87 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INT, new1 INT, old2 INT, new2 INT);
88 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY, c2 INT);
89 INSERT INTO t3 VALUES(1,0);
92 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
93 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
94 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
97 REPLACE INTO t1(c1,c2) VALUES(12,12);
98 REPLACE INTO t1(c1,c2) VALUES(1,11);
99 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
100 SELECT * FROM t1 ORDER BY c1;
101 SELECT * FROM t2 ORDER BY c1;
102 SELECT * FROM t3 ORDER BY c1;
103 DELETE FROM t1 WHERE c1=1;
104 DELETE FROM t1 WHERE c1=0;
105 DELETE FROM t1 WHERE c1=NULL;
106 DELETE FROM t1 WHERE c1=6 OR c1=7;
107 DELETE FROM t1 WHERE c2=3;
108 SELECT * FROM t1 ORDER BY c1;
109 SELECT * FROM t2 ORDER BY c1;
110 SELECT * FROM t3 ORDER BY c1;
112 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
113 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
114 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INTEGER, new1 INTEGER, old2 INTEGER, new2 INTEGER);
115 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
116 INSERT INTO t3 VALUES(1,0);
119 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
120 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
121 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
124 REPLACE INTO t1(c1,c2) VALUES(12,12);
125 REPLACE INTO t1(c1,c2) VALUES(1,11);
126 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
127 SELECT * FROM t1 ORDER BY c1;
128 SELECT * FROM t2 ORDER BY c1;
129 SELECT * FROM t3 ORDER BY c1;
130 DELETE FROM t1 WHERE c1=1;
131 DELETE FROM t1 WHERE c1=0;
132 DELETE FROM t1 WHERE c1=NULL;
133 DELETE FROM t1 WHERE c1=6 OR c1=7;
134 DELETE FROM t1 WHERE c2=3;
135 SELECT * FROM t1 ORDER BY c1;
136 SELECT * FROM t2 ORDER BY c1;
137 SELECT * FROM t3 ORDER BY c1;
139 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
140 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
141 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 BIGINT, new1 BIGINT, old2 BIGINT, new2 BIGINT);
142 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
143 INSERT INTO t3 VALUES(1,0);
146 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
147 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
148 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
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 SELECT * FROM t2 ORDER BY c1;
156 SELECT * FROM t3 ORDER BY c1;
157 DELETE FROM t1 WHERE c1=1;
158 DELETE FROM t1 WHERE c1=0;
159 DELETE FROM t1 WHERE c1=NULL;
160 DELETE FROM t1 WHERE c1=6 OR c1=7;
161 DELETE FROM t1 WHERE c2=3;
162 SELECT * FROM t1 ORDER BY c1;
163 SELECT * FROM t2 ORDER BY c1;
164 SELECT * FROM t3 ORDER BY c1;
166 CREATE TABLE t1 (c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
167 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
168 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 REAL, new1 REAL, old2 REAL, new2 REAL);
169 CREATE TABLE t3(c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
170 INSERT INTO t3 VALUES(1,0);
173 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
174 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
175 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
178 REPLACE INTO t1(c1,c2) VALUES(12,12);
179 REPLACE INTO t1(c1,c2) VALUES(1,11);
180 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
181 SELECT * FROM t1 ORDER BY c1;
182 SELECT * FROM t2 ORDER BY c1;
183 SELECT * FROM t3 ORDER BY c1;
184 DELETE FROM t1 WHERE c1=1;
185 DELETE FROM t1 WHERE c1=0;
186 DELETE FROM t1 WHERE c1=NULL;
187 DELETE FROM t1 WHERE c1=6 OR c1=7;
188 DELETE FROM t1 WHERE c2=3;
189 SELECT * FROM t1 ORDER BY c1;
190 SELECT * FROM t2 ORDER BY c1;
191 SELECT * FROM t3 ORDER BY c1;
193 CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
194 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
195 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DOUBLE, new1 DOUBLE, old2 DOUBLE, new2 DOUBLE);
196 CREATE TABLE t3(c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
197 INSERT INTO t3 VALUES(1,0);
200 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
201 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
202 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
205 REPLACE INTO t1(c1,c2) VALUES(12,12);
206 REPLACE INTO t1(c1,c2) VALUES(1,11);
207 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
208 SELECT * FROM t1 ORDER BY c1;
209 SELECT * FROM t2 ORDER BY c1;
210 SELECT * FROM t3 ORDER BY c1;
211 DELETE FROM t1 WHERE c1=1;
212 DELETE FROM t1 WHERE c1=0;
213 DELETE FROM t1 WHERE c1=NULL;
214 DELETE FROM t1 WHERE c1=6 OR c1=7;
215 DELETE FROM t1 WHERE c2=3;
216 SELECT * FROM t1 ORDER BY c1;
217 SELECT * FROM t2 ORDER BY c1;
218 SELECT * FROM t3 ORDER BY c1;
220 CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
221 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
222 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 FLOAT, new1 FLOAT, old2 FLOAT, new2 FLOAT);
223 CREATE TABLE t3(c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
224 INSERT INTO t3 VALUES(1,0);
227 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
228 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
229 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
232 REPLACE INTO t1(c1,c2) VALUES(12,12);
233 REPLACE INTO t1(c1,c2) VALUES(1,11);
234 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
235 SELECT * FROM t1 ORDER BY c1;
236 SELECT * FROM t2 ORDER BY c1;
237 SELECT * FROM t3 ORDER BY c1;
238 DELETE FROM t1 WHERE c1=1;
239 DELETE FROM t1 WHERE c1=0;
240 DELETE FROM t1 WHERE c1=NULL;
241 DELETE FROM t1 WHERE c1=6 OR c1=7;
242 DELETE FROM t1 WHERE c2=3;
243 SELECT * FROM t1 ORDER BY c1;
244 SELECT * FROM t2 ORDER BY c1;
245 SELECT * FROM t3 ORDER BY c1;
247 CREATE TABLE t1 (c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
248 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
249 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DECIMAL, new1 DECIMAL, old2 DECIMAL, new2 DECIMAL);
250 CREATE TABLE t3(c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
251 INSERT INTO t3 VALUES(1,0);
254 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
255 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
256 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
259 REPLACE INTO t1(c1,c2) VALUES(12,12);
260 REPLACE INTO t1(c1,c2) VALUES(1,11);
261 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
262 SELECT * FROM t1 ORDER BY c1;
263 SELECT * FROM t2 ORDER BY c1;
264 SELECT * FROM t3 ORDER BY c1;
265 DELETE FROM t1 WHERE c1=1;
266 DELETE FROM t1 WHERE c1=0;
267 DELETE FROM t1 WHERE c1=NULL;
268 DELETE FROM t1 WHERE c1=6 OR c1=7;
269 DELETE FROM t1 WHERE c2=3;
270 SELECT * FROM t1 ORDER BY c1;
271 SELECT * FROM t2 ORDER BY c1;
272 SELECT * FROM t3 ORDER BY c1;
274 CREATE TABLE t1 (c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
275 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
276 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 NUMERIC, new1 NUMERIC, old2 NUMERIC, new2 NUMERIC);
277 CREATE TABLE t3(c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
278 INSERT INTO t3 VALUES(1,0);
281 CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW BEGIN
282 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
283 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
286 REPLACE INTO t1(c1,c2) VALUES(12,12);
287 REPLACE INTO t1(c1,c2) VALUES(1,11);
288 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
289 SELECT * FROM t1 ORDER BY c1;
290 SELECT * FROM t2 ORDER BY c1;
291 SELECT * FROM t3 ORDER BY c1;
292 DELETE FROM t1 WHERE c1=1;
293 DELETE FROM t1 WHERE c1=0;
294 DELETE FROM t1 WHERE c1=NULL;
295 DELETE FROM t1 WHERE c1=6 OR c1=7;
296 DELETE FROM t1 WHERE c2=3;
297 SELECT * FROM t1 ORDER BY c1;
298 SELECT * FROM t2 ORDER BY c1;
299 SELECT * FROM t3 ORDER BY c1;
301 CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT);
302 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
303 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 TINYINT, new1 TINYINT, old2 TINYINT, new2 TINYINT);
304 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT);
305 INSERT INTO t3 VALUES(1,0);
308 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
309 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
310 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
313 REPLACE INTO t1(c1,c2) VALUES(12,12);
314 REPLACE INTO t1(c1,c2) VALUES(1,11);
315 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
316 SELECT * FROM t1 ORDER BY c1;
317 SELECT * FROM t2 ORDER BY c1;
318 SELECT * FROM t3 ORDER BY c1;
319 DELETE FROM t1 WHERE c1=1;
320 DELETE FROM t1 WHERE c1=0;
321 DELETE FROM t1 WHERE c1=NULL;
322 DELETE FROM t1 WHERE c1=6 OR c1=7;
323 DELETE FROM t1 WHERE c2=3;
324 SELECT * FROM t1 ORDER BY c1;
325 SELECT * FROM t2 ORDER BY c1;
326 SELECT * FROM t3 ORDER BY c1;
328 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
329 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
330 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 SMALLINT, new1 SMALLINT, old2 SMALLINT, new2 SMALLINT);
331 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
332 INSERT INTO t3 VALUES(1,0);
335 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
336 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
337 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
340 REPLACE INTO t1(c1,c2) VALUES(12,12);
341 REPLACE INTO t1(c1,c2) VALUES(1,11);
342 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
343 SELECT * FROM t1 ORDER BY c1;
344 SELECT * FROM t2 ORDER BY c1;
345 SELECT * FROM t3 ORDER BY c1;
346 DELETE FROM t1 WHERE c1=1;
347 DELETE FROM t1 WHERE c1=0;
348 DELETE FROM t1 WHERE c1=NULL;
349 DELETE FROM t1 WHERE c1=6 OR c1=7;
350 DELETE FROM t1 WHERE c2=3;
351 SELECT * FROM t1 ORDER BY c1;
352 SELECT * FROM t2 ORDER BY c1;
353 SELECT * FROM t3 ORDER BY c1;
355 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
356 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
357 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 MEDIUMINT, new1 MEDIUMINT, old2 MEDIUMINT, new2 MEDIUMINT);
358 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
359 INSERT INTO t3 VALUES(1,0);
362 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
363 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
364 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
367 REPLACE INTO t1(c1,c2) VALUES(12,12);
368 REPLACE INTO t1(c1,c2) VALUES(1,11);
369 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
370 SELECT * FROM t1 ORDER BY c1;
371 SELECT * FROM t2 ORDER BY c1;
372 SELECT * FROM t3 ORDER BY c1;
373 DELETE FROM t1 WHERE c1=1;
374 DELETE FROM t1 WHERE c1=0;
375 DELETE FROM t1 WHERE c1=NULL;
376 DELETE FROM t1 WHERE c1=6 OR c1=7;
377 DELETE FROM t1 WHERE c2=3;
378 SELECT * FROM t1 ORDER BY c1;
379 SELECT * FROM t2 ORDER BY c1;
380 SELECT * FROM t3 ORDER BY c1;
382 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT);
383 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
384 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INT, new1 INT, old2 INT, new2 INT);
385 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY, c2 INT);
386 INSERT INTO t3 VALUES(1,0);
389 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
390 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
391 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
394 REPLACE INTO t1(c1,c2) VALUES(12,12);
395 REPLACE INTO t1(c1,c2) VALUES(1,11);
396 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
397 SELECT * FROM t1 ORDER BY c1;
398 SELECT * FROM t2 ORDER BY c1;
399 SELECT * FROM t3 ORDER BY c1;
400 DELETE FROM t1 WHERE c1=1;
401 DELETE FROM t1 WHERE c1=0;
402 DELETE FROM t1 WHERE c1=NULL;
403 DELETE FROM t1 WHERE c1=6 OR c1=7;
404 DELETE FROM t1 WHERE c2=3;
405 SELECT * FROM t1 ORDER BY c1;
406 SELECT * FROM t2 ORDER BY c1;
407 SELECT * FROM t3 ORDER BY c1;
409 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
410 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
411 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INTEGER, new1 INTEGER, old2 INTEGER, new2 INTEGER);
412 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
413 INSERT INTO t3 VALUES(1,0);
416 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
417 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
418 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
421 REPLACE INTO t1(c1,c2) VALUES(12,12);
422 REPLACE INTO t1(c1,c2) VALUES(1,11);
423 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
424 SELECT * FROM t1 ORDER BY c1;
425 SELECT * FROM t2 ORDER BY c1;
426 SELECT * FROM t3 ORDER BY c1;
427 DELETE FROM t1 WHERE c1=1;
428 DELETE FROM t1 WHERE c1=0;
429 DELETE FROM t1 WHERE c1=NULL;
430 DELETE FROM t1 WHERE c1=6 OR c1=7;
431 DELETE FROM t1 WHERE c2=3;
432 SELECT * FROM t1 ORDER BY c1;
433 SELECT * FROM t2 ORDER BY c1;
434 SELECT * FROM t3 ORDER BY c1;
436 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
437 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
438 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 BIGINT, new1 BIGINT, old2 BIGINT, new2 BIGINT);
439 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
440 INSERT INTO t3 VALUES(1,0);
443 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
444 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
445 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
448 REPLACE INTO t1(c1,c2) VALUES(12,12);
449 REPLACE INTO t1(c1,c2) VALUES(1,11);
450 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
451 SELECT * FROM t1 ORDER BY c1;
452 SELECT * FROM t2 ORDER BY c1;
453 SELECT * FROM t3 ORDER BY c1;
454 DELETE FROM t1 WHERE c1=1;
455 DELETE FROM t1 WHERE c1=0;
456 DELETE FROM t1 WHERE c1=NULL;
457 DELETE FROM t1 WHERE c1=6 OR c1=7;
458 DELETE FROM t1 WHERE c2=3;
459 SELECT * FROM t1 ORDER BY c1;
460 SELECT * FROM t2 ORDER BY c1;
461 SELECT * FROM t3 ORDER BY c1;
463 CREATE TABLE t1 (c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
464 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
465 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 REAL, new1 REAL, old2 REAL, new2 REAL);
466 CREATE TABLE t3(c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
467 INSERT INTO t3 VALUES(1,0);
470 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
471 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
472 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
475 REPLACE INTO t1(c1,c2) VALUES(12,12);
476 REPLACE INTO t1(c1,c2) VALUES(1,11);
477 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
478 SELECT * FROM t1 ORDER BY c1;
479 SELECT * FROM t2 ORDER BY c1;
480 SELECT * FROM t3 ORDER BY c1;
481 DELETE FROM t1 WHERE c1=1;
482 DELETE FROM t1 WHERE c1=0;
483 DELETE FROM t1 WHERE c1=NULL;
484 DELETE FROM t1 WHERE c1=6 OR c1=7;
485 DELETE FROM t1 WHERE c2=3;
486 SELECT * FROM t1 ORDER BY c1;
487 SELECT * FROM t2 ORDER BY c1;
488 SELECT * FROM t3 ORDER BY c1;
490 CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
491 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
492 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DOUBLE, new1 DOUBLE, old2 DOUBLE, new2 DOUBLE);
493 CREATE TABLE t3(c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
494 INSERT INTO t3 VALUES(1,0);
497 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
498 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
499 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
502 REPLACE INTO t1(c1,c2) VALUES(12,12);
503 REPLACE INTO t1(c1,c2) VALUES(1,11);
504 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
505 SELECT * FROM t1 ORDER BY c1;
506 SELECT * FROM t2 ORDER BY c1;
507 SELECT * FROM t3 ORDER BY c1;
508 DELETE FROM t1 WHERE c1=1;
509 DELETE FROM t1 WHERE c1=0;
510 DELETE FROM t1 WHERE c1=NULL;
511 DELETE FROM t1 WHERE c1=6 OR c1=7;
512 DELETE FROM t1 WHERE c2=3;
513 SELECT * FROM t1 ORDER BY c1;
514 SELECT * FROM t2 ORDER BY c1;
515 SELECT * FROM t3 ORDER BY c1;
517 CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
518 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
519 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 FLOAT, new1 FLOAT, old2 FLOAT, new2 FLOAT);
520 CREATE TABLE t3(c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
521 INSERT INTO t3 VALUES(1,0);
524 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
525 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
526 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
529 REPLACE INTO t1(c1,c2) VALUES(12,12);
530 REPLACE INTO t1(c1,c2) VALUES(1,11);
531 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
532 SELECT * FROM t1 ORDER BY c1;
533 SELECT * FROM t2 ORDER BY c1;
534 SELECT * FROM t3 ORDER BY c1;
535 DELETE FROM t1 WHERE c1=1;
536 DELETE FROM t1 WHERE c1=0;
537 DELETE FROM t1 WHERE c1=NULL;
538 DELETE FROM t1 WHERE c1=6 OR c1=7;
539 DELETE FROM t1 WHERE c2=3;
540 SELECT * FROM t1 ORDER BY c1;
541 SELECT * FROM t2 ORDER BY c1;
542 SELECT * FROM t3 ORDER BY c1;
544 CREATE TABLE t1 (c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
545 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
546 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DECIMAL, new1 DECIMAL, old2 DECIMAL, new2 DECIMAL);
547 CREATE TABLE t3(c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
548 INSERT INTO t3 VALUES(1,0);
551 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
552 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
553 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
556 REPLACE INTO t1(c1,c2) VALUES(12,12);
557 REPLACE INTO t1(c1,c2) VALUES(1,11);
558 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
559 SELECT * FROM t1 ORDER BY c1;
560 SELECT * FROM t2 ORDER BY c1;
561 SELECT * FROM t3 ORDER BY c1;
562 DELETE FROM t1 WHERE c1=1;
563 DELETE FROM t1 WHERE c1=0;
564 DELETE FROM t1 WHERE c1=NULL;
565 DELETE FROM t1 WHERE c1=6 OR c1=7;
566 DELETE FROM t1 WHERE c2=3;
567 SELECT * FROM t1 ORDER BY c1;
568 SELECT * FROM t2 ORDER BY c1;
569 SELECT * FROM t3 ORDER BY c1;
571 CREATE TABLE t1 (c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
572 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
573 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 NUMERIC, new1 NUMERIC, old2 NUMERIC, new2 NUMERIC);
574 CREATE TABLE t3(c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
575 INSERT INTO t3 VALUES(1,0);
578 CREATE TRIGGER tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN
579 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c1);
580 UPDATE t3 SET c2 = c2 + OLD.c2 WHERE c1 = 1;
583 REPLACE INTO t1(c1,c2) VALUES(12,12);
584 REPLACE INTO t1(c1,c2) VALUES(1,11);
585 REPLACE INTO t1(c1,c2) VALUES(3,11),(4,11);
586 SELECT * FROM t1 ORDER BY c1;
587 SELECT * FROM t2 ORDER BY c1;
588 SELECT * FROM t3 ORDER BY c1;
589 DELETE FROM t1 WHERE c1=1;
590 DELETE FROM t1 WHERE c1=0;
591 DELETE FROM t1 WHERE c1=NULL;
592 DELETE FROM t1 WHERE c1=6 OR c1=7;
593 DELETE FROM t1 WHERE c2=3;
594 SELECT * FROM t1 ORDER BY c1;
595 SELECT * FROM t2 ORDER BY c1;
596 SELECT * FROM t3 ORDER BY c1;