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)
# 提示不支持的语法,还以为是不支持该功能
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条件建议加上引号。