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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot