blob: 9bf6c8f047af7cb5bdd22e2a57ba47f4771e1a90 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
--source include/have_innodb.inc
--source include/have_partition.inc
CREATE TABLE t1(a INT, b VARCHAR(10), INDEX(a))ENGINE=InnoDB
PARTITION BY RANGE(a)
(PARTITION pa VALUES LESS THAN (3),
PARTITION pb VALUES LESS THAN (5));
--error ER_FOREIGN_KEY_ON_PARTITIONED
CREATE TABLE t2(a INT, FOREIGN KEY(a) REFERENCES t1(a))ENGINE=INNODB
PARTITION BY RANGE(a)
(PARTITION pa VALUES LESS THAN (2),
PARTITION pb VALUES LESS THAN (4));
DROP TABLE t1;
|
