Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11069

main.information_schema test fails if hostname includes 'user'

    Details

      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/'
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              hhorak Honza Horak
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: