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

main.information_schema test fails if hostname includes 'user'

    XMLWordPrintable

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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.