Debian Codegraph @

mysql-test/suite/atomic/alter_partition.test

raw
1 --source include/have_partition.inc
2 --source include/have_debug.inc
3 --source include/have_sequence.inc
4 --source include/binlog_format_combinations.inc
5 --source include/have_binlog_format_row_or_statement.inc
6 --source include/not_valgrind.inc
7
8 let $default_engine=InnoDB;
9 let $extra_option=;
10 let $save_debug=`select @@debug_dbug`;
11
12 if ($MTR_COMBINATION_MYISAM)
13 {
14 let $default_engine=MyISAM;
15 }
16 if ($MTR_COMBINATION_ARIA)
17 {
18 let $default_engine=Aria;
19 let $extra_option=transactional=1;
20 }
21
22 if ($MTR_COMBINATION_STMT)
23 {
24 let $binlog_format=include/set_binlog_format_statement.sql;
25 }
26 if ($MTR_COMBINATION_ROW)
27 {
28 let $binlog_format=include/set_binlog_format_row.sql;
29 }
30
31 --disable_query_log
32 --eval set @@default_storage_engine=$default_engine
33 --enable_query_log
34
35 --echo # Crash recovery
36
37 let $MYSQLD_DATADIR= `SELECT @@datadir`;
38
39 let $crash_count= 14;
40 let $crash_points='crash_create_before_create_frm',
41 'crash_alter_partition_after_create_frm',
42 'crash_alter_partition_after_write_frm',
43 'crash_convert_partition_1',
44 'crash_convert_partition_2',
45 'crash_convert_partition_3',
46 'crash_convert_partition_4',
47 'crash_convert_partition_5',
48 'crash_convert_partition_6',
49 'crash_convert_partition_7',
50 'crash_convert_partition_8',
51 'crash_convert_partition_9',
52 'crash_convert_partition_10',
53 'crash_convert_partition_11';
54
55 #let $crash_count= 1;
56 #let $crash_points= 'crash_convert_partition_10';
57
58 let $statement_count= 2;
59 let $statements= 'ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE tp1',
60 'ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)';
61
62 #let $statement_count= 1;
63 #let $statements= 'ALTER TABLE t1 CONVERT TABLE tp2 TO PARTITION p2 values less than (40)';
64
65 --delimiter $
66 create or replace procedure prepare_table(r int)
67 begin
68 create or replace table t1 (x int)
69 with system versioning
70 partition by range(x) (
71 partition p0 values less than (10),
72 partition p1 values less than (20),
73 partition pn values less than (30));
74 insert into t1 values (2), (12), (22);
75
76 if r > 1 then
77 create or replace table tp2 (x int)
78 with system versioning;
79 insert into tp2 values (32), (39);
80 end if;
81
82 flush tables;
83 end $
84 --delimiter ;
85
86 let $old_debug=`select @@debug_dbug`;
87
88 let $keep_include_silent=1;
89 let $grep_script=ALTER;
90 --disable_query_log
91
92 let $r=0;
93 while ($r < $statement_count)
94 {
95 inc $r;
96 let $statement=`select ELT($r, $statements)`;
97 --echo # QUERY: $statement
98
99 let $c=0;
100 while ($c < $crash_count)
101 {
102 inc $c;
103 let $crash=`select ELT($c, $crash_points)`;
104
105 --eval set @@default_storage_engine=$default_engine
106 eval call prepare_table($r);
107 if (!$c)
108 {
109 lock tables t1 write;
110 }
111
112 --source $binlog_format
113
114 RESET MASTER;
115 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
116 --disable_reconnect
117 --eval set @@debug_dbug="+d,$crash"
118 let $errno=0;
119 --error 0,2013
120 --eval $statement;
121 let $error=$errno;
122 --enable_reconnect
123 --source include/wait_until_connected_again.inc
124 --disable_query_log
125 --eval set @@debug_dbug="$old_debug"
126
127 if ($error == 0)
128 {
129 --echo # NO CRASH: $crash
130 }
131 if ($error)
132 {
133 --echo # CRASH: $crash
134 }
135 # Check which tables still exists
136 --replace_result MAI MYI MAD MYD
137 --list_files $MYSQLD_DATADIR/test t*
138 --replace_regex /backup-\d+/backup/
139 --list_files $MYSQLD_DATADIR/test *sql*
140 --remove_files_wildcard $MYSQLD_DATADIR/test *sql-backup-*
141
142 --let $binlog_file=master-bin.000001
143 --source include/show_binlog_events.inc
144 if ($error)
145 {
146 --let $binlog_file=master-bin.000002
147 --source include/show_binlog_events.inc
148 }
149
150 --replace_result $default_engine DEFAULT_ENGINE ' PAGE_CHECKSUM=1' ''
151 show create table t1;
152 select * from t1;
153 --replace_result $default_engine DEFAULT_ENGINE ' PAGE_CHECKSUM=1' ''
154 --error 0, ER_NO_SUCH_TABLE
155 show create table tp1;
156 --error 0, ER_NO_SUCH_TABLE
157 select * from tp1;
158 --replace_result $default_engine DEFAULT_ENGINE ' PAGE_CHECKSUM=1' ''
159 --error 0, ER_NO_SUCH_TABLE
160 show create table tp2;
161 --error 0, ER_NO_SUCH_TABLE
162 select * from tp2;
163 # Drop the tables. The warnings will show what was dropped
164 --disable_warnings
165 drop table t1;
166 drop table if exists tp1;
167 --enable_warnings
168 }
169 }
170 drop table if exists t1;
171 drop procedure prepare_table;
172 --eval set @@debug_dbug="$save_debug"
173
174 --enable_query_log