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

Granting a db level privilege to a non-existent table should not report ErrTableNotExists #29302

Closed
djshow832 opened this issue Nov 1, 2021 · 2 comments · Fixed by #29321
Closed
Assignees
Labels
severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@djshow832
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

This is introduced by #29273

1. Minimal reproduce step (Required)

mysql> drop table tmpdb.t;
Query OK, 0 rows affected (0.01 sec)

mysql> grant create temporary tables on tmpdb.tmpdb to test_user;
ERROR 1146 (42S02): Table 'tmpdb.tmpdb' doesn't exist

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

mysql> grant create temporary tables on tmpdb.t to test_user;
ERROR 1144 (42000): Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used

3. What did you see instead (Required)

mysql> grant create temporary tables on tmpdb.tmpdb to test_user;
ERROR 1146 (42S02): Table 'tmpdb.tmpdb' doesn't exist

4. What is your TiDB version? (Required)

master

@unconsolable
Copy link
Contributor

/assign

@github-actions
Copy link

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/moderate 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