On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00201 -- GAUSS-00300/ GAUSS-00211 -- GAUSS-00220

GAUSS-00211 -- GAUSS-00220

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

View PDF

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.

Parent topic: GAUSS-00201 -- GAUSS-00300

Previous topic: GAUSS-00201 -- GAUSS-00210

Next topic: GAUSS-00221 -- GAUSS-00230

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel