GAUSS-00401 -- GAUSS-00410

GAUSS-00401: "access method 'psort' does not support index expressions"

SQLSTATE: 0A000

Description: When psort is specified for the INDEX clause in the CREATE INDEX or ALTER TABLE syntax, the INDEX clause cannot contain an expression.

Solution: When psort is specified for the INDEX clause in the CREATE INDEX or ALTER TABLE syntax, check whether the INDEX clause contains an expression. If yes, change the syntax of the INDEX clause.

GAUSS-00402: "Partition key value can not be null"

SQLSTATE: 42601

Description: When you create a range partitioned table, the partition key value specified using PARTITION BY RANGE (partition_key)(range_partition_definition_list) cannot be null.

Solution: Check whether the partition key value specified using PARTITION BY RANGE (partition_key) is null. If it is, specify a valid partition key value.

GAUSS-00403: "partition key value must be const or const-evaluable expression"

SQLSTATE: 42601

Description: When you create a range partitioned table, the partition key value specified using PARTITION BY RANGE (partition_key)(range_partition_definition_list) is not measurable.

Solution: Ensure that the partition key value specified by PARTITION BY RANGE (partition_key) (range_partition_definition_list) is a measurable constant or constant expression.

GAUSS-00404: "argument name '%s' used more than once"

SQLSTATE: 42601

Description: A syntax error occurs, and the parameter name is used more than once.

Solution: Rename the parameter name that is used more than once.

GAUSS-00405: "positional argument cannot follow named argument"

SQLSTATE: 42601

Description: A syntax error occurs, and the positional parameter follows behind the named argument.

Solution: Change the position of the positional parameter and the named parameter.

GAUSS-00406: "%s(*) specified, but %s is not an aggregate function"

SQLSTATE: 42809

Description: The function %s(*) has been specified, but it is not an aggregate function.

Solution: Select a valid aggregate function.

GAUSS-00407: "DISTINCT specified, but %s is not an aggregate function"

SQLSTATE: 42809

Description: The function DISTINCT has been specified, but it is not an aggregate function.

Solution: Select a valid aggregate function.

GAUSS-00408: "ORDER BY specified, but %s is not an aggregate function"

SQLSTATE: 42809

Description: The function ORDER BY has been specified, but it is not an aggregate function.

Solution: Select a valid aggregate function.

GAUSS-00409: "OVER specified, but %s is not a window function nor an aggregate function"

SQLSTATE: 42809

Description: The function OVER has been specified, but it is not a window function or aggregate function.

Solution: Select a valid window function or aggregate function.

GAUSS-00410: "function %s is not unique"

SQLSTATE: 42725

Description: The function is not unique.

Solution: Use accurate type conversion to select a specific function.