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

The error message of "select * from TABLE_STORAGE_STATS" is ambiguous #36403

Closed
SunRunAway opened this issue Jul 21, 2022 · 1 comment · Fixed by #36464
Closed

The error message of "select * from TABLE_STORAGE_STATS" is ambiguous #36403

SunRunAway opened this issue Jul 21, 2022 · 1 comment · Fixed by #36464
Assignees
Labels
severity/minor sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@SunRunAway
Copy link
Contributor

SunRunAway commented Jul 21, 2022

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> select TABLE_KEYS from TABLE_STORAGE_STATS;
ERROR 1105 (HY000): Please specify the 'table_schema'

The error message Please specify the 'TABLE_SCHEMA' is ambiguous.
Suggest: Please add where clause to filter the column TABLE_SCHEMA. For example, add where TABLE_SCHEMA = 'xxx' or where 'table_schema' in ('xxx', 'yyy')

Another bite: https://asktug.com/t/topic/67621

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

@SunRunAway SunRunAway added the type/bug The issue is confirmed as a bug. label Jul 21, 2022
@SunRunAway
Copy link
Contributor Author

@bb7133 PTAL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/minor sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants