Debian Codegraph @

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

raw
1 # Author: Horst Hunger
2 # Created: 2010-07-05
3
4
5 let $engine_table= MYISAM;
6 let $engine_part= InnoDB;
7 let $engine_subpart= InnoDB;
8
9 use test;
10
11 --disable_result_log
12 --disable_query_log
13 --source suite/parts/inc/part_exch_tabs.inc
14
15 --sorted_result
16 SELECT * FROM t_10;
17 --sorted_result
18 SELECT * FROM t_100;
19 --sorted_result
20 SELECT * FROM t_1000;
21 --sorted_result
22 SELECT * FROM tp;
23 --sorted_result
24 SELECT * FROM tsp;
25 --sorted_result
26 SELECT * FROM tsp_00;
27 --sorted_result
28 SELECT * FROM tsp_01;
29 --sorted_result
30 SELECT * FROM tsp_02;
31 --sorted_result
32 SELECT * FROM tsp_03;
33 --sorted_result
34 SELECT * FROM tsp_04;
35 --enable_result_log
36 --enable_query_log
37
38 # 5) Exchanges with different engines.
39 --error ER_MIX_HANDLER_ERROR
40 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
41 --error ER_MIX_HANDLER_ERROR
42 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
43
44 --source suite/parts/inc/part_exch_drop_tabs.inc
45