blob: f293bd8f96037fa9c9937080ed4a99aeee027d30 (
plain)
1
2
3
4
5
6
7
8
9
10
|
# Blackhole has not implemented check_if_incompatible_data,
# so it cannot support EXCHANGE PARTITION
CREATE TABLE t (a int, b varchar(55)) ENGINE = 'Blackhole';
CREATE TABLE tp (a int, b varchar(55)) ENGINE = 'Blackhole'
PARTITION BY RANGE (a)
(PARTITION p0 VALUES LESS THAN (100),
PARTITION p1 VALUES LESS THAN MAXVALUE);
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t;
ERROR HY000: Tables have different definitions
DROP TABLE t, tp;
|
