Debian Codegraph @

mysql-test/suite/atomic/create_trigger2.test

raw
1 --source include/have_debug.inc
2
3 #
4 # Testing of atomic CREATE TRIGGER when write fails in create_definition_file
5 #
6
7 let $MYSQLD_DATADIR= `SELECT @@datadir`;
8
9 let $engine_count=1;
10 let $engines='aria';
11 let $old_debug=`select @@debug_dbug`;
12
13 let $e=0;
14 --disable_query_log
15
16 create table t1 (a int not null, b int not null);
17 insert into t1 values(1,1);
18 flush tables;
19
20 # sql_create_definition_file is called twice per CREATE TRIGGER and 1 more
21 # in case we drop an existing trigger, so we need to test 3*2 +1 failures
22 # and also when there is no failures (= 8)
23 let $try_count=8;
24
25 let $r=0;
26 while ($r < $try_count)
27 {
28 inc $r;
29
30 echo "position: $r";
31 --eval set @@debug_dbug="+d,definition_file_simulate_write_error",@debug_error_counter=$r;
32 let $errno=0;
33 delimiter |;
34 --error 0,3
35 create trigger t1_trg before insert on t1 for each row
36 begin
37 if isnull(new.a) then
38 set new.a:= 1000;
39 end if;
40 end|
41 delimiter ;|
42 let $error=$errno;
43 if ($error == 0)
44 {
45 delimiter |;
46 --error 0,3
47 create or replace trigger t2_trg before insert on t1 for each row
48 begin
49 if isnull(new.b) then
50 set new.b:= 2000;
51 end if;
52 end|
53 delimiter ;|
54 let $error=$errno;
55 }
56 if ($error == 0)
57 {
58 delimiter |;
59 --error 0,3
60 create or replace trigger t2_trg before insert on t1 for each row
61 begin
62 if isnull(new.b) then
63 set new.b:= 3000;
64 end if;
65 end|
66 delimiter ;|
67 let $error=$errno;
68 }
69 --eval set @@debug_dbug="$old_debug"
70
71 # Check which tables still exists
72 --list_files $MYSQLD_DATADIR/test *TR*
73 --list_files $MYSQLD_DATADIR/test *sql*
74
75 --replace_column 7 #
76 --error 0,ER_TRG_DOES_NOT_EXIST
77 SHOW CREATE TRIGGER t1_trg;
78 --replace_column 7 #
79 --error 0,ER_TRG_DOES_NOT_EXIST
80 SHOW CREATE TRIGGER t2_trg;
81 --disable_warnings
82 drop trigger if exists t1_trg;
83 drop trigger if exists t2_trg;
84 --enable_warnings
85 }
86
87 drop table t1;
88
89 --enable_query_log