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 constraint.
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 setting.
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.
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.
GAUSS-00915: “some rows in table do not qualify for specified partition”
SQLSTATE: 0A000
Description: When SPLIT PARTITION is run, some rows in the tables cannot be split.
Solution: Locate the cause.
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: Partitioning failed because the first partition border value is too low.
Solution: Ensure that the SPLIT PARTITION operation is correct.
GAUSS-00918: “the bound of resulting partition '%s' is too low”
SQLSTATE: 42601
Description: Partitioning failed because the partition border value is too low.
Solution: Ensure that the SPLIT PARTITION operation is correct.
GAUSS-00919: “the bound of the last resulting partition is not equal with specified partition bound”
SQLSTATE: 42601
Description: Partitioning failed because the last border value is inconsistent with the specific one.
Solution: Ensure that the SPLIT PARTITION operation is correct.
GAUSS-00920: “number of boundary items NOT EQUAL to number of partition keys”
SQLSTATE: 42601
Description: Partition failed because the number of specified partition key attributes is inconsistent with that of original partition key attributes.
Solution: Ensure that the SPLIT PARTITION operation is correct.