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

GAUSS-00271 -- GAUSS-00280

GAUSS-00271: "cannot use aggregate function in VALUES"

SQLSTATE: 42803

Description: The VALUES clause in the INSERT statement uses an aggregate function.

Solution: Ensure that the syntax of the VALUES clause in the INSERT statement does not contain aggregate functions. If aggregate functions are contained, modify the INSERT statement based on its syntax.

GAUSS-00272: "cannot use window function in VALUES"

SQLSTATE: 42P20

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00273: "INSERT has more expressions than target columns"

SQLSTATE: 42601

Description: The number of valid expressions or values in the INSERT statement is greater than the corresponding number of target columns.

Solution: Ensure that the number of valid expressions or values in the INSERT statement is consistent with the corresponding number of target columns.

GAUSS-00274: "INSERT has more target columns than expressions"

SQLSTATE: 42601

Description: The number of target columns in the INSERT statement is greater than the corresponding number of valid expressions or values.

Solution: Ensure that the number of target columns in the INSERT statement is consistent with the corresponding number of valid expressions or values. If they are inconsistent, modify the INSERT statement.

GAUSS-00275: "SELECT ... INTO is not allowed here"

SQLSTATE: 42601

Description: The syntax is incorrectly parsed. Specifically, the SELECT statement contains the INTO clause, which is not supported.

Solution: Modify the SELECT statement to ensure that it does not contain the INTO clause.

GAUSS-00276: "DEFAULT can only appear in a VALUES list within INSERT"

SQLSTATE: 42601

Description: The syntax is incorrectly parsed. Specifically, the SELECT statement contains the default expression or value, which is allowed only in the INSERT statement.

Solution: Ensure that the syntax of the SELECT statement is correct.

GAUSS-00277: "SELECT FOR UPDATE/SHARE cannot be applied to VALUES"

SQLSTATE: 0A000

Description: The expression or value in the SELECT statement contains the SELECT FOR UPDATE/SHARE clause, which is not supported.

Solution: Ensure that the SELECT statement is correct.

GAUSS-00278: "SELECT FOR UPDATE/SHARE is not allowed with UNION/INTERSECT/EXCEPT"

SQLSTATE: 0A000

Description: The clause collection (UNION/INTERSECT/EXCEPT) in the SELECT statement contains the SELECT FOR UPDATE/SHARE clause, which is not supported.

Solution: Ensure that the SELECT statement is correct.

GAUSS-00279: "invalid UNION/INTERSECT/EXCEPT ORDER BY clause"

SQLSTATE: 0A000

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00280: "INTO is only allowed on first SELECT of UNION/INTERSECT/EXCEPT"

SQLSTATE: 42601

Description: The syntax is incorrectly parsed. The position of the INTO clause in the SELECT..UNION/INTERSECT/EXCEPT statement is incorrect.

Solution: Ensure that the INTO clause exists only in the SELECT..UNION/INTERSECT/EXCEPT statement, but does not exist in the second SELECT clause of the SELECT..UNION/INTERSECT/EXCEPT..SELECT statement.