华为云首页 用户手册

数据仓库服务 GAUSSDB(DWS)-GAUSS-00551 -- GAUSS-00560:GAUSS-00551: "could not determine which collation to use for view column '%s'"

数据仓库服务 GAUSSDB(DWS)-GAUSS-00551 -- GAUSS-00560:GAUSS-00551: "could not determine which collation to use for view column '%s'"

时间：2023-12-11 09:47:18
数据仓库服务 GAUSSDB(DWS)

GAUSS-00551: "could not determine which collation to use for view column '%s'"

SQLSTATE: 42P22

错误原因：对于视图的列无法决策使用哪种排序规则。

解决办法：使用COLLATE子句指定排序规则。

示例：

1
2
3
 
CREATE VIEW v1 as select t1.a || t2.a from t1,t2;
ERROR:  could not determine which collation to use for view column "?column?"
HINT:  Use the COLLATE clause to set the collation explicitly.
support.huaweicloud.com/errorcode-dws/dws_08_0063.html