Skip to content

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

Description

@yejr
  • 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条件建议加上引号。

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    communityissue from community

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions