Debian Codegraph @

mysql-test/suite/parts/t/partition_exchange_blackhole.test

raw
1 --source include/have_blackhole.inc
2 --source include/have_partition.inc
3 --source include/have_debug_sync.inc
4
5 let $engine= 'Blackhole';
6 --echo # Blackhole has not implemented check_if_incompatible_data,
7 --echo # so it cannot support EXCHANGE PARTITION
8 CREATE TABLE t (a int, b varchar(55)) ENGINE = 'Blackhole';
9 CREATE TABLE tp (a int, b varchar(55)) ENGINE = 'Blackhole'
10 PARTITION BY RANGE (a)
11 (PARTITION p0 VALUES LESS THAN (100),
12 PARTITION p1 VALUES LESS THAN MAXVALUE);
13 --error ER_TABLES_DIFFERENT_METADATA
14 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t;
15 DROP TABLE t, tp;
16
17 # to use when check_if_incompatible_data is implemented in ha_blackhole
18 #--source suite/parts/inc/partition_exchange.inc