Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL)
-
None
Description
roles.create_and_grant_role w2 [ fail ]
|
Test ended at 2016-11-25 17:38:48
|
|
CURRENT_TEST: roles.create_and_grant_role
|
--- /usr/share/mysql/mysql-test/suite/roles/create_and_grant_role.result 2016-11-25 13:01:58.000000000 +0200
|
+++ /run/shm/var/2/log/create_and_grant_role.reject 2016-11-25 17:38:47.911410836 +0200
|
@@ -16,6 +16,7 @@
|
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
|
GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
|
GRANT USAGE ON *.* TO 'r1'
|
+GRANT foo TO 'root'@'localhost' WITH ADMIN OPTION
|
GRANT r1 TO 'root'@'localhost' WITH ADMIN OPTION
|
drop role r1;
|
select * from mysql.roles_mapping;
|
@@ -24,3 +25,4 @@
|
Grants for root@localhost
|
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
|
GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
|
+GRANT foo TO 'root'@'localhost' WITH ADMIN OPTION
|
|
mysqltest: Result length mismatch
|
create role 'foo '; |
select concat(user, '__'), host from mysql.user; |
select * from mysql.roles_mapping; |
drop role foo; |
select concat(user, '__'), host from mysql.user; |
select * from mysql.roles_mapping; |
--sorted_result
|
show grants;
|
|
|
-- Here we see
|
Grants for root@localhost |
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION |
GRANT foo TO 'root'@'localhost' WITH ADMIN OPTION |
The tables are cleared correctly. The problem only lies within the internal data structures. Running flush privileges will fix the problem.
Attachments
Issue Links
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
- Stalled