Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0(EOL)
-
None
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;
|