Updated on 2023-12-22 GMT+08:00

GAUSS-00231 -- GAUSS-00240

GAUSS-00231: "get_matching_location: no matching sortgroupref"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00232: "operator %s is not a valid ordering operator"

SQLSTATE: 42809

Description: The operator specified using order by is an invalid sequencing operator.

Solution: When using order by to specify an operator, use only > or < for sequencing.

GAUSS-00233: "unrecognized sortby_dir: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00234: "unrecognized sortby_nulls: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00235: "window frame with value offset is not implemented"

SQLSTATE: 0A000

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00236: "aggregate function calls cannot be nested"

SQLSTATE: 42803

Description: The aggregate function is invoked in nested mode.

Solution: Ensure that the aggregate function is not invoked in nested mode in the statement. Modify the nested structure of the aggregate function.

GAUSS-00237: "aggregate function calls cannot contain window function calls"

SQLSTATE: 42803

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00238: "cache lookup failed for aggregate %u"

SQLSTATE: 22P06

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00239: "window function calls cannot be nested"

SQLSTATE: 42P20

Description: The aggregate function is invoked in nested mode.

Solution: Cancel the nested invoking of the window function.

GAUSS-00240: "aggregates not allowed in WHERE clause"

SQLSTATE: 42803

Description: The WHERE clause uses the aggregate function.

Solution: Do not use the aggregate function in the WHERE clause.