Debian Codegraph @

mysql-test/suite/funcs_1/r/memory_trig_1011ext.result

raw
1 SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2 USE test;
3 drop table if exists tb3;
4 create table tb3 (
5 f118 char not null DEFAULT 'a',
6 f119 char binary not null DEFAULT b'101',
7 f120 char ascii not null DEFAULT b'101',
8 f121 char(50),
9 f122 char(50),
10 f129 binary not null DEFAULT b'101',
11 f130 tinyint not null DEFAULT 99,
12 f131 tinyint unsigned not null DEFAULT 99,
13 f132 tinyint zerofill not null DEFAULT 99,
14 f133 tinyint unsigned zerofill not null DEFAULT 99,
15 f134 smallint not null DEFAULT 999,
16 f135 smallint unsigned not null DEFAULT 999,
17 f136 smallint zerofill not null DEFAULT 999,
18 f137 smallint unsigned zerofill not null DEFAULT 999,
19 f138 mediumint not null DEFAULT 9999,
20 f139 mediumint unsigned not null DEFAULT 9999,
21 f140 mediumint zerofill not null DEFAULT 9999,
22 f141 mediumint unsigned zerofill not null DEFAULT 9999,
23 f142 int not null DEFAULT 99999,
24 f143 int unsigned not null DEFAULT 99999,
25 f144 int zerofill not null DEFAULT 99999,
26 f145 int unsigned zerofill not null DEFAULT 99999,
27 f146 bigint not null DEFAULT 999999,
28 f147 bigint unsigned not null DEFAULT 999999,
29 f148 bigint zerofill not null DEFAULT 999999,
30 f149 bigint unsigned zerofill not null DEFAULT 999999,
31 f150 decimal not null DEFAULT 999.999,
32 f151 decimal unsigned not null DEFAULT 999.17,
33 f152 decimal zerofill not null DEFAULT 999.999,
34 f153 decimal unsigned zerofill,
35 f154 decimal (0),
36 f155 decimal (64),
37 f156 decimal (0) unsigned,
38 f157 decimal (64) unsigned,
39 f158 decimal (0) zerofill,
40 f159 decimal (64) zerofill,
41 f160 decimal (0) unsigned zerofill,
42 f161 decimal (64) unsigned zerofill,
43 f162 decimal (0,0),
44 f163 decimal (63,30),
45 f164 decimal (0,0) unsigned,
46 f165 decimal (63,30) unsigned,
47 f166 decimal (0,0) zerofill,
48 f167 decimal (63,30) zerofill,
49 f168 decimal (0,0) unsigned zerofill,
50 f169 decimal (63,30) unsigned zerofill,
51 f170 numeric,
52 f171 numeric unsigned,
53 f172 numeric zerofill,
54 f173 numeric unsigned zerofill,
55 f174 numeric (0),
56 f175 numeric (64)
57 ) charset latin1 engine = <engine_to_be_used>;
58 Warnings:
59 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
60 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
61 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
62 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
63 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
64 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
65 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
66 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
67 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
68 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
69 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
70 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
71 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
72 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
73 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
74 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
75 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
76 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
77 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
78 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
79 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
80 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
81 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
82 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
83 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
84 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
85 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
86 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
87 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
88 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
89 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
90 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
91 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
92 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
93 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
94 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
95 Note 1265 Data truncated for column 'f150' at row 1
96 Note 1265 Data truncated for column 'f151' at row 1
97 Note 1265 Data truncated for column 'f152' at row 1
98 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/memory_tb3.txt'
99 into table tb3 character set latin1;
100 Warnings:
101 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
102
103 Testcase 3.5.10.1/2/3:
104 ----------------------
105 Warnings:
106 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
107 Create view vw11 as select * from tb3
108 where f122 like 'Test 3.5.10.1/2/3%';
109 Create trigger trg1a before insert on tb3
110 for each row set new.f163=111.11;
111 Create trigger trg1b after insert on tb3
112 for each row set @test_var='After Insert';
113 Create trigger trg1c before update on tb3
114 for each row set new.f121='Y', new.f122='Test 3.5.10.1/2/3-Update';
115 Create trigger trg1d after update on tb3
116 for each row set @test_var='After Update';
117 Create trigger trg1e before delete on tb3
118 for each row set @test_var=5;
119 Create trigger trg1f after delete on tb3
120 for each row set @test_var= 2* @test_var+7;
121 Insert into vw11 (f122, f151) values ('Test 3.5.10.1/2/3', 1);
122 Insert into vw11 (f122, f151) values ('Test 3.5.10.1/2/3', 2);
123 Insert into vw11 (f122, f151) values ('Not in View', 3);
124 select f121, f122, f151, f163
125 from tb3 where f122 like 'Test 3.5.10.1/2/3%' order by f151;
126 f121 f122 f151 f163
127 NULL Test 3.5.10.1/2/3 1 111.110000000000000000000000000000
128 NULL Test 3.5.10.1/2/3 2 111.110000000000000000000000000000
129 select f121, f122, f151, f163 from vw11;
130 f121 f122 f151 f163
131 NULL Test 3.5.10.1/2/3 1 111.110000000000000000000000000000
132 NULL Test 3.5.10.1/2/3 2 111.110000000000000000000000000000
133 select f121, f122, f151, f163
134 from tb3 where f122 like 'Not in View';
135 f121 f122 f151 f163
136 NULL Not in View 3 111.110000000000000000000000000000
137 Update vw11 set f163=1;
138 select f121, f122, f151, f163 from tb3
139 where f122 like 'Test 3.5.10.1/2/3%' order by f151;
140 f121 f122 f151 f163
141 Y Test 3.5.10.1/2/3-Update 1 1.000000000000000000000000000000
142 Y Test 3.5.10.1/2/3-Update 2 1.000000000000000000000000000000
143 select f121, f122, f151, f163 from vw11;
144 f121 f122 f151 f163
145 Y Test 3.5.10.1/2/3-Update 1 1.000000000000000000000000000000
146 Y Test 3.5.10.1/2/3-Update 2 1.000000000000000000000000000000
147 set @test_var=0;
148 Select @test_var as 'before delete';
149 before delete
150 0
151 delete from vw11 where f151=1;
152 select f121, f122, f151, f163 from tb3
153 where f122 like 'Test 3.5.10.1/2/3%' order by f151;
154 f121 f122 f151 f163
155 Y Test 3.5.10.1/2/3-Update 2 1.000000000000000000000000000000
156 select f121, f122, f151, f163 from vw11;
157 f121 f122 f151 f163
158 Y Test 3.5.10.1/2/3-Update 2 1.000000000000000000000000000000
159 Select @test_var as 'after delete';
160 after delete
161 17
162 drop view vw11;
163 drop trigger trg1a;
164 drop trigger trg1b;
165 drop trigger trg1c;
166 drop trigger trg1d;
167 drop trigger trg1e;
168 drop trigger trg1f;
169 delete from tb3 where f122 like 'Test 3.5.10.1/2/3%';
170 Warnings:
171 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
172
173 Testcase 3.5.10.4:
174 ------------------
175 Warnings:
176 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
177 create table tb_load (f1 int, f2 char(25),f3 int) engine = <engine_to_be_used>;
178 Create trigger trg4 before insert on tb_load
179 for each row set new.f3=-(new.f1 div 5), @counter= @counter+1;
180 set @counter= 0;
181 select @counter as 'Rows Loaded Before';
182 Rows Loaded Before
183 0
184 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t9.txt' into table tb_load character set latin1;
185 select @counter as 'Rows Loaded After';
186 Rows Loaded After
187 10
188 Select * from tb_load order by f1 limit 10;
189 f1 f2 f3
190 -5000 a` 1000
191 -4999 aaa 999
192 -4998 abaa 999
193 -4997 acaaa 999
194 -4996 adaaaa 999
195 -4995 aeaaaaa 999
196 -4994 afaaaaaa 998
197 -4993 agaaaaaaa 998
198 -4992 a^aaaaaaaa 998
199 -4991 a_aaaaaaaaa 998
200 drop trigger trg4;
201 drop table tb_load;
202 Warnings:
203 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
204
205 Testcase 3.5.10.5: (implemented in trig_frkey.test)
206 ---------------------------------------------------
207 Warnings:
208 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
209 Warnings:
210 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
211
212 Testcase 3.5.10.6: (implemented in trig_frkey.test)
213 ---------------------------------------------------
214 Warnings:
215 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
216 Warnings:
217 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
218
219 Testcase 3.5.10.extra:
220 ----------------------
221 Warnings:
222 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
223 create table t1_sp (var136 tinyint, var151 decimal) engine = <engine_to_be_used>;
224 create trigger trg before insert on t1_sp
225 for each row set @counter=@counter+1;
226 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
227 create procedure trig_sp()
228 begin
229 declare done int default 0;
230 declare var151 decimal;
231 declare var136 tinyint;
232 declare cur1 cursor for select f136, f151 from tb3;
233 declare continue handler for sqlstate '01000' set done = 1;
234 open cur1;
235 fetch cur1 into var136, var151;
236 wl_loop: WHILE NOT done DO
237 insert into t1_sp values (var136, var151);
238 fetch cur1 into var136, var151;
239 END WHILE wl_loop;
240 close cur1;
241 end//
242 set @counter=0;
243 select @counter;
244 @counter
245 0
246 call trig_sp();
247 ERROR 02000: No data - zero rows fetched, selected, or processed
248 select @counter;
249 @counter
250 11
251 select count(*) from tb3;
252 count(*)
253 11
254 select count(*) from t1_sp;
255 count(*)
256 11
257 drop procedure trig_sp;
258 drop trigger trg;
259 drop table t1_sp;
260 Warnings:
261 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
262
263 Testcase 3.5.11.1 (implemented in trig_perf.test)
264 -------------------------------------------------
265 Warnings:
266 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
267 Warnings:
268 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
269
270 Testcase y.y.y.2: Check for triggers starting triggers
271 ------------------------------------------------------
272 Warnings:
273 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
274 use test;
275 drop table if exists t1;
276 drop table if exists t2_1;
277 drop table if exists t2_2;
278 drop table if exists t2_3;
279 drop table if exists t2_4;
280 drop table if exists t3;
281 create table t1 (f1 integer) engine = <engine_to_be_used>;
282 create table t2_1 (f1 integer) engine = <engine_to_be_used>;
283 create table t2_2 (f1 integer) engine = <engine_to_be_used>;
284 create table t2_3 (f1 integer) engine = <engine_to_be_used>;
285 create table t2_4 (f1 integer) engine = <engine_to_be_used>;
286 create table t3 (f1 integer) engine = <engine_to_be_used>;
287 insert into t1 values (1);
288 create trigger tr1 after insert on t1 for each row
289 BEGIN
290 insert into t2_1 (f1) values (new.f1+1);
291 insert into t2_2 (f1) values (new.f1+1);
292 insert into t2_3 (f1) values (new.f1+1);
293 insert into t2_4 (f1) values (new.f1+1);
294 END//
295 create trigger tr2_1 after insert on t2_1 for each row
296 insert into t3 (f1) values (new.f1+10);
297 create trigger tr2_2 after insert on t2_2 for each row
298 insert into t3 (f1) values (new.f1+100);
299 create trigger tr2_3 after insert on t2_3 for each row
300 insert into t3 (f1) values (new.f1+1000);
301 create trigger tr2_4 after insert on t2_4 for each row
302 insert into t3 (f1) values (new.f1+10000);
303 insert into t1 values (1);
304 select * from t3 order by f1;
305 f1
306 12
307 102
308 1002
309 10002
310 drop trigger tr1;
311 drop trigger tr2_1;
312 drop trigger tr2_2;
313 drop trigger tr2_3;
314 drop trigger tr2_4;
315 drop table t1, t2_1, t2_2, t2_3, t2_4, t3;
316 Warnings:
317 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
318
319 Testcase y.y.y.3: Circular trigger reference
320 --------------------------------------------
321 Warnings:
322 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
323 use test;
324 drop table if exists t1;
325 drop table if exists t2;
326 drop table if exists t3;
327 drop table if exists t4;
328 create table t1 (f1 integer) engine = <engine_to_be_used>;
329 create table t2 (f2 integer) engine = <engine_to_be_used>;
330 create table t3 (f3 integer) engine = <engine_to_be_used>;
331 create table t4 (f4 integer) engine = <engine_to_be_used>;
332 insert into t1 values (0);
333 create trigger tr1 after insert on t1
334 for each row insert into t2 (f2) values (new.f1+1);
335 create trigger tr2 after insert on t2
336 for each row insert into t3 (f3) values (new.f2+1);
337 create trigger tr3 after insert on t3
338 for each row insert into t4 (f4) values (new.f3+1);
339 create trigger tr4 after insert on t4
340 for each row insert into t1 (f1) values (new.f4+1);
341 insert into t1 values (1);
342 ERROR HY000: Can't update table 't1' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
343 select * from t1 order by f1;
344 f1
345 0
346 1
347 select * from t2 order by f2;
348 f2
349 2
350 select * from t3 order by f3;
351 f3
352 3
353 select * from t4 order by f4;
354 f4
355 4
356 drop trigger tr1;
357 drop trigger tr2;
358 drop trigger tr3;
359 drop trigger tr4;
360 drop table t1;
361 drop table t2;
362 drop table t3;
363 drop table t4;
364 Warnings:
365 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
366
367 Testcase y.y.y.4: Recursive trigger/SP references
368 -------------------------------------------------
369 Warnings:
370 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
371 set @sql_mode='traditional';
372 create table t1_sp (
373 count integer,
374 var136 tinyint,
375 var151 decimal) engine = <engine_to_be_used>;
376 create procedure trig_sp()
377 begin
378 declare done int default 0;
379 declare var151 decimal;
380 declare var136 tinyint;
381 declare cur1 cursor for select f136, f151 from tb3;
382 declare continue handler for sqlstate '01000' set done = 1;
383 set @counter= @counter+1;
384 open cur1;
385 fetch cur1 into var136, var151;
386 wl_loop: WHILE NOT done DO
387 insert into t1_sp values (@counter, var136, var151);
388 fetch cur1 into var136, var151;
389 END WHILE wl_loop;
390 close cur1;
391 end//
392 create trigger trg before insert on t1_sp
393 for each row call trig_sp();
394 set @counter=0;
395 select @counter;
396 @counter
397 0
398 call trig_sp();
399 ERROR HY000: Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine trig_sp
400 select @counter;
401 @counter
402 1
403 select count(*) from tb3;
404 count(*)
405 11
406 select count(*) from t1_sp;
407 count(*)
408 0
409 set @@max_sp_recursion_depth= 10;
410 set @counter=0;
411 select @counter;
412 @counter
413 0
414 call trig_sp();
415 ERROR HY000: Can't update table 't1_sp' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
416 select @counter;
417 @counter
418 2
419 select count(*) from tb3;
420 count(*)
421 11
422 select count(*) from t1_sp;
423 count(*)
424 0
425 drop procedure trig_sp;
426 drop trigger trg;
427 drop table t1_sp;
428 Warnings:
429 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
430
431 Testcase y.y.y.5: Rollback of nested trigger references
432 -------------------------------------------------------
433 Warnings:
434 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
435 set @@sql_mode='traditional';
436 use test;
437 drop table if exists t1;
438 drop table if exists t2;
439 drop table if exists t3;
440 drop table if exists t4;
441 create table t1 (f1 integer) engine = <engine_to_be_used>;
442 create table t2 (f2 integer) engine = <engine_to_be_used>;
443 create table t3 (f3 integer) engine = <engine_to_be_used>;
444 create table t4 (f4 tinyint) engine = <engine_to_be_used>;
445 insert into t1 values (1);
446 create trigger tr1 after insert on t1
447 for each row insert into t2 (f2) values (new.f1+1);
448 create trigger tr2 after insert on t2
449 for each row insert into t3 (f3) values (new.f2+1);
450 create trigger tr3 after insert on t3
451 for each row insert into t4 (f4) values (new.f3+1000);
452 set autocommit=0;
453 start transaction;
454 insert into t1 values (1);
455 ERROR 22003: Out of range value for column 'f4' at row 1
456 commit;
457 select * from t1 order by f1;
458 f1
459 1
460 1
461 select * from t2 order by f2;
462 f2
463 2
464 select * from t3 order by f3;
465 f3
466 3
467 drop trigger tr1;
468 drop trigger tr2;
469 drop trigger tr3;
470 drop table t1;
471 drop table t2;
472 drop table t3;
473 drop table t4;
474 DROP TABLE test.tb3;
475 SET sql_mode = default;