Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4.5
-
None
-
Gentoo
Description
The 11.4 version is affected with sysschema.v_privileges_by_table_by_level test failure issue when the test runs in a network sendbox which contains only lo interface and hostname is to localhost. The test fails with following diff:
CURRENT_TEST: sysschema.v_privileges_by_table_by_level
|
--- /var/tmp/portage/dev-db/mariadb-11.4.5/work/mysql/mysql-test/suite/sysschema/r/v_privileges_by_table_by_level.result 2025-01-30 17:54:55.000000000 -0000
|
+++ /var/tmp/portage/dev-db/mariadb-11.4.5/work/mysql/mysql-test/suite/sysschema/r/v_privileges_by_table_by_level.reject 2025-02-05 14:59:01.522152930 -0000
|
@@ -53,18 +53,6 @@
|
test1 t1 <some-root-user> SHOW VIEW GLOBAL
|
test1 t1 <some-root-user> TRIGGER GLOBAL
|
test1 t1 <some-root-user> DELETE HISTORY GLOBAL
|
-test1 t1 <some-root-user> SELECT GLOBAL
|
-test1 t1 <some-root-user> INSERT GLOBAL
|
-test1 t1 <some-root-user> UPDATE GLOBAL
|
-test1 t1 <some-root-user> DELETE GLOBAL
|
-test1 t1 <some-root-user> CREATE GLOBAL
|
-test1 t1 <some-root-user> DROP GLOBAL
|
-test1 t1 <some-root-user> REFERENCES GLOBAL
|
-test1 t1 <some-root-user> INDEX GLOBAL
|
-test1 t1 <some-root-user> ALTER GLOBAL
|
-test1 t1 <some-root-user> SHOW VIEW GLOBAL
|
-test1 t1 <some-root-user> TRIGGER GLOBAL
|
-test1 t1 <some-root-user> DELETE HISTORY GLOBAL
|
test1 t1 'test1_user'@'%' SELECT SCHEMA
|
test1 t1 'test1_user'@'%' INSERT SCHEMA
|
test1 t1 'test1_user'@'%' UPDATE SCHEMA
|
@@ -99,18 +87,6 @@
|
test1 t1 <some-root-user> SELECT GLOBAL
|
test1 t1 <some-root-user> INSERT GLOBAL
|
test1 t1 <some-root-user> UPDATE GLOBAL
|
-test1 t1 <some-root-user> DELETE GLOBAL
|
-test1 t1 <some-root-user> CREATE GLOBAL
|
-test1 t1 <some-root-user> DROP GLOBAL
|
-test1 t1 <some-root-user> REFERENCES GLOBAL
|
-test1 t1 <some-root-user> INDEX GLOBAL
|
-test1 t1 <some-root-user> ALTER GLOBAL
|
-test1 t1 <some-root-user> SHOW VIEW GLOBAL
|
-test1 t1 <some-root-user> TRIGGER GLOBAL
|
-test1 t1 <some-root-user> DELETE HISTORY GLOBAL
|
-test1 t1 <some-root-user> SELECT GLOBAL
|
-test1 t1 <some-root-user> INSERT GLOBAL
|
-test1 t1 <some-root-user> UPDATE GLOBAL
|
test1 t1 <some-root-user> DELETE GLOBAL
|
test1 t1 <some-root-user> CREATE GLOBAL
|
test1 t1 <some-root-user> DROP GLOBAL
|
|
|
Result length mismatch
|
The test passes if the network sandbox is not used, because sys.privileges_by_table_by_level contains one more grantee, 'root'@'gentoo-4f5088c5':
SELECT grantee
|
FROM sys.privileges_by_table_by_level WHERE table_name='t1'
|
GROUP BY grantee;
|
grantee
|
'root'@'127.0.0.1'
|
'root'@'::1'
|
'root'@'gentoo-4f5088c5'
|
'root'@'localhost'
|
'test1_user'@'%'
|
The issue was introduced in commit 70de4075a18c ("MDEV-24486 Rename the view sys.table_privileges to sys.privileges_by_table_by_level")
Attachments
Issue Links
- is caused by
-
MDEV-24486 Easier way to retrieve all users that have privileges on a specific table
-
- Closed
-