Debian Codegraph @

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

raw
1 # Author: Horst Hunger
2 # Created: 2010-07-05
3
4 source include/have_partition.inc;
5 source include/have_innodb.inc;
6
7 let $engine_table= MYISAM;
8 let $engine_part= InnoDB;
9 let $engine_subpart= InnoDB;
10
11 use test;
12
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
36 # 5) Exchanges with different engines.
37 error ER_MIX_HANDLER_ERROR;
38 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
39 error ER_MIX_HANDLER_ERROR;
40 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
41
42 source suite/parts/inc/part_exch_drop_tabs.inc;
43