Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
yejr opened this issue Jan 11, 2023 · 0 comments
Open

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

yejr opened this issue Jan 11, 2023 · 0 comments
Labels
community issue from community

Comments

@yejr
Copy link

yejr commented Jan 11, 2023

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

@yanhuqing666 yanhuqing666 added the community issue from community label Jan 12, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
community issue from community
Projects
None yet
Development

No branches or pull requests

2 participants