Skip to content

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

@djshow832

Description

@djshow832

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

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions