Debian Codegraph @

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

raw
1 # Author: Horst Hunger
2 # Created: 2010-07-15
3
4 source include/have_innodb.inc;
5 source include/have_partition.inc;
6
7 let $engine_table= InnoDB;
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 # 21) Foreign Key.
16 # Exchange of partition with table differing in structure.
17 CREATE TABLE t_11 (a INT, b VARCHAR(55),
18 FOREIGN KEY (a) REFERENCES t_10 (a) ON DELETE CASCADE)
19 ENGINE= InnoDB;
20 #--error ER_TABLES_DIFFERENT_METADATA
21 error ER_PARTITION_EXCHANGE_FOREIGN_KEY;
22 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_11;
23 DROP TABLE t_11;
24 source suite/parts/inc/part_exch_drop_tabs.inc;
25