[MDEV-11069] main.information_schema test fails if hostname includes 'user' Created: 2016-10-17  Updated: 2016-10-17  Resolved: 2016-10-17

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5.52
Fix Version/s: 5.5.54, 10.0.28, 10.1.19

Type: Bug Priority: Trivial
Reporter: Honza Horak Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Attachments: File mariadb-information-schema-test.patch    

 Description   

In case hostname includs 'user' string on the host the test is run, the test main.information_schema fails like this:

main.information_schema 'xtradb'         [ fail ]
        Test ended at 2016-10-16 23:34:40
CURRENT_TEST: main.information_schema
--- /builddir/build/BUILD/mariadb-5.5.52/mysql-test/r/information_schema.result 2016-09-12 16:54:54.000000000 +0200
+++ /builddir/build/BUILD/mariadb-5.5.52/mysql-test/r/information_schema.reject 2016-10-16 23:34:40.540644133 +0200
@@ -1001,6 +1001,34 @@
 select * from information_schema.user_privileges where grantee like '%user%'
 order by grantee;
 GRANTEE        TABLE_CATALOG   PRIVILEGE_TYPE  IS_GRANTABLE
+'root'@'hhorak-t440.usersys.redhat.com'        def     LOCK TABLES     YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     EVENT   YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     UPDATE  YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     INDEX   YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     CREATE VIEW     YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     RELOAD  YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     CREATE TEMPORARY TABLES YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     CREATE USER     YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     INSERT  YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     REFERENCES      YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     REPLICATION CLIENT      YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     DROP    YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     SUPER   YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     ALTER ROUTINE   YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     SELECT  YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     FILE    YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     REPLICATION SLAVE       YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     CREATE TABLESPACE       YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     CREATE  YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     SHOW DATABASES  YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     CREATE ROUTINE  YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     PROCESS YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     EXECUTE YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     TRIGGER YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     DELETE  YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     ALTER   YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     SHOW VIEW       YES
+'root'@'hhorak-t440.usersys.redhat.com'        def     SHUTDOWN        YES
 'user1'@'localhost'    def     USAGE   NO
 'user2'@'localhost'    def     USAGE   NO
 'user3'@'localhost'    def     USAGE   NO
mysqltest: Result length mismatch
 - saving '/builddir/build/BUILD/mariadb-5.5.52/mysql-test/var/log/main.information_schema-xtradb/' to '/builddir/build/BUILD/mariadb-5.5.52/mysql-test/var/log/main.information_schema-xtradb/'



 Comments   
Comment by Honza Horak [ 2016-10-17 ]

Proposed patch attached.

Comment by Elena Stepanova [ 2016-10-17 ]

hhorak, thanks for the report and patch.
Pushed to 5.5:
https://github.com/MariaDB/server/commit/df87be5edafb402e36e9c16aa0f00b1d5104d920

It most likely won't be in 5.5.53, but it will be in 5.5.54.

Generated at Thu Feb 08 07:47:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.