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

GAUSS-00281 -- GAUSS-00290

GAUSS-00281: "UNION/INTERSECT/EXCEPT member statement cannot refer to other relations of same query level"

SQLSTATE: 42P10

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00282: "each %s query must have the same number of columns"

SQLSTATE: 42601

Description: The syntax is incorrect.

Solution: Modify the SQL statement.

GAUSS-00283: "cannot use aggregate function in UPDATE"

SQLSTATE: 42803

Description: In the UPDATE syntax, the value in the column to be updated cannot be an aggregate function.

Solution: Ensure that the column value to be updated in the UPDATE syntax is not an aggregate function. If the column value to be updated is an aggregate function, modify the UPDATE syntax.

GAUSS-00284: "cannot use window function in UPDATE"

SQLSTATE: 42P20

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00285: "UPDATE target count mismatch --- internal error"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00286: "column '%s.%s' of relation '%s' does not exist"

SQLSTATE: 42703

Description: In the UPDATE syntax, the column name to be updated does not exist in the table.

Solution: Ensure that the column name to be updated in the UPDATE syntax is correct.

GAUSS-00287: "cannot use aggregate function in RETURNING"

SQLSTATE: 42803

Description: The RETURNING clause in the INSERT/UPDATE/DELETE syntax contains an aggregate function, which is not supported.

Solution: Ensure that the RETURNING clause in the INSERT/UPDATE/DELETE syntax is correct.

GAUSS-00288: "cannot use window function in RETURNING"

SQLSTATE: 42P20

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00289: "RETURNING cannot contain references to other relations"

SQLSTATE: 0A000

Description: The incorrect RETURNING clause in the INSERT/UPDATE/DELETE syntax references another relational table.

Solution: Delete the reference on the relational table.

GAUSS-00290: "cannot specify both SCROLL and NO SCROLL"

SQLSTATE: 42P11

Description: The slider is incorrectly defined. Specifically, the CURSOR statement contains both SCROLL and NO SCROLL options.

Solution: Ensure that the CURSOR statement contains either the SCROLL or NO SCROLL option.