Updated on 2024-03-15 GMT+08:00

GAUSS-00211 -- GAUSS-00220

GAUSS-00211: "cannot use window function in function expression in FROM"

SQLSTATE: 42P20

Description: The function expression in the FROM clause uses the window function.

Solution: Do not use the window function in the function expression of the FROM clause.

GAUSS-00212: "column name '%s' appears more than once in USING clause"

SQLSTATE: 42701

Description: When the using syntax is used for join, the same column name appears in the using syntax more than once.

Solution: Ensure that the same column name appears in the using syntax only once.

GAUSS-00213: "common column name '%s' appears more than once in left table"

SQLSTATE: 42702

Description: In the USING syntax, a column in the left table appears more than once.

Solution: Ensure that a column in the left table appears only once in the USING syntax.

GAUSS-00214: "column '%s' specified in USING clause does not exist in left table"

SQLSTATE: 42703

Description: Columns listed in the USING clause cannot be found in the left table.

Solution: Ensure that the columns listed in the USING clause must be present in both of the two tables being joined.

GAUSS-00215: "common column name '%s' appears more than once in right table"

SQLSTATE: 42702

Description: In the USING syntax, a column in the right table appears more than once.

Solution: Ensure that a column in the right table appears only once in the USING syntax.

GAUSS-00216: "column '%s' specified in USING clause does not exist in right table"

SQLSTATE: 42703

Description: When the using syntax is used for join, the corresponding column name cannot be found in the right table.

Solution: Ensure that the column name used is in the left and right tables.

GAUSS-00217: "column alias list for '%s' has too many entries"

SQLSTATE: 42601

Description: The number of columns in the object alias exceeds the actual number of columns.

Solution: Ensure that the number of columns in the object alias is consistent with the actual number of columns.

GAUSS-00218: "argument of %s must not contain variables"

SQLSTATE: 42P10

Description: A clause similar to Limit uses a variable.

Solution: Do not use a variable in a clause similar to Limit.

GAUSS-00219: "argument of %s must not contain aggregate functions"

SQLSTATE: 42803

Description: A clause similar to Limit uses an aggregate function.

Solution: Do not use an aggregate function in a clause similar to Limit.

GAUSS-00220: "argument of %s must not contain window functions"

SQLSTATE: 42P20

Description: A clause similar to Limit uses a window function.

Solution: Do not use a window function in a clause similar to Limit.