show grants failed after drop granted role #29473
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
-- session1
create user u1;
create role r1;
grant r1 to u1;
grant create user on *.* to 'u1';
-- session2, login in with u1
set role r1;
drop role r1;
show grants;2. What did you expect to see? (Required)
MySQL u1@127.0.0.1:(none)> show grants;
+--------------------------------------+
| Grants for User |
+--------------------------------------+
| GRANT CREATE USER ON *.* TO 'u1'@'%' |
+--------------------------------------+
3. What did you see instead (Required)
MySQL u1@127.0.0.1:(none)> show grants;
(3530, '`r1`@`%` is not granted to u1@%')4. What is your TiDB version? (Required)
master, release-5.3
MySQL u1@127.0.0.1:(none)> select tidb_version()\G
***************************[ 1. row ]***************************
tidb_version() | Release Version: v5.3.0-alpha-1301-g091cd29ca
Edition: Community
Git Commit Hash: 091cd29ca37b866bfd7a1eebedbfe8e5a1c4c1f1
Git Branch: release-5.3
UTC Build Time: 2021-11-04 09:18:04
GoVersion: go1.17.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false