Help Center> Data Warehouse Service> Error Code Reference> Tenant Plane Error Code Reference> GAUSS-01201 -- GAUSS-01300> GAUSS-01291 -- GAUSS-01300
View PDF

GAUSS-01291 -- GAUSS-01300

GAUSS-01291: "cannot use aggregate in index predicate"

SQLSTATE: 42803

Description: Gather operations cannot be used in the expression index.

Solution: Ensure that no gather operation is used in the expression index.

GAUSS-01292: "functions in index predicate must be marked IMMUTABLE"

SQLSTATE: 42P17

Description: The volatile function cannot be used in the expression index.

Solution: Ensure that no volatile function is used in the expression index.

GAUSS-01293: "cannot use subquery in index expression"

SQLSTATE: 0A000

Description: The subquery cannot be used in the expression index.

Solution: Ensure that no subquery is used in the expression index.

GAUSS-01294: "cannot use aggregate function in index expression"

SQLSTATE: 42803

Description: Gather operations cannot be used in the expression index.

Solution: Ensure that no gather operation is used in the expression index.

GAUSS-01295: "functions in index expression must be marked IMMUTABLE"

SQLSTATE: 42P17

Description: A volatile function is used in the expression index.

Solution: Ensure that no volatile function is used in the expression index.

GAUSS-01296: "could not determine which collation to use for index expression"

SQLSTATE: 42P22

Description: The sorting mode cannot be determined in the expression index.

Solution: Specify the sorting mode during the creation of an expression index.

GAUSS-01297: "operator %s is not commutative"

SQLSTATE: 42809

Description: Operators are not commutative.

Solution: Use commutative operators in exclusive constraints.

GAUSS-01298: "cache lookup failed for opfamily %u"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-01299: "operator %s is not a member of operator family '%s'"

SQLSTATE: 42809

Description: The operator is not a member of an expected operator family.

Solution: Use an operator which is a member of an expected operator family.

GAUSS-01300: "access method '%s' does not support ASC/DESC options"

SQLSTATE: 0A000

Description: The ASC or DESC options cannot be used for index processing.

Solution: Column storage does not support the ASC or DESC option. Do not use the index column for customized sorting.