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