Debian Codegraph @

mysql-test/suite/atomic/drop_trigger.test

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