Debian Codegraph @

mysql-test/suite/engines/funcs/t/tr_insert_after_error.test

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