GBase 8a集群的 862build43版本新建用户执行union操作报错，怎么办？

Question

gbase@suse100-1:~> gccli -uu1

GBase client 8.6.2.33-R12.104165. Copyright (c) 2004-2019, GBase. All Rights Reserved.

gbase> select 1 UNION SELECT 2;
+---+
| 1 |
+---+
| 1 |
| 2 |
+---+
2 rows in set (Elapsed: 00:00:00.01)

[gbase@rh102-1 gcinstall]$ gccli -uu1

GBase client 8.6.2.43-R11.112391. Copyright (c) 2004-2020, GBase. All Rights Reserved.

gbase> select 1 UNION SELECT 2;
ERROR 1149 (42000): (GBA-02SC-1001) The query includes syntax that is not supported by the gcluster.

Answer 1

建议使用grant unmask on *.* to u1;暂时绕过。