Bug #52412 Variable "net_retry_count" differs on FreeBSD, making test fail
Submitted: 27 Mar 2010 21:59 Modified: 16 Nov 2018 12:12
Reporter: Joerg Bruehe Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.5.3-m3 OS:FreeBSD (6.3 + 7.0, 32 + 64 bit)
Assigned to: CPU Architecture:Any

[27 Mar 2010 21:59] Joerg Bruehe
Description:
Detected during the build of 5.5.3-m3:

On FreeBSD (and nowhere else), for the variable "net_retry_count" the value 100000 (one million) is reported, whereas everywhere else it is 10 (ten).

This results in the below difference on 32 bit platforms,
on 64 bit it is identical except for the position of the last reported difference (32 bit: start at line 184; 64 bit: start at line 176).

=====
sys_vars.net_retry_count_basic_32        [ retry-fail ]
        Test ended at YYYY-MM-DD HH:MM:SS

CURRENT_TEST: sys_vars.net_retry_count_basic_32
--- /PATH/mysql-test/suite/sys_vars/r/net_retry_count_basic_32.result
+++ /PATH/mysql-test/suite/sys_vars/r/net_retry_count_basic_32.reject
@@ -1,31 +1,31 @@
 SET @start_global_value = @@global.net_retry_count;
 SELECT @start_global_value;
 @start_global_value
-10
+1000000
 SET @start_session_value = @@session.net_retry_count;
 SELECT @start_session_value;
 @start_session_value
-10
+1000000
 '#--------------------FN_DYNVARS_111_01-------------------------#'
 SET @@global.net_retry_count = 100;
 SET @@global.net_retry_count = DEFAULT;
 SELECT @@global.net_retry_count;
 @@global.net_retry_count
-10
+1000000
 SET @@session.net_retry_count = 200;
 SET @@session.net_retry_count = DEFAULT;
 SELECT @@session.net_retry_count;
 @@session.net_retry_count
-10
+1000000
 '#--------------------FN_DYNVARS_111_02-------------------------#'
 SET @@global.net_retry_count = DEFAULT;
 SELECT @@global.net_retry_count = 10;
 @@global.net_retry_count = 10
-1
+0
 SET @@session.net_retry_count = DEFAULT;
 SELECT @@session.net_retry_count = 10;
 @@session.net_retry_count = 10
-1
+0
 '#--------------------FN_DYNVARS_111_03-------------------------#'
 SET @@global.net_retry_count = 1;
 SELECT @@global.net_retry_count;
@@ -184,8 +184,8 @@
 SET @@global.net_retry_count = @start_global_value;
 SELECT @@global.net_retry_count;
 @@global.net_retry_count
-10
+1000000
 SET @@session.net_retry_count = @start_session_value;
 SELECT @@session.net_retry_count;
 @@session.net_retry_count
-10
+1000000

mysqltest: Result content mismatch
=====

This value difference also affects test "mysqld--help-notwin", see bug#52410.

How to repeat:
Run the test suite.
[16 Nov 2018 12:12] Dyre Tjeldvoll
Posted by developer:
 
Default values for system variables are no longer set by the build system. The value is now set to 10 in sql_const.h.