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 a partitioned table is to be created, the partition key value specified using PARTATION BY RANGE (partition_key)(range_partition_definition_list) cannot be null.

Solution: When a partitioned table is to be created, check whether the partition key value specified using PARTATION 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 a partitioned table is to be created, the partition key value specified using PARTATION BY RANGE (partition_key)(range_partition_definition_list) is not measurable.

Solution: When a partitioned table is to be created, a partition key value is specified using PARTATION BY RANGE (partition_key)(range_partition_definition_list). Ensure that the specified value is a measurable constant or a 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.