GAUSS-00271 -- GAUSS-00280
GAUSS-00271: “cannot use aggregate function in VALUES”
SQLSTATE: 42803
Description: The VALUES clause in the INSERT statement contains an aggregate function.
Solution: Ensure that the VALUES clause in the INSERT statement does not contain an aggregate function. Modify the INSERT statement based on its syntax.
GAUSS-00272: “cannot use window function in VALUES”
SQLSTATE: 42P20
Description: Syntax 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 an INTO clause, which is not supported.
Solution: Modify the SELECT statement to ensure that it does not contain an 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 not supported.
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: Syntax 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.