Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.7(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2, 11.3(EOL), 11.4
-
None
Description
--source include/have_partition.inc
|
|
create table t (a int, b int) |
partition by range (a) |
subpartition by hash(b) subpartitions 2 ( |
partition p0 values less than (100) |
);
|
create table t1 (a int, b int); |
alter table t convert table t1 to partition p2 values less than (maxvalue); |
|
# Cleanup
|
drop table if exists t, t1; |
11.4 875377ad824473774c833b1aff4346ba3133f092 |
query 'alter table t convert table t1 to partition p2 values less than (maxvalue)' failed: |
ER_PARTITION_INSTEAD_OF_SUBPARTITION (1734): Subpartitioned table, use subpartition instead of partition |
There should probably be some error, at least I don't see an obvious way to convert a table to a partition in a subpartitioned table. However, it should be more like "not applicable to subpartitioned table" or something like that.
Maybe the logic was copied from EXCHANGE PARTITION. However, there the error makes sense, because indeed, a subpartition can be replaced with a table.
Attachments
Issue Links
- is caused by
-
MDEV-22165 CONVERT TABLE: move in partition from existing table
- Closed