Debian Codegraph @

mysql-test/suite/atomic/alter_table_big_query.test

raw
1 --source include/have_debug.inc
2 --source include/have_sequence.inc
3 --source include/have_innodb.inc
4 --source include/have_log_bin.inc
5 --source include/not_valgrind.inc
6
7 #
8 # Testing of query > 4K. For this we do not have to run many tests as we
9 # only want to test the query storage, which is identical for all cases.
10 #
11
12 --disable_query_log
13 call mtr.add_suppression("InnoDB: .* does not exist in the InnoDB internal");
14 # Speed up wait_until_connected_again.inc
15 let NO_WSREP=1;
16 RESET MASTER;
17
18 --enable_query_log
19 let $MYSQLD_DATADIR= `SELECT @@datadir`;
20
21 let $engine_count=1;
22 let $engines='myisam';
23
24 let $crash_count=1;
25 let $crash_points='ddl_log_alter_after_log';
26
27 let $statement_count=2;
28 let $statements='ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"',
29 'ALTER TABLE t1 COMMENT "new"';
30
31 # If there is a need of testing one specific state (crash point and query),
32 # one can remove the comments below and modify them.
33 #let $crash_count=1;
34 #let $crash_points='ddl_log_alter_before_rename_triggers';
35 #let $statement_count= 1;
36 #let $statements='ALTER TABLE t1 change column b c int, COMMENT "new"';
37
38 let $old_debug=`select @@debug_dbug`;
39
40 let $e=0;
41 let $keep_include_silent=1;
42 let $grep_script=ALTER;
43 --disable_query_log
44
45 while ($e < $engine_count)
46 {
47 inc $e;
48 let $engine=`select ELT($e, $engines)`;
49 let $default_engine=$engine;
50
51 --echo
52 --echo engine: $engine
53 --echo
54
55 let $r=0;
56 while ($r < $statement_count)
57 {
58 inc $r;
59 let $statement=`select ELT($r, $statements)`;
60 --echo
61 --echo query: $statement
62 let $statement=`select concat(replace('$statement', "new", repeat("x",2000)), "/* long code comment: ", repeat("y",6000), "*/")`;
63 --echo
64 let $c=0;
65 while ($c < $crash_count)
66 {
67 inc $c;
68 let $crash=`select ELT($c, $crash_points)`;
69
70 --eval create table t1 (a int, b int) engine=$engine
71 insert into t1 (a) values (1),(2);
72 flush tables;
73
74 FLUSH BINARY LOGS;
75 --let $start_binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
76 --echo crash point: $crash
77 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
78 --disable_reconnect
79 --eval set @@debug_dbug="+d,$crash",@debug_crash_counter=1
80 let $errno=0;
81 --error 0,2013
82 --eval $statement;
83 let $error=$errno;
84 --enable_reconnect
85 --source include/wait_until_connected_again.inc
86 --disable_query_log
87 --eval set @@debug_dbug="$old_debug"
88
89 if ($error == 0)
90 {
91 echo "No crash!";
92 }
93 if ($error != 0)
94 {
95 --list_files $MYSQLD_DATADIR/test t*
96 --list_files $MYSQLD_DATADIR/test *sql*
97 show create table t1;
98 select sum(a) from t1;
99 --let $binlog_file=$start_binlog_file
100 --let $binlog_output_name=master-bin.000001
101 --source include/show_binlog_events.inc
102 if ($error)
103 {
104 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
105 --let $binlog_output_name=master-bin.000002
106 if ($binlog_file != $start_binlog_file)
107 {
108 --source include/show_binlog_events.inc
109 }
110 }
111 }
112 --disable_warnings
113 drop table if exists t1,t2;
114 --enable_warnings
115 }
116 }
117 }
118
119 --enable_query_log