diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2020-06-04 12:12:49 +0300 |
|---|---|---|
| committer | Aleksey Midenkov <midenok@gmail.com> | 2020-06-04 12:12:49 +0300 |
| commit | 05693cf2149f8792863a32325090e789015286fc (patch) | |
| tree | 588679ac84156ba829a6804e82a9188550d2361e /mysql-test/suite/versioning/r | |
| parent | 8300f639a14afeb379c224e10dab9d99d31cecbd (diff) | |
| download | mariadb-git-05693cf2149f8792863a32325090e789015286fc.tar.gz | |
MDEV-22112 Assertion `tab_part_info->part_type == RANGE_PARTITION || tab_part_info->part_type == LIST_PARTITION' failed in prep_alter_part_table
Incorrect syntax for SYSTEM_TIME partition. work_part_info is detected
as HASH partition. We cannot add partition of different type neither
we cannot reorganize SYSTEM_TIME into/from different type
partitioning.
The sidefix for version until 10.5 corrects the message:
"For LIST partitions each partition must be defined"
Diffstat (limited to 'mysql-test/suite/versioning/r')
| -rw-r--r-- | mysql-test/suite/versioning/r/partition.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/r/partition.result b/mysql-test/suite/versioning/r/partition.result index ab206db1213..a89053369a7 100644 --- a/mysql-test/suite/versioning/r/partition.result +++ b/mysql-test/suite/versioning/r/partition.result @@ -673,4 +673,14 @@ delete from v1; ERROR HY000: Table 't1' was locked with a READ lock and can't be updated drop view v1; drop table t1; +# +# MDEV-22112 Assertion `tab_part_info->part_type == RANGE_PARTITION || tab_part_info->part_type == LIST_PARTITION' failed in prep_alter_part_table +# +create table t1 (a int) with system versioning partition by system_time; +ERROR HY000: For SYSTEM_TIME partitions each partition must be defined +create table t1 (a int) with system versioning partition by system_time +(partition p1 history, partition pn current); +alter table t1 add partition (partition p2); +ERROR HY000: Wrong partitioning type, expected type: `SYSTEM_TIME` +drop table t1; # End of 10.3 tests |