|
--source include/have_partition.inc
|
|
create table t (a int) partition by list(a) (partition p0 values in (1,2));
|
create table t1 (a int);
|
insert into t1 values (10);
|
alter table t convert table t1 to partition pn default;
|
drop table if exists t1, t;
|
|
10.7.8
|
query 'alter table t convert table t1 to partition pn default' failed: ER_NO_PARTITION_FOR_GIVEN_VALUE (1526): Table has no partition for value 0
|
Note that the value in the error message is also wrong, it is not related to the default-ness of the partition, see MDEV-33147.
|