Updated on 2024-03-15 GMT+08:00

GAUSS-01441 -- GAUSS-01450

GAUSS-01441: "btree comparison procedures must have two arguments"

SQLSTATE: 42P17

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, the value of access_method uses the B-tree structure, and the specified function is a B-tree comparison function, but the number of parameters is not two.

Solution: Correct number of parameters to two.

GAUSS-01442: "btree comparison procedures must return integer"

SQLSTATE: 42P17

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, the value of access_method is of the B-tree structure, and the specified function is a B-tree comparison function, but the type of the returned value is not int.

Solution: Correct the type of the returned value to int.

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

SQLSTATE: 42P17

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, the value of access_method is of the B-tree structure, and the specified function is a B-tree sort support function, but the type of the returned value is not internal.

Solution: Correct the type of the returned value to internal.

GAUSS-01444: "btree sort support procedures must return void"

SQLSTATE: 42P17

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, the value of access_method is of the B-tree structure, and the specified function is a B-tree sort support function, but the type of the returned value is the void.

Solution: Correct the type of the returned value to void.

GAUSS-01445: "hash procedures must have one argument"

SQLSTATE: 42P17

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, the value of access_method is hash, but the number of parameters is not one.

Solution: Correct the number of parameters to one.

GAUSS-01446: "hash procedures must return integer"

SQLSTATE: 42P17

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, the value of access_method is hash, but the returned value type is not int.

Solution: Correct the returned value type to int.

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

SQLSTATE: 42P17

Description: In CREATE OPERATOR CLASS, the value of FOR TYPE data_type is invalid. The values of ALTER OPERATOR FAMILY and ADD OPERATOR are not specified.

Solution: Specify a valid value for data_type and ensure that both ALTER OPERATOR FAMILY and ADD OPERATOR are specified.

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

SQLSTATE: 42P17

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, the same function occurs multiple times.

Solution: During execution of the CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP procedure, ensure that no duplicate functions occur in an SQL statement.

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

SQLSTATE: 42P17

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, the same operator occurs multiple times.

Solution: During execution of the CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP procedure, ensure that no duplicate operator occurs in an SQL statement.

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

SQLSTATE: 42710

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, an operator to be added already exists.

Solution: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP, ensure that the operator to be added does not exist in the operator family.