Debian Codegraph @

mysql-test/suite/parts/inc/partition_fail_t2.inc

raw
1 # Include file to test failure with error injection.
2 # To be used with WL#4445: EXCHANGE PARTITION WITH TABLE.
3 --eval $create_statement2
4 --eval $insert_statement2
5 --eval $create_statement
6 --eval $insert_statement
7 --let $dbug_flag= `select @@session.debug_dbug`
8 --echo # $dbug_flag: BEFORE failure
9 --replace_result #p# #P#
10 if (!$DATADIR)
11 {
12 --let $DATADIR= `SELECT @@datadir;`
13 }
14 --list_files $DATADIR/test
15 SHOW CREATE TABLE t1;
16 --sorted_result
17 SELECT * FROM t1;
18 SHOW CREATE TABLE t2;
19 --sorted_result
20 SELECT * FROM t2;
21 # accept all errors
22 --disable_abort_on_error
23 --replace_regex /#sql-exchange-[0-9a-f_\-]*/#sql-exchange/i
24 --eval $fail_statement
25 --enable_abort_on_error
26 --echo # $dbug_flag: AFTER failure
27 --replace_result #p# #P#
28 --list_files $DATADIR/test
29 SHOW CREATE TABLE t1;
30 --sorted_result
31 SELECT * FROM t1;
32 DROP TABLE t1;
33 --error 0, ER_NO_SUCH_TABLE
34 SHOW CREATE TABLE t2;
35 --sorted_result
36 --error 0, ER_NO_SUCH_TABLE
37 SELECT * FROM t2;
38 # TODO: everything fails with ER_NO_SUCH_TABLE
39 # but DROP TABLE fails with ER_BAD_TABLE_ERROR! Why?
40 --error 0, ER_BAD_TABLE_ERROR
41 DROP TABLE t2;