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

Some MTR tests fail when run on a host named 'localhost'

    XMLWordPrintable

    Details

      Description

      Some tests fail when they are run on a host with hostname=localhost. It happens because instead of expected 4 'root' records in mysql.user the server has 3. Tests that check for that one or another way fail with mismatches.

      We can either add a check and skip such tests, or just document the limitation. Documenting is easier, but I suppose checking and skipping is cleaner and will cause less confusion later, because it's not clear at all from the test output why they fail.

      Example: main.join_cache

      --- /data/repo/git/10.0/mysql-test/r/join_cache.result	2015-02-26 02:18:30.000000000 +0300
      +++ /data/repo/git/10.0/mysql-test/r/join_cache.reject	2015-03-12 01:57:06.000000000 +0300
      @@ -5885,6 +5885,6 @@
       SELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	SIMPLE	PROFILING	ALL	NULL	NULL	NULL	NULL	NULL	Using where
      -1	SIMPLE	user	hash_ALL	NULL	#hash#$hj	1	information_schema.PROFILING.PAGE_FAULTS_MINOR	4	Using where; Using join buffer (flat, BNLH join)
      +1	SIMPLE	user	hash_ALL	NULL	#hash#$hj	1	information_schema.PROFILING.PAGE_FAULTS_MINOR	3	Using where; Using join buffer (flat, BNLH join)
       set join_cache_level=default;
       set @@optimizer_switch=@save_optimizer_switch;

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration