Details
Minor
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;
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Sergei Golubchik, what do you think?