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

GAUSS-00411 -- GAUSS-00420

GAUSS-00411: "function %s does not exist"

SQLSTATE: 42883

Description: The function %s does not exist.

Solution: Ensure that the required function has been defined.

GAUSS-00412: "%s(*) must be used to call a parameterless aggregate function"

SQLSTATE: 42809

Description: When a function or expression is created as an aggregate function, the parameter of this function is empty but not an asterisk (*).

Solution: When a function or expression is created as an aggregate function, ensure that the parameter of this function is an asterisk (*) if it is empty.

GAUSS-00413: "aggregates cannot return sets"

SQLSTATE: 42P13

Description: When a function or expression is created as an aggregate function, this function returns a set type.

Solution: Check whether the function returns a set type when the function or expression is created as an aggregate function. If it does, change the type to a non-set type.

GAUSS-00414: "aggregates cannot use named arguments"

SQLSTATE: 0A000

Description: When you call a function or expression as an aggregate function, the aggregate function uses a parameter name.

Solution: When you call a function or expression as an aggregate function, assign a valid value to this aggregate function.

GAUSS-00415: "window function call requires an OVER clause"

SQLSTATE: 42809

Description: When you call a function or expression as a window function, an OVER clause has not been defined.

Solution: Define an OVER clause when you call a function or expression as a window function.

GAUSS-00416: "DISTINCT is not implemented for window functions"

SQLSTATE: 0A000

Description: When you call a function or expression as a window function, the window function contains a DISTINCT clause.

Solution: When you call a function or expression as a window function, check whether this function contains a DISTINCT clause. If it does, delete this clause and check the syntax of this function.

GAUSS-00417: "aggregate ORDER BY is not implemented for window functions"

SQLSTATE: 0A000

Description: When you call a function or expression as a window function, this function contains an ORDER BY clause.

Solution: When you call a function or expression as a window function, check whether this function contains an ORDER BY clause. If it does, delete this clause and check the syntax of this function.

GAUSS-00418: "window functions cannot return sets"

SQLSTATE: 42P13

Description: When a function or expression is created as a window function, the window function returns a set type.

Solution: Check whether the function returns a set type when the function or expression is created as a window function. If it does, change the type to a non-set type.

GAUSS-00419: "window functions cannot use named arguments"

SQLSTATE: 0A000

Description: When you call a function or expression as a window function, the aggregate function uses a parameter name.

Solution: When you call a function or expression as a window function, assign a valid value to this window function.

GAUSS-00420: "not enough default arguments"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.