mirror of
https://github.com/MariaDB/server.git
synced 2025-07-27 21:55:03 +02:00

let's always disconnect a user connection before dropping the said user. MariaDB is traditionally very tolerant to active connections of the dropped user, which isn't the case for most other databases. Let's avoid unintentionally spreading incompatible behavior and disconnect before drop. Except in cases when the test specifically tests such a behavior.
23 lines
495 B
Text
23 lines
495 B
Text
--source include/not_embedded.inc
|
|
#
|
|
# MDEV-5668 Assertion `granted_role->is_role()' fails on granting role with empty name
|
|
#
|
|
--error ER_INVALID_ROLE
|
|
grant '' to foo@localhost;
|
|
|
|
#
|
|
# MDEV-5238 Server crashes in find_role_grant_pair on SHOW GRANTS for an anonymous user
|
|
#
|
|
|
|
create user ''@localhost;
|
|
create role r1;
|
|
grant r1 to ''@localhost;
|
|
|
|
--connect (con1,localhost,nonexisting_user,,)
|
|
select current_user;
|
|
show grants;
|
|
|
|
connection default;
|
|
disconnect con1;
|
|
drop role r1;
|
|
drop user ''@localhost;
|