mirror of
https://github.com/MariaDB/server.git
synced 2025-08-03 17:11:34 +02:00
e3d9369774
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.
44 lines
1.2 KiB
Text
44 lines
1.2 KiB
Text
include/master-slave.inc
|
|
[connection master]
|
|
set local sql_mode="";
|
|
connection master;
|
|
DROP DATABASE IF EXISTS mysqltest1;
|
|
CREATE DATABASE mysqltest1;
|
|
CREATE USER tester IDENTIFIED BY 'test';
|
|
GRANT ALL ON mysqltest1.* TO 'tester'@'%' IDENTIFIED BY 'test';
|
|
GRANT ALL ON mysqltest1.* TO ''@'localhost%';
|
|
FLUSH PRIVILEGES;
|
|
connect m_1,localhost,tester,,mysqltest1;
|
|
connection m_1;
|
|
CREATE TABLE mysqltest1.t1 (a INT, users VARCHAR(255), PRIMARY KEY(a));
|
|
INSERT INTO mysqltest1.t1 VALUES(1,USER());
|
|
INSERT INTO mysqltest1.t1 VALUES(2,CURRENT_USER());
|
|
create procedure mysqltest1.p1()
|
|
begin
|
|
INSERT INTO mysqltest1.t1 VALUES(3,USER());
|
|
INSERT INTO mysqltest1.t1 VALUES(4,CURRENT_USER());
|
|
end|
|
|
CALL mysqltest1.p1();
|
|
connection master;
|
|
SELECT * FROM mysqltest1.t1 ORDER BY a;
|
|
a users
|
|
1 tester@localhost
|
|
2 @localhost%
|
|
3 tester@localhost
|
|
4 @localhost%
|
|
connection slave;
|
|
SELECT * FROM mysqltest1.t1 ORDER BY a;
|
|
a users
|
|
1 tester@localhost
|
|
2 @localhost%
|
|
3 tester@localhost
|
|
4 @localhost%
|
|
connection master;
|
|
disconnect m_1;
|
|
DROP DATABASE mysqltest1;
|
|
REVOKE ALL ON mysqltest1.* FROM 'tester'@'%';
|
|
REVOKE ALL ON mysqltest1.* FROM ''@'localhost%';
|
|
DROP USER tester@'%';
|
|
DROP USER ''@'localhost%';
|
|
connection slave;
|
|
include/rpl_end.inc
|