Debian Codegraph @

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

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