Updated on 2023-12-22 GMT+08:00

GAUSS-02381 -- GAUSS-02390

GAUSS-02381: "bogus index qualification"

SQLSTATE: XX002

Description: The attribute No. of the left operand for the index expression is greater than the number of attributes for which indexes have been created.

Solution: Modify the attribute No.

GAUSS-02382: "bogus RowCompare index qualification"

SQLSTATE: XX002

Description: The attribute No. of the left operand for the index expression is greater than the number of attributes for which indexes have been created.

Solution: Modify the attribute No.

GAUSS-02383: "RowCompare index qualification contains wrong operator"

SQLSTATE: XX002

Description: The row expression contains an incorrect operator.

Solution: Check the SQL statement.

GAUSS-02384: "NullTest indexqual has wrong key"

SQLSTATE: XX002

Description: The left operand of the index expression is not a variable where an index has been created.

Solution: Check whether indexes have been created for related columns in the system catalog.

GAUSS-02385: "ScalarArrayOpExpr index qual found where not allowed"

SQLSTATE: XX002

Description: The index column contains the ANY expression. The array value needs to be extended in the executor. Index scanning and index-only scanning are not allowed.

Solution: Contact technical support.

GAUSS-02386: "can'nt initialize index scans using unusable local index '%s'"

SQLSTATE: XX000

Description: The index-only scan fails to be initialized because the index is unavailable.

Solution: Modify the index in the system catalog.

GAUSS-02388: "whole-row update is not implemented"

SQLSTATE: XX000

Description: Update of an entire column cannot be performed.

Solution: Modify the SQL statement.

GAUSS-02390: "cannot change sequence '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. The sequence cannot be modified using INSERT, UPDATE, or DELETE statement.

Solution: Modify the SQL statement.