Help Center> Data Warehouse Service> Error Code Reference> Tenant Plane Error Code Reference> GAUSS-00101 -- GAUSS-00200> GAUSS-00191 -- GAUSS-00200
View PDF

GAUSS-00191 -- GAUSS-00200

GAUSS-00191: "recursive query '%s' column %d has collation '%s' in non-recursive term but collation '%s' overall"

SQLSTATE: 42P21

Description: The character set of the column in the recursive query is inconsistent with that of the column in the non-recursive query.

Solution: Convert the output character set of the non-recursive query to that of the recursive query.

GAUSS-00192: "WITH query '%s' has %d columns available but %d columns specified"

SQLSTATE: 42P10

Description: The number of parameters specified in the recursive query is inconsistent with the number of parameters required for the actual query.

Solution: Ensure that the number of parameters specified in the recursive query is consistent with the number of parameters required for the actual query.

GAUSS-00193: "mutual recursion between WITH items is not implemented"

SQLSTATE: 0A000

Description: Recursion between queries is not implemented.

Solution: Use a supported function.

GAUSS-00194: "recursive query '%s' must not contain data-modifying statements"

SQLSTATE: 42P19

Description: The recursive query contains non-query statements.

Solution: Ensure that the recursive query contains only query statements.

GAUSS-00195: "recursive query '%s' does not have the form non-recursive-term UNION [ALL] recursive-term"

SQLSTATE: 42P19

Description: No union is used between queries of a recursive query statement.

Solution: Use union between queries of a recursive query statement.

GAUSS-00196: "missing recursive reference"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00197: "ORDER BY in a recursive query is not implemented"

SQLSTATE: 0A000

Description: order by is used in the recursive query.

Solution: Do not use order by in the recursive query.

GAUSS-00198: "OFFSET in a recursive query is not implemented"

SQLSTATE: 0A000

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00199: "LIMIT in a recursive query is not implemented"

SQLSTATE: 0A000

Description: limit is used in the recursive query.

Solution: Do not use limit in the recursive query.

GAUSS-00200: "FOR UPDATE/SHARE in a recursive query is not implemented"

SQLSTATE: 0A000

Description: FOR UPDATE/SHARE is used in the recursive query.

Solution: Do not use FOR UPDATE/SHARE in the recursive query.