Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-02201 -- GAUSS-02300/ GAUSS-02291 -- GAUSS-02300
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-02291 -- GAUSS-02300

GAUSS-02291: "cursor '%s' has multiple FOR UPDATE/SHARE references to table '%s'"

SQLSTATE: 24000

Description: Multiple cursors are defined for the table.

Solution: Analyze the SQL statements to check whether the cursor is repeatedly defined.

GAUSS-02292: "cursor '%s' does not have a FOR UPDATE/SHARE reference to table '%s'"

SQLSTATE: 24000

Description: In SQL statements containing "current of" and "update", update/share operation syntax is not defined for the table.

Solution: Check whether update/share operation has been correctly defined for the table. Alternatively, check whether the optimizer works correctly.

GAUSS-02294: "cursor '%s' is not a simply updatable scan of table '%s'"

SQLSTATE: 24000

Description: Corresponding scan nodes cannot be found by executing query statements containing the "current of" syntax and not containing "update" syntax.

Solution: Check whether the operation syntax is correctly defined during SQL statements compiling. Alternatively, check whether the optimizer works correctly.

GAUSS-02295: "type of parameter %d (%s) does not match that when preparing the plan (%s)"

SQLSTATE: 42804

Description: The parameter type returned during execution is inconsistent with that of expressions described in the execution plan.

Solution: 1. Check whether the types of expression parameters in the SQL statements are consistent. 2. Check the executable codes. Ensure that the parameter attribute is correct.

GAUSS-02296: "no value found for parameter %d"

SQLSTATE: 42704

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02297: "LIMIT subplan failed to run backwards"

SQLSTATE: XX005

Description: The NULL message is returned in advance when reverse scanning is performed on the LIMIT lower-layer operator.

Solution: Contact technical support.

GAUSS-02298: "impossible LIMIT state: %d"

SQLSTATE: XX006

Description: The LIMIT state is incorrect.

Solution: Contact technical support.

GAUSS-02299: "OFFSET must not be negative"

SQLSTATE: 2201X

Description: The OFFSET count is an invalid negative value.

Solution: Change it to a value greater than or equal to zero.

GAUSS-02300: "LIMIT must not be negative"

SQLSTATE: 2201W

Description: The LIMIT count is an invalid negative value.

Solution: Change it to a value greater than or equal to zero.