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 INSERT ON t1 FOR EACH ROW BEGIN
12 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
13 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
17 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
18 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
19 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 SMALLINT, new1 SMALLINT, old2 SMALLINT, new2 SMALLINT);
20 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
21 INSERT INTO t3 VALUES(1,0);
24 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
25 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
26 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
30 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
31 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
32 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 MEDIUMINT, new1 MEDIUMINT, old2 MEDIUMINT, new2 MEDIUMINT);
33 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
34 INSERT INTO t3 VALUES(1,0);
37 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
38 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
39 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
43 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT);
44 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
45 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INT, new1 INT, old2 INT, new2 INT);
46 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY, c2 INT);
47 INSERT INTO t3 VALUES(1,0);
50 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
51 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
52 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
56 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
57 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
58 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INTEGER, new1 INTEGER, old2 INTEGER, new2 INTEGER);
59 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
60 INSERT INTO t3 VALUES(1,0);
63 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
64 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
65 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
69 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
70 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
71 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 BIGINT, new1 BIGINT, old2 BIGINT, new2 BIGINT);
72 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
73 INSERT INTO t3 VALUES(1,0);
76 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
77 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
78 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
82 CREATE TABLE t1 (c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
83 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
84 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 REAL, new1 REAL, old2 REAL, new2 REAL);
85 CREATE TABLE t3(c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
86 INSERT INTO t3 VALUES(1,0);
89 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
90 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
91 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
95 CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
96 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
97 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DOUBLE, new1 DOUBLE, old2 DOUBLE, new2 DOUBLE);
98 CREATE TABLE t3(c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
99 INSERT INTO t3 VALUES(1,0);
102 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
103 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
104 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
108 CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
109 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
110 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 FLOAT, new1 FLOAT, old2 FLOAT, new2 FLOAT);
111 CREATE TABLE t3(c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
112 INSERT INTO t3 VALUES(1,0);
115 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
116 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
117 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
121 CREATE TABLE t1 (c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
122 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
123 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DECIMAL, new1 DECIMAL, old2 DECIMAL, new2 DECIMAL);
124 CREATE TABLE t3(c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
125 INSERT INTO t3 VALUES(1,0);
128 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
129 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
130 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
134 CREATE TABLE t1 (c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
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 NUMERIC, new1 NUMERIC, old2 NUMERIC, new2 NUMERIC);
137 CREATE TABLE t3(c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
138 INSERT INTO t3 VALUES(1,0);
141 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
142 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
143 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
147 CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT);
148 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
149 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 TINYINT, new1 TINYINT, old2 TINYINT, new2 TINYINT);
150 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT);
151 INSERT INTO t3 VALUES(1,0);
154 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
155 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
156 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
160 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
161 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
162 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 SMALLINT, new1 SMALLINT, old2 SMALLINT, new2 SMALLINT);
163 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT);
164 INSERT INTO t3 VALUES(1,0);
167 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
168 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
169 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
173 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
174 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
175 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 MEDIUMINT, new1 MEDIUMINT, old2 MEDIUMINT, new2 MEDIUMINT);
176 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT);
177 INSERT INTO t3 VALUES(1,0);
180 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
181 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
182 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
186 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT);
187 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
188 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INT, new1 INT, old2 INT, new2 INT);
189 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY, c2 INT);
190 INSERT INTO t3 VALUES(1,0);
193 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
194 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
195 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
199 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
200 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
201 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INTEGER, new1 INTEGER, old2 INTEGER, new2 INTEGER);
202 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER);
203 INSERT INTO t3 VALUES(1,0);
206 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
207 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
208 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
212 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
213 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
214 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 BIGINT, new1 BIGINT, old2 BIGINT, new2 BIGINT);
215 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
216 INSERT INTO t3 VALUES(1,0);
219 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
220 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
221 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
225 CREATE TABLE t1 (c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
226 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
227 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 REAL, new1 REAL, old2 REAL, new2 REAL);
228 CREATE TABLE t3(c1 REAL NOT NULL PRIMARY KEY, c2 REAL);
229 INSERT INTO t3 VALUES(1,0);
232 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
233 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
234 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
238 CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
239 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
240 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DOUBLE, new1 DOUBLE, old2 DOUBLE, new2 DOUBLE);
241 CREATE TABLE t3(c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE);
242 INSERT INTO t3 VALUES(1,0);
245 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
246 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
247 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
251 CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
252 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
253 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 FLOAT, new1 FLOAT, old2 FLOAT, new2 FLOAT);
254 CREATE TABLE t3(c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT);
255 INSERT INTO t3 VALUES(1,0);
258 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
259 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
260 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
264 CREATE TABLE t1 (c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
265 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
266 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DECIMAL, new1 DECIMAL, old2 DECIMAL, new2 DECIMAL);
267 CREATE TABLE t3(c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL);
268 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(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
273 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;
277 CREATE TABLE t1 (c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
278 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10);
279 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 NUMERIC, new1 NUMERIC, old2 NUMERIC, new2 NUMERIC);
280 CREATE TABLE t3(c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC);
281 INSERT INTO t3 VALUES(1,0);
284 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
285 INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2);
286 UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1;