Updated on 2025-06-07 GMT+08:00

U0400014: GaussDB does not support the same partition key of child and parent partitions

Description

Database Type and Version

  • Source database type and version: MySQL 5.5, 5.6, 5.7, and 8.0
  • Target database type and version: GaussDB Centralized 3.1 and earlier

Syntax Example

If the partition keys of the level-1 and level-2 partitions are the same, UGO does not convert the partition keys by default, and this error is reported.

For example, same partition keys of the level-1 and level-2 partitions are not supported in GaussDB Centralized V2.0-3.1 and earlier:

CREATE TABLE subpartition_test (
    id INT,
    purchased DATE
) PARTITION BY RANGE( purchased )
    SUBPARTITION BY HASH( purchased ) (
        PARTITION p0 VALUES LESS THAN ('1990-01-01') (
            SUBPARTITION p0_a,
            SUBPARTITION p0_b
        ),
        PARTITION p1 VALUES LESS THAN ('2000-01-01') (
            SUBPARTITION p1_a,
            SUBPARTITION p1_b
        )
);

Suggestion

Modify The partition keys of the child partition and the parent partition are the same.