GAUSS-01291 -- GAUSS-01300
GAUSS-01291: “cannot use aggregate in index predicate”
SQLSTATE: 42803
Description: Aggregate operations are performed in an expression index.
Solution: Do not use an aggregate function in an expression index.
GAUSS-01292: “functions in index predicate must be marked IMMUTABLE”
SQLSTATE: 42P17
Description: A volatile function is used in an expression index.
Solution: Do not use a volatile function in an expression index.
GAUSS-01293: “cannot use subquery in index expression”
SQLSTATE: 0A000
Description: A subquery is used in an expression index.
Solution: Do not use a subquery in an expression index.
GAUSS-01294: “cannot use aggregate function in index expression”
SQLSTATE: 42803
Description: Aggregate operations are performed in an expression index.
Solution: Do not use an aggregate function in an expression index.
GAUSS-01295: “functions in index expression must be marked IMMUTABLE”
SQLSTATE: 42P17
Description: A volatile function is used in an expression index.
Solution: Do not use a volatile function in an expression index.
GAUSS-01296: “could not determine which collation to use for index expression”
SQLSTATE: 42P22
Description: The sorting mode cannot be determined in an 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: ASC or DESC options are used to process indexes.
Solution: Rebuild the index and set the access method (amcanorder in pg_am) of the index column to true.