mysql-test/suite/roles/drop_current_user-5176.test
raw| 1 | # |
| 2 | # MDEV-5176 Server crashes in fill_schema_applicable_roles on select from APPLICABLE_ROLES after a suicide |
| 3 | # |
| 4 | --source include/not_embedded.inc |
| 5 | |
| 6 | create user foo@localhost; |
| 7 | grant create user on *.* to foo@localhost; |
| 8 | --connect (foo,localhost,foo,,) |
| 9 | drop user foo@localhost; |
| 10 | select * from information_schema.applicable_roles; |
| 11 | --error ER_NONEXISTING_GRANT |
| 12 | show grants; |
| 13 | select current_user(); |
| 14 |