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

[ bug ]数据库名中有减号的库不能查询 #164

Closed
flyingonthebed opened this issue May 5, 2019 · 12 comments
Closed

[ bug ]数据库名中有减号的库不能查询 #164

flyingonthebed opened this issue May 5, 2019 · 12 comments
Labels
bug Something isn't working

Comments

@flyingonthebed
Copy link
Contributor

重现步骤

创建数据库,如:db-test-1.
在其中创建表,创建账号,分配select 权限后,在“sql 查询” 菜单中,选择数据库看不到表,1.38可以看到。

期待结果和实际结果

期待结果:

可以正常查询

实际结果:

看不到库中的表

截图

image

错误日志

image

版本信息

手工部署 1.50

@flyingonthebed
Copy link
Contributor Author

error提示代码如下
image

@LeoQuote
Copy link
Collaborator

LeoQuote commented May 5, 2019

改成 'use `{}`'.format(db_name) 应该就可以解决.

@LeoQuote LeoQuote added the bug Something isn't working label May 5, 2019
@hhyo
Copy link
Owner

hhyo commented May 5, 2019

可以把get_connection的db_name利用起来

@flyingonthebed
Copy link
Contributor Author

改成 'use `{}`'.format(db_name) 应该就可以解决.

改过了,还是报错

@flyingonthebed
Copy link
Contributor Author

image

@flyingonthebed
Copy link
Contributor Author

image
image
image

=============
改成这样了,仍然报错~~~

@flyingonthebed
Copy link
Contributor Author

image
image

是不是没得救了?除非改库包?

@LeoQuote
Copy link
Collaborator

LeoQuote commented May 5, 2019

改完之后, qcluster也需要重启。
简单改成这样就可以'use `{}`'.format(db_name)

@flyingonthebed
Copy link
Contributor Author

改完之后, qcluster也需要重启。
简单改成这样就可以'use `{}`'.format(db_name)

重启后OK了

@flyingonthebed
Copy link
Contributor Author

image

SQL上线功能也有这个问题,怎么改一下呢?

@flyingonthebed flyingonthebed reopened this May 5, 2019
@LeoQuote
Copy link
Collaborator

LeoQuote commented May 5, 2019

感谢🙏, 稍后我会在pr中新增修改方案, 你对照修改即可

@LeoQuote
Copy link
Collaborator

LeoQuote commented May 5, 2019

pr中已修改, 请对照修改, 修改完成后重启站点和qcluster即可。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants