Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00201 -- GAUSS-00300/ GAUSS-00201 -- GAUSS-00210
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-00201 -- GAUSS-00210

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.