Bug #50331 Four tests in sys_vars failed on Solaris and Windows.
Submitted: 14 Jan 2010 14:20 Modified: 21 Jan 2010 18:28
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:mysql-6.0-codebase OS:Windows (and Solaris with gcc)
Assigned to: Horst Hunger CPU Architecture:Any

[14 Jan 2010 14:20] Horst Hunger 
Description:
The following tests failed in 6.0-codebase on Solaris with gcc and Windows:
 
sys_vars.join_buffer_size_basic_32
sys_vars.query_cache_size_basic_32
sys_vars.thread_stack_basic
sys_vars.transaction_prealloc_size_basic_32

The values expected by the tests have been changed in the server on the mentioned platforms. 

How to repeat:
Run sys_vars on the mentioned systems.

Suggested fix:
Check and update of the result files and try to make the tests more robust against changes of the values.
[15 Jan 2010 8:13] John Embretsen 
These tests are failing similarly on debian platforms in daily-6.0-codebase as well.

A related bug report for some (non-Pushbuild) failures in sys_vars test suite on Solaris 32-bit (Sun Studio compiler) is Bug#50330:

sys_vars.sql_select_limit_basic
sys_vars.max_join_size_basic
sys_vars.sql_max_join_size_basic
[18 Jan 2010 9:26] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/97214

3832 Horst.Hunger	2010-01-18
      Fix for bug#50331: Result files has been repleaced and one test (thread_stack_basic), which now has the same results on all platforms ("--replace result" not more needed).
[18 Jan 2010 14:48] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/97264

3832 Horst.Hunger	2010-01-18
      Reviewed Fix for bug#50331: The properties of the result file have been changed (no "x"). The same tests have been disabled as in next-mr. The results files stay as they are due to containinf better results with the warnings about changed values.
[18 Jan 2010 15:02] Guilhem Bichot 
approved with minor comments sent by mail
[18 Jan 2010 15:23] Horst Hunger 
pushed into 6.0-codebase-bugfixing.
[19 Jan 2010 9:53] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/97337

3833 Horst.Hunger	2010-01-19
      3rd fix for bug#50331: To remove the "replace_result" was not the right way to get the expected result on all platforms. Instead the value being replaced needs to be changed from 196608 to 199680.
[21 Jan 2010 8:37] Bugs System 
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100121083501-but9pj2g3zmu10md) (version source revid:alik@sun.com-20100119194323-gcog2uiox2b7wsln) (merge vers: 6.0.14-alpha) (pib:16)
[21 Jan 2010 18:28] Paul DuBois 
Changes to test cases. No changelog entry needed.