Debian Codegraph @

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;