Debian Codegraph @

mysql-test/suite/parts/t/partition_exch_qa_11.test

raw
1 # Author: Horst Hunger
2 # Created: 2010-07-13
3
4 --source include/have_partition.inc
5
6 let $engine_table= MYISAM;
7 let $engine_part= MYISAM;
8 let $engine_subpart= MYISAM;
9
10 use test;
11
12 --disable_result_log
13 --disable_query_log
14 --source suite/parts/inc/part_exch_tabs.inc
15 --enable_result_log
16 --enable_query_log
17
18 # 13) Exchange with dynamic variables.
19 SET @part= 'p0';
20 SET @part_tab= 'tp';
21 SET @table= 't_10';
22 SET @s= CONCAT('ALTER TABLE ',@part_tab,' EXCHANGE PARTITION ',@part,' WITH TABLE ',@table);
23 PREPARE test_stmt1 FROM @s;
24 EXECUTE test_stmt1;
25 --sorted_result
26 SELECT * FROM t_10;
27 --sorted_result
28 SELECT * FROM tp;
29 DEALLOCATE PREPARE test_stmt1;
30
31 SET @part_tab= 'tp';
32 SET @s= CONCAT('ALTER TABLE ',@part_tab,' EXCHANGE PARTITION ? WITH TABLE ?');
33 --error ER_PARSE_ERROR
34 PREPARE test_stmt2 FROM @s;
35
36 --source suite/parts/inc/part_exch_drop_tabs.inc
37