GAUSS-00281 -- GAUSS-00290

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

SQLSTATE: 42P10

Description: Syntax not supported.

Solution: Modify the SQL statement.

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

SQLSTATE: 42601

Description: Syntax error.

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: Syntax 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.

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: Syntax not supported.

Solution: Modify the SQL statement.