GAUSS-00911 -- GAUSS-00920
GAUSS-00911: "constraint mismatch in ALTER TABLE EXCHANGE PARTITION"
SQLSTATE: 0A000
Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column constraints.
Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column constraints. Otherwise, the statement cannot be performed.
GAUSS-00912: "distribute mismatch for tables in ALTER TABLE EXCHANGE PARTITION"
SQLSTATE: 0A000
Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column distribution settings.
Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column distribution settings. Otherwise, the statement cannot be performed.
GAUSS-00913: "tables in ALTER TABLE EXCHANGE PARTITION must have the same number of indexs"
SQLSTATE: 0A000
Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different numbers of indexes.
Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same number of indexes. Otherwise, the statement cannot be performed.
GAUSS-00914: "index mismatch for tables in ALTER TABLE EXCHANGE PARTITION"
SQLSTATE: 0A000
Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different indexes.
Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same index. Otherwise, the statement cannot be performed.
GAUSS-00915: "some rows in table do not qualify for specified partition"
SQLSTATE: 0A000
Description: When the SPLIT PARTITION statement is executed, some rows in the tables do not meet the requirements for partition split.
Solution: Ensure that data in the tables meets the requirements for partition split.
GAUSS-00916: "the number of resulting partitions must be more than one"
SQLSTATE: 42601
Description: The number of specified partitions is less than two when one partition is split into multiple partitions.
Solution: Ensure that the number of specified partitions is no less than two.
GAUSS-00917: "the bound of the first resulting partition is too low"
SQLSTATE: 42601
Description: The border value of the first partition is small during the partition split and the SPLIT PARTITION statement fails.
Solution: Ensure that the split point for SPLIT PARTITION is correct.
GAUSS-00918: "the bound of resulting partition '%s' is too low"
SQLSTATE: 42601
Description: The border value of the partition is small during the partition split and the SPLIT PARTITION statement fails.
Solution: Ensure that the split point for SPLIT PARTITION is correct.
GAUSS-00919: "the bound of the last resulting partition is not equal with specified partition bound"
SQLSTATE: 42601
Description: The border value of the last partition is not equal to the specified border value after the SPLIT PARTITION statement is performed. The partition split fails.
Solution: Ensure that the split point for SPLIT PARTITION is correct.
GAUSS-00920: "number of boundary items NOT EQUAL to number of partition keys"
SQLSTATE: 42601
Description: The number of specified boundary items is inconsistent with that of partition keys.
Solution: Ensure that the split point for SPLIT PARTITION is correct.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.