Debian Codegraph @

mysql-test/suite/parts/r/partition_exch_qa_15.result

raw
1 use test;
2 CREATE TABLE t_11 (a INT, b VARCHAR(55),
3 FOREIGN KEY (a) REFERENCES t_10 (a) ON DELETE CASCADE)
4 ENGINE= InnoDB;
5 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_11;
6 ERROR HY000: Table to exchange with partition has foreign key references: 't_11'
7 DROP TABLE IF EXISTS t_11;
8 DROP TABLE IF EXISTS t_10;
9 DROP TABLE IF EXISTS t_100;
10 DROP TABLE IF EXISTS t_1000;
11 DROP TABLE IF EXISTS tp;
12 DROP TABLE IF EXISTS tsp;
13 DROP TABLE IF EXISTS tsp_00;
14 DROP TABLE IF EXISTS tsp_01;
15 DROP TABLE IF EXISTS tsp_02;
16 DROP TABLE IF EXISTS tsp_03;
17 DROP TABLE IF EXISTS tsp_04;
18 DROP TABLE IF EXISTS t_empty;
19 DROP TABLE IF EXISTS t_null;