Updated on 2024-03-15 GMT+08:00

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.