文档首页 > > 错误码参考> GAUSS-01401 -- GAUSS-01500> GAUSS-01431 -- GAUSS-01440

GAUSS-01431 -- GAUSS-01440

分享
更新时间: 2020/03/25 GMT+08:00

GAUSS-01431: "operator class '%s' for access method '%s' already exists"

SQLSTATE: 42710

错误原因:CREATE OPERATOR CLASS,定义的operator class已经存在。

解决办法:CREATE OPERATOR CLASS,定义的operator class须与已有的operator class不同名。

GAUSS-01432: "could not make operator class '%s' be default for type %s"

SQLSTATE: 42710

错误原因:CREATE OPERATOR CLASS,使用关键字为数据类型创建默认的OPERATOR CLASS时,发现该数据类型已有默认的OPERATOR CLASS。

解决办法:CREATE OPERATOR CLASS,使用关键字为数据类型创建默认的OPERATOR CLASS时,首先确认该数据类型没有默认的OPERATOR CLASS。

GAUSS-01433: "must be system admin to create an operator family"

SQLSTATE: 42501

错误原因:CREATE OPERATOR FAMILY,使用的帐户不是系统管理员帐户。

解决办法:CREATE OPERATOR FAMILY,须得以系统管理员帐户。

GAUSS-01434: "must be system admin to alter an operator family"

SQLSTATE: 42501

错误原因:ALTER OPERATOR FAMILY ... ADD/DROP,使用的帐户不是系统管理员帐户。

解决办法:ALTER OPERATOR FAMILY ... ADD/DROP,使用的帐户须得是系统管理员帐户。

GAUSS-01435: "operator argument types must be specified in ALTER OPERATOR FAMILY"

SQLSTATE: 42601

错误原因:ALTER OPERATOR FAMILY ... ADD OPERATOR,没有指定OPERATOR的参数类型。

解决办法:ALTER OPERATOR FAMILY ... ADD OPERATOR,须得指定OPERATOR的参数类型。

GAUSS-01436: "STORAGE cannot be specified in ALTER OPERATOR FAMILY"

SQLSTATE: 42601

错误原因:ALTER OPERATOR FAMILY ... ADD中指定了STORAGE子句。

解决办法:ALTER OPERATOR FAMILY ... ADD中不能指定STORAGE子句。

GAUSS-01437: "one or two argument types must be specified"

SQLSTATE: 42601

错误原因:CREATE OPERATOR CLASS、ALTER OPERATOR FAMILY ... ADD/DROP中指定的OPERATOR/FUNCTION参数超过了2个。

解决办法:CREATE OPERATOR CLASS、ALTER OPERATOR FAMILY ... ADD/DROP中指定的OPERATOR/FUNCTION参数只能是1个或者2个。

GAUSS-01438: "index operators must be binary"

SQLSTATE: 42P17

错误原因:CREATE OPERATOR CLASS、ALTER OPERATOR FAMILY ... ADD指定的OPERATOR不是二元操作符。

解决办法:CREATE OPERATOR CLASS、ALTER OPERATOR FAMILY ... ADD指定的OPERATOR须得是二元操作符。

GAUSS-01439: "access method '%s' does not support ordering operators"

SQLSTATE: 42P17

错误原因:CREATE OPERATOR CLASS、ALTER OPERATOR FAMILY ... ADD,指定了sort operator,但是access_method不支持排序。

解决办法:CREATE OPERATOR CLASS、ALTER OPERATOR FAMILY ... ADD,只有access_method支持排序操作符时,指定的OPERATOR才可以FOR ORDER,否则只能FOR SEARCH。

GAUSS-01440: "index search operators must return boolean"

SQLSTATE: 42P17

错误原因:CREATE OPERATOR CLASS、ALTER OPERATOR FAMILY ... ADD OPERATOR…FOR SEARCH,但是该操作符的返回值不是BOOL类型。

解决办法:CREATE OPERATOR CLASS、ALTER OPERATOR FAMILY ... ADD OPERATOR…FOR SEARCH,则操作符的返回值必须是BOOL类型。

分享:

    相关文档

    相关产品

文档是否有解决您的问题?

提交成功!

非常感谢您的反馈,我们会继续努力做到更好!

反馈提交失败,请稍后再试!

*必选

请至少选择或填写一项反馈信息

字符长度不能超过200

提交反馈 取消

如您有其它疑问,您也可以通过华为云社区问答频道来与我们联系探讨

智能客服提问云社区提问