actiontech/dble

show @@shardingNodes语法提示信息及功能有待改进

yejr opened this issue · 0 comments

yejr commented
  • dble version:
man1@[dble_information]>show @@version;
+-------------------------------------------------------------------------------+
| VERSION                                                                       |
+-------------------------------------------------------------------------------+
| 5.7.11-dble-3.22.07.0-891dd27f53e35a30166179d79d1dfadd5f2719da-20220915062343 |
+-------------------------------------------------------------------------------+
1 row in set (0.00 sec)

参考文档:https://github.com/actiontech/dble-docs-cn/blob/master/2.Function/2.1_manager_cmd/2.1.03_show.md#21340--show-shardingnodes-where-schema-and-table:

# 提示不支持的语法,还以为是不支持该功能
man1@[dble_information]>show @@shardingNodes;
ERROR 1003 (HY000): Unsupported statement

# 没加table条件,也不能正确执行
# 这时候是否可以显示 schema=testdb 下的所有表节点信息
man1@[dble_information]>show @@shardingNodes where schema=testdb;
ERROR 1105 (HY000): The Correct Query Format Is:show @@shardingnodes where schema='?' and table ='?'

另外,这里的where条件建议加上引号。