Debian Codegraph @

mysql-test/suite/atomic/create_trigger.test

raw
1 --source include/have_debug.inc
2 --source include/have_log_bin.inc
3 --source include/not_valgrind.inc
4
5 # Speed up wait_until_connected_again.inc
6 let NO_WSREP=1;
7 RESET MASTER;
8
9 #
10 # Testing of atomic CREATE TRIGGER with crashes in a lot of different places
11 #
12
13 let $MYSQLD_DATADIR= `SELECT @@datadir`;
14
15 let $engine_count=1;
16 let $engines='aria';
17
18 let $crash_count=6;
19 let $crash_points='ddl_log_create_before_create_trigger', 'ddl_log_create_after_create_trigger', 'definition_file_after_create', 'ddl_log_drop_before_binlog', 'ddl_log_drop_after_binlog','ddl_log_drop_before_delete_tmp';
20
21 let $old_debug=`select @@debug_dbug`;
22
23 let $e=0;
24 let $keep_include_silent=1;
25 let $grep_script=CREATE.*TRIGGER;
26 let $drops=3;
27 --disable_query_log
28
29 while ($e < $engine_count)
30 {
31 inc $e;
32 let $engine=`select ELT($e, $engines)`;
33 let $default_engine=$engine;
34 let $extra_option=;
35
36 if ($engine == "aria")
37 {
38 let $extra_option=transactional=1;
39 }
40 if ($engine == "aria_notrans")
41 {
42 let $default_engine="aria";
43 let $extra_option=transactional=0;
44 }
45 --eval set @@default_storage_engine=$default_engine
46 --eval create table t1 (a int not null, b int not null) $extra_option;
47 insert into t1 values(1,1);
48 flush tables;
49
50 let $c=0;
51 while ($c < $crash_count)
52 {
53 inc $c;
54 let $crash=`select ELT($c, $crash_points)`;
55 let $r=0;
56 while ($r < $drops)
57 {
58 inc $r;
59
60 FLUSH BINARY LOGS;
61 --let $start_binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
62
63 echo "engine: $engine crash point: $crash position: $r";
64 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
65 --disable_reconnect
66 --eval set @@debug_dbug="+d,$crash",@debug_crash_counter=$r
67 let $errno=0;
68 delimiter |;
69 --error 0,2013
70 CREATE TRIGGER t1_trg before insert on t1 for each row
71 begin
72 if isnull(new.a) then
73 set new.a:= 1000;
74 end if;
75 end|
76 delimiter ;|
77 let $error=$errno;
78 if ($error == 0)
79 {
80 delimiter |;
81 --error 0,2013
82 CREATE OR REPLACE TRIGGER t2_trg before insert on t1 for each row
83 begin
84 if isnull(new.b) then
85 set new.b:= 2000;
86 end if;
87 end|
88 delimiter ;|
89 let $error=$errno;
90 }
91 if ($error == 0)
92 {
93 delimiter |;
94 --error 0,2013
95 CREATE OR REPLACE TRIGGER t2_trg before insert on t1 for each row
96 begin
97 if isnull(new.b) then
98 set new.b:= 3000;
99 end if;
100 end|
101 delimiter ;|
102 let $error=$errno;
103 }
104 --enable_reconnect
105 --source include/wait_until_connected_again.inc
106 --disable_query_log
107 --eval set @@debug_dbug="$old_debug"
108
109 if ($error == 0)
110 {
111 echo "No crash!";
112 }
113 # Check which tables still exists
114 --list_files $MYSQLD_DATADIR/test *TR*
115 --list_files $MYSQLD_DATADIR/test *sql*
116
117 --replace_column 7 #
118 --error 0,ER_TRG_DOES_NOT_EXIST
119 SHOW CREATE TRIGGER t1_trg;
120 --replace_column 7 #
121 --error 0,ER_TRG_DOES_NOT_EXIST
122 SHOW CREATE TRIGGER t2_trg;
123
124 --let $binlog_file=$start_binlog_file
125 --let $binlog_output_name=master-bin.000001
126 --source include/show_binlog_events.inc
127 --disable_warnings
128 drop trigger if exists t1_trg;
129 drop trigger if exists t2_trg;
130 --enable_warnings
131 }
132 }
133 }
134
135 drop table t1;
136
137 --enable_query_log