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.

Feedback
编组 3备份
    openGauss 2024-07-15 01:01:34
    cancel