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;