GAUSS-01441 -- GAUSS-01450

GAUSS-01441: “btree comparison procedures must have two arguments”

SQLSTATE: 42P17

Description: In the ADD FUNCTION clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the value of access_method is B-tree, and a B-tree comparison function is specified, but the number of parameters is not two.

Solution: If a B-tree comparison function is specified, ensure that the number of parameters must be two.

GAUSS-01442: “btree comparison procedures must return integer”

SQLSTATE: 42P17

Description: In the ADD FUNCTION clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the value of access_method is B-tree, and a B-tree comparison function is specified, but the return value type is not int.

Solution: If a B-tree comparison function is specified, ensure that the return value must be of the int data type.

GAUSS-01443: “btree sort support procedures must accept type 'internal'”

SQLSTATE: 42P17

Description: In the ADD FUNCTION clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the value of access_method is B-tree, and a B-tree sort support function is specified, but the return value is not internal.

Solution: If a B-tree sort support function is specified, ensure that the return value must be of the internal type.

GAUSS-01444: “btree sort support procedures must return void”

SQLSTATE: 42P17

Description: In the ADD FUNCTION clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the value of access_method is B-tree, and a B-tree sort support function is specified, but the return value is not void.

Solution: If a B-tree sort support function is specified, ensure that the return value must be of the void type.

GAUSS-01446: “hash procedures must return integer”

SQLSTATE: 42P17

Description: In the ADD FUNCTION clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the value of access_method is hash, but the return value type is of the int type.

Solution: If access_method is a hash type, the return value type must be of the int type.

GAUSS-01447: “associated data types must be specified for index support procedure”

SQLSTATE: 42P17

Description: FOR TYPE data_type is not specified in the CREATE OPERATOR CLASS statement. Left and right parameter types are not specified in the ADD OPERATOR clause of the ALTER OPERATOR FAMILY statement.

Solution: FOR TYPE data_type must be specified. Left and right parameter types must be specified.

GAUSS-01448: “procedure number %d for (%s,%s) appears more than once”

SQLSTATE: 42P17

Description: In the ADD or DROP clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the same function appears multiple times.

Solution: Ensure that a function does not repeatedly appear in an SQL statement.

GAUSS-01449: “operator number %d for (%s,%s) appears more than once”

SQLSTATE: 42P17

Description: In the ADD or DROP clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the same operator appears multiple times.

Solution: Ensure that an operator does not repeatedly appear in an SQL statement.

GAUSS-01450: “operator %d(%s,%s) already exists in operator family '%s'”

SQLSTATE: 42710

Description: In the ADD or DROP clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the operator to be added already exists.

Solution: Ensure that the operator to be added does not exist in the operator family.