On this page

Show all

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

GAUSS-00201 -- GAUSS-00210

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

View PDF

GAUSS-00201: "recursive reference to query '%s' must not appear more than once"

SQLSTATE: 42P19

Description: The recursive query appears more than once.

Solution: Ensure that the recursive query appears only once.

GAUSS-00202: "unrecognized join type: %d"

SQLSTATE: XX004

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00203: "unrecognized set op: %d"

SQLSTATE: XX004

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00204: "bogus InhOption value: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00205: "JOIN/ON clause refers to '%s', which is not part of JOIN"

SQLSTATE: 42P10

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00206: "subquery in FROM must have an alias"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00207: "unexpected non-SELECT command in subquery in FROM"

SQLSTATE: XX000

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00208: "subquery in FROM cannot refer to other relations of same query level"

SQLSTATE: 42P10

Description: A subquery in the FROM clause references another object with the same query level.

Solution: Ensure that the subquery in the FROM clause does not reference another object with the same query level.

GAUSS-00209: "function expression in FROM cannot refer to other relations of same query level"

SQLSTATE: 42P10

Description: The function expression in the FROM clause references another object with the same query level.

Solution: Ensure that the function expression statement in the FROM clause does not reference another object with the same query level.

GAUSS-00210: "cannot use aggregate function in function expression in FROM"

SQLSTATE: 42803

Description: The function expression in the FROM clause uses an aggregate function.

Solution: Do not use an aggregate function in the function expression in the FROM clause.

Parent topic: GAUSS-00201 -- GAUSS-00300

Previous topic: GAUSS-00201 -- GAUSS-00300

Next topic: GAUSS-00211 -- GAUSS-00220

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