Bug #111798 Table access not restricted according to grants during MTR test

• Submitted: 18 Jul 2023 20:11
• Modified: 19 Jul 2023 8:38
• Reporter: Kamil Holubicki (OCA)
• Status: Verified
• Category: Tools: MTR / mysql-test-run
• Severity: S3 (Non-critical)
• Version: 8.0.33, 8.0.34
• OS: Any
• CPU Architecture: Any

[18 Jul 2023 20:11] Kamil Holubicki

Description:
The following MTR test should fail with error:
ERROR 1142 (42000): SELECT command denied to user 'u1'@'localhost' for table 't2'

but it doesn't.

--source include/count_sessions.inc

CREATE TABLE t2(c2 INT PRIMARY KEY);
insert into t2 values (21), (22), (23);

CREATE USER u1@localhost IDENTIFIED BY '';

GRANT INSERT ON test.t2 TO u1@localhost;
FLUSH PRIVILEGES;

--connect (u1_connection,localhost,u1,,test)
select * from test.t2;
--disconnect u1_connection

--connection default
DROP TABLE test.t2;
DROP USER u1@localhost;

--source include/wait_until_count_sessions.inc

How to repeat:
Run the above test using mtr suite
./mtr select_test.test --record

When steps from the above MTR test are executed from command line client, everything works as expected.

[19 Jul 2023 8:38] MySQL Verification Team

Hello Kamil Holubicki ,

Thank you for the report and feedback.

regards,
Umesh