mariadb/mysql-test/suite/roles/show_create_database-10463.result
Sergei Golubchik e3d9369774 cleanup: disconnect before DROP USER
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.
2025-07-16 09:14:33 +07:00

67 lines
1.8 KiB
Text

drop database if exists db;
Warnings:
Note 1008 Can't drop database 'db'; database doesn't exist
create role r1;
create user beep@'%';
create database db;
create table db.t1 (i int);
create table db.t2 (b int);
grant select on db.* to r1;
grant r1 to beep@'%';
connect con1,localhost,beep,,;
show databases;
Database
information_schema
show create database db;
ERROR 42000: Access denied for user 'beep'@'localhost' to database 'db'
select table_schema, table_name from information_schema.tables
where table_schema = 'db' order by table_name;
table_schema table_name
set role r1;
show databases;
Database
db
information_schema
show create database db;
Database Create Database
db CREATE DATABASE `db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */
select table_schema, table_name from information_schema.tables
where table_schema = 'db' order by table_name;
table_schema table_name
db t1
db t2
connection default;
create role r2;
create user beep2@'%';
grant update on db.* to r2;
grant r2 to beep2;
connect con2,localhost,beep2,,;
show databases;
Database
information_schema
show create database db;
ERROR 42000: Access denied for user 'beep2'@'localhost' to database 'db'
select table_schema, table_name from information_schema.tables
where table_schema = 'db' order by table_name;
table_schema table_name
set role r2;
show databases;
Database
db
information_schema
show create database db;
Database Create Database
db CREATE DATABASE `db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */
select table_schema, table_name from information_schema.tables
where table_schema = 'db' order by table_name;
table_schema table_name
db t1
db t2
connection default;
disconnect con1;
disconnect con2;
drop database db;
drop role r1;
drop user beep;
drop role r2;
drop user beep2;