[MDEV-4629] MTR tests main.variables and some of sys_vars.* fail on 32-bit builds Created: 2013-06-10  Updated: 2013-06-12  Resolved: 2013-06-12

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.5.32

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: tests


 Description   

On maria/5.5, after revision 3789 (which fixed a build problem introduced by revision 3788), 32-bit server builds, but some of the tests fail:

http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-precise-x86/builds/942/steps/test/logs/stdio

main.variables
sys_vars.binlog_cache_size_basic
sys_vars.binlog_stmt_cache_size_basic
sys_vars.bulk_insert_buffer_size_basic
sys_vars.join_buffer_size_basic
sys_vars.max_binlog_cache_size_basic
sys_vars.max_binlog_stmt_cache_size_basic
sys_vars.sort_buffer_size_basic

CURRENT_TEST: main.variables
 
--- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/r/variables.result	2013-06-09 18:23:58.000000000 +0300
 
+++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/r/variables.reject	2013-06-09 22:50:54.241462001 +0300
 
@@ -1495,9 +1495,11 @@
 
 SET @old_max_binlog_cache_size = @@GLOBAL.max_binlog_cache_size;
 
 # Set the max_binlog_cache_size to size more than 4GB. 
 SET GLOBAL max_binlog_cache_size = 5 * 1024 * 1024 * 1024;
 
+Warnings:
 
+Warning	1292	Truncated incorrect max_binlog_cache_size value: '5368709120'
 
 SELECT @@GLOBAL.max_binlog_cache_size;
 
 @@GLOBAL.max_binlog_cache_size
 
-5368709120
 
+4294963200
 
 SET GLOBAL max_binlog_cache_size = @old_max_binlog_cache_size;
 
 #
 
 # Bug #37168 : Missing variable - skip_name_resolve
 

CURRENT_TEST: sys_vars.binlog_cache_size_basic
 
--- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/binlog_cache_size_basic.result	2013-06-09 18:23:55.000000000 +0300
 
+++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/binlog_cache_size_basic.reject	2013-06-09 22:53:34.941462000 +0300
 
@@ -59,7 +59,7 @@
 
 Warning	1292	Truncated incorrect binlog_cache_size value: '42949672950'
 
 SELECT @@global.binlog_cache_size;
 
 @@global.binlog_cache_size
 
-42949668864
 
+4294963200
 
 'Bug: Errors are not coming on assigning invalid values to variable'
 
 SET @@global.binlog_cache_size = ON;
 
 ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'
 

sys_vars.binlog_stmt_cache_size_basic    w1 [ fail ]
 
        Test ended at 2013-06-09 22:53:44
 

CURRENT_TEST: sys_vars.binlog_stmt_cache_size_basic
 
--- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/binlog_stmt_cache_size_basic.result	2013-06-09 18:23:55.000000000 +0300
 
+++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/binlog_stmt_cache_size_basic.reject	2013-06-09 22:53:44.061462000 +0300
 
@@ -59,7 +59,7 @@
 
 Warning	1292	Truncated incorrect binlog_stmt_cache_size value: '42949672950'
 
 SELECT @@global.binlog_stmt_cache_size;
 
 @@global.binlog_stmt_cache_size
 
-42949668864
 
+4294963200
 
 'Bug: Errors are not coming on assigning invalid values to variable'
 
 SET @@global.binlog_stmt_cache_size = ON;
 
 ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size'
 

CURRENT_TEST: sys_vars.bulk_insert_buffer_size_basic
 
--- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic.result	2013-06-09 18:23:55.000000000 +0300
 
+++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic.reject	2013-06-09 22:53:49.049462001 +0300
 
@@ -62,9 +62,11 @@
 
 429496
 
 '#------------------FN_DYNVARS_007_05-----------------------#'
 
 SET @@global.bulk_insert_buffer_size = 42949672950;
 
+Warnings:
 
+Warning	1292	Truncated incorrect bulk_insert_buffer_size value: '42949672950'
 
 SELECT @@global.bulk_insert_buffer_size;
 
 @@global.bulk_insert_buffer_size
 
-42949672950
 
+4294967295
 
 SET @@global.bulk_insert_buffer_size = -1024;
 
 Warnings:
 
 Warning	1292	Truncated incorrect bulk_insert_buffer_size value: '-1024'
 
@@ -78,9 +80,11 @@
 
 SET @@global.bulk_insert_buffer_size = 429496.10;
 
 ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
 
 SET @@session.bulk_insert_buffer_size = 42949672950;
 
+Warnings:
 
+Warning	1292	Truncated incorrect bulk_insert_buffer_size value: '42949672950'
 
 SELECT @@session.bulk_insert_buffer_size;
 
 @@session.bulk_insert_buffer_size
 
-42949672950
 
+4294967295
 
 SET @@session.bulk_insert_buffer_size = -2;
 
 Warnings:
 
 Warning	1292	Truncated incorrect bulk_insert_buffer_size value: '-2'
 

CURRENT_TEST: sys_vars.join_buffer_size_basic
 
--- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/join_buffer_size_basic.result	2013-06-09 18:23:55.000000000 +0300
 
+++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/join_buffer_size_basic.reject	2013-06-09 22:56:09.113462002 +0300
 
@@ -73,17 +73,17 @@
 
 Warning	1292	Truncated incorrect join_buffer_size value: '42949672951'
 
 SELECT @@global.join_buffer_size;
 
 @@global.join_buffer_size
 
-42949672832
 
+4294967168
 
 SET @@global.join_buffer_size = 65530.34;
 
 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
 
 SELECT @@global.join_buffer_size;
 
 @@global.join_buffer_size
 
-42949672832
 
+4294967168
 
 SET @@global.join_buffer_size = test;
 
 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
 
 SELECT @@global.join_buffer_size;
 
 @@global.join_buffer_size
 
-42949672832
 
+4294967168
 
 SET @@session.join_buffer_size = 0;
 
 Warnings:
 
 Warning	1292	Truncated incorrect join_buffer_size value: '0'
 
@@ -107,17 +107,17 @@
 
 Warning	1292	Truncated incorrect join_buffer_size value: '42949672951'
 
 SELECT @@session.join_buffer_size;
 
 @@session.join_buffer_size
 
-42949672832
 
+4294967168
 
 SET @@session.join_buffer_size = 65530.34;
 
 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
 
 SELECT @@session.join_buffer_size;
 
 @@session.join_buffer_size
 
-42949672832
 
+4294967168
 
 SET @@session.join_buffer_size = test;
 
 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
 
 SELECT @@session.join_buffer_size;
 
 @@session.join_buffer_size
 
-42949672832
 
+4294967168
 
 '#------------------FN_DYNVARS_053_06-----------------------#'
 
 SELECT @@global.join_buffer_size = VARIABLE_VALUE 
 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 

CURRENT_TEST: sys_vars.max_binlog_cache_size_basic
 
--- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.result	2013-06-09 18:23:56.000000000 +0300
 
+++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.reject	2013-06-09 22:56:57.317462001 +0300
 
@@ -1,7 +1,7 @@
 
 SET @start_value = @@global.max_binlog_cache_size;
 
 SELECT @start_value;
 
 @start_value
 
-18446744073709547520
 
+4294963200
 
 '#--------------------FN_DYNVARS_072_01------------------------#'
 
 SET @@global.max_binlog_cache_size = 5000;
 
 Warnings:
 
@@ -9,7 +9,7 @@
 
 SET @@global.max_binlog_cache_size = DEFAULT;
 
 SELECT @@global.max_binlog_cache_size;
 
 @@global.max_binlog_cache_size
 
-18446744073709547520
 
+4294963200
 
 '#---------------------FN_DYNVARS_072_02-------------------------#'
 
 SET @@global.max_binlog_cache_size = @start_value;
 
 SELECT @@global.max_binlog_cache_size = 4294967295;
 
@@ -56,12 +56,12 @@
 
 Warning	1292	Truncated incorrect max_binlog_cache_size value: '100000000000'
 
 SELECT @@global.max_binlog_cache_size;
 
 @@global.max_binlog_cache_size
 
-99999997952
 
+4294963200
 
 SET @@global.max_binlog_cache_size = 10000.01;
 
 ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
 
 SELECT @@global.max_binlog_cache_size;
 
 @@global.max_binlog_cache_size
 
-99999997952
 
+4294963200
 
 SET @@global.max_binlog_cache_size = -1024;
 
 Warnings:
 
 Warning	1292	Truncated incorrect max_binlog_cache_size value: '-1024'
 
@@ -75,9 +75,11 @@
 
 @@global.max_binlog_cache_size
 
 4096
 
 SET @@global.max_binlog_cache_size = 4294967296;
 
+Warnings:
 
+Warning	1292	Truncated incorrect max_binlog_cache_size value: '4294967296'
 
 SELECT @@global.max_binlog_cache_size;
 
 @@global.max_binlog_cache_size
 
-4294967296
 
+4294963200
 
 SET @@global.max_binlog_cache_size = 4095;
 
 Warnings:
 
 Warning	1292	Truncated incorrect max_binlog_cache_size value: '4095'
 
@@ -149,4 +151,4 @@
 
 SET @@global.max_binlog_cache_size = @start_value;
 
 SELECT @@global.max_binlog_cache_size;
 
 @@global.max_binlog_cache_size
 
-18446744073709547520
 
+4294963200
 

CURRENT_TEST: sys_vars.max_binlog_stmt_cache_size_basic
 
--- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/max_binlog_stmt_cache_size_basic.result	2013-06-09 18:23:56.000000000 +0300
 
+++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/max_binlog_stmt_cache_size_basic.reject	2013-06-09 22:57:02.581462000 +0300
 
@@ -1,7 +1,7 @@
 
 SET @start_value = @@global.max_binlog_stmt_cache_size;
 
 SELECT @start_value;
 
 @start_value
 
-18446744073709547520
 
+4294963200
 
 '#--------------------FN_DYNVARS_072_01------------------------#'
 
 SET @@global.max_binlog_stmt_cache_size = 5000;
 
 Warnings:
 
@@ -9,7 +9,7 @@
 
 SET @@global.max_binlog_stmt_cache_size = DEFAULT;
 
 SELECT @@global.max_binlog_stmt_cache_size;
 
 @@global.max_binlog_stmt_cache_size
 
-18446744073709547520
 
+4294963200
 
 '#---------------------FN_DYNVARS_072_02-------------------------#'
 
 SET @@global.max_binlog_stmt_cache_size = @start_value;
 
 SELECT @@global.max_binlog_stmt_cache_size = 4294967295;
 
@@ -56,12 +56,12 @@
 
 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '100000000000'
 
 SELECT @@global.max_binlog_stmt_cache_size;
 
 @@global.max_binlog_stmt_cache_size
 
-99999997952
 
+4294963200
 
 SET @@global.max_binlog_stmt_cache_size = 10000.01;
 
 ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size'
 
 SELECT @@global.max_binlog_stmt_cache_size;
 
 @@global.max_binlog_stmt_cache_size
 
-99999997952
 
+4294963200
 
 SET @@global.max_binlog_stmt_cache_size = -1024;
 
 Warnings:
 
 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '-1024'
 
@@ -75,9 +75,11 @@
 
 @@global.max_binlog_stmt_cache_size
 
 4096
 
 SET @@global.max_binlog_stmt_cache_size = 4294967296;
 
+Warnings:
 
+Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '4294967296'
 
 SELECT @@global.max_binlog_stmt_cache_size;
 
 @@global.max_binlog_stmt_cache_size
 
-4294967296
 
+4294963200
 
 SET @@global.max_binlog_stmt_cache_size = 4095;
 
 Warnings:
 
 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '4095'
 
@@ -149,4 +151,4 @@
 
 SET @@global.max_binlog_stmt_cache_size = @start_value;
 
 SELECT @@global.max_binlog_stmt_cache_size;
 
 @@global.max_binlog_stmt_cache_size
 
-18446744073709547520
 
+4294963200
 

CURRENT_TEST: sys_vars.sort_buffer_size_basic
 
--- /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/sort_buffer_size_basic.result	2013-06-09 18:23:56.000000000 +0300
 
+++ /usr/local/mariadb-5.5.31-linux-i686/mysql-test/suite/sys_vars/r/sort_buffer_size_basic.reject	2013-06-09 22:58:19.473461998 +0300
 
@@ -66,17 +66,17 @@
 
 SET @@global.sort_buffer_size = 4294967296;
 
 SELECT @@global.sort_buffer_size;
 
 @@global.sort_buffer_size
 
-4294967296
 
+4294967295
 
 SET @@global.sort_buffer_size = 65530.34;
 
 ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
 
 SELECT @@global.sort_buffer_size;
 
 @@global.sort_buffer_size
 
-4294967296
 
+4294967295
 
 SET @@global.sort_buffer_size = test;
 
 ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
 
 SELECT @@global.sort_buffer_size;
 
 @@global.sort_buffer_size
 
-4294967296
 
+4294967295
 
 SET @@session.sort_buffer_size = 32775;
 
 SELECT @@session.sort_buffer_size;
 
 @@session.sort_buffer_size
 
@@ -90,7 +90,7 @@
 
 SET @@session.sort_buffer_size = 4294967296;
 
 SELECT @@session.sort_buffer_size;
 
 @@session.sort_buffer_size
 
-4294967296
 
+4294967295
 
 SET @@session.sort_buffer_size = test;
 
 ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
 
 '#------------------FN_DYNVARS_151_06-----------------------#'



 Comments   
Comment by Michael Widenius [ 2013-06-11 ]

Fixed and pushed the test cases into 5.5

Comment by Elena Stepanova [ 2013-06-12 ]

Two tests still fail, I pushed the following fix into 5.5 (checked both on 32-bit and 64-bit), please modify/remove if you disagree.

=== modified file 'mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic.result'
— mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic.result 2013-06-11 10:49:43 +0000
+++ mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic.result 2013-06-12 00:43:13 +0000
@@ -64,7 +64,7 @@
SET @@global.bulk_insert_buffer_size = 42949672950;
SELECT @@global.bulk_insert_buffer_size;
@@global.bulk_insert_buffer_size
-max_binlog_cache_size
+max_bulk_insert_buffer_size
SET @@global.bulk_insert_buffer_size = -1024;
Warnings:
Warning 1292 Truncated incorrect bulk_insert_buffer_size value: '-1024'
@@ -80,7 +80,7 @@
SET @@session.bulk_insert_buffer_size = 42949672950;
SELECT @@session.bulk_insert_buffer_size;
@@session.bulk_insert_buffer_size
-max_binlog_cache_size
+max_bulk_insert_buffer_size
SET @@session.bulk_insert_buffer_size = -2;
Warnings:
Warning 1292 Truncated incorrect bulk_insert_buffer_size value: '-2'

=== modified file 'mysql-test/suite/sys_vars/t/bulk_insert_buffer_size_basic.test'
— mysql-test/suite/sys_vars/t/bulk_insert_buffer_size_basic.test 2013-06-11 10:49:43 +0000
+++ mysql-test/suite/sys_vars/t/bulk_insert_buffer_size_basic.test 2013-06-12 00:42:56 +0000
@@ -102,7 +102,7 @@
--disable_warnings
SET @@global.bulk_insert_buffer_size = 42949672950;
--enable_warnings
---replace_result 4294967295 max_bulk_insert_buffer_size 42949672950 max_binlog_cache_size
+--replace_result 4294967295 max_bulk_insert_buffer_size 42949672950 max_bulk_insert_buffer_size
SELECT @@global.bulk_insert_buffer_size;
SET @@global.bulk_insert_buffer_size = -1024;
SELECT @@global.bulk_insert_buffer_size;
@@ -117,7 +117,7 @@
--disable_warnings
SET @@session.bulk_insert_buffer_size = 42949672950;
--enable_warnings
---replace_result 4294967295 max_bulk_insert_buffer_size 42949672950 max_binlog_cache_size
+--replace_result 4294967295 max_bulk_insert_buffer_size 42949672950 max_bulk_insert_buffer_size
SELECT @@session.bulk_insert_buffer_size;
SET @@session.bulk_insert_buffer_size = -2;
SELECT @@session.bulk_insert_buffer_size;

=== modified file 'mysql-test/suite/sys_vars/t/sort_buffer_size_basic.test'
— mysql-test/suite/sys_vars/t/sort_buffer_size_basic.test 2013-06-11 10:49:43 +0000
+++ mysql-test/suite/sys_vars/t/sort_buffer_size_basic.test 2013-06-12 00:46:24 +0000
@@ -120,7 +120,7 @@
eval
SELECT @@global.sort_buffer_size;
SET @@global.sort_buffer_size = 4294967296;
---replace_result 4294967296 max_sort_buffer_size 4294967296 max_sort_buffer_size
+--replace_result 4294967296 max_sort_buffer_size 4294967295 max_sort_buffer_size
SELECT @@global.sort_buffer_size;
SET @@global.sort_buffer_size = 1024*1024;

Generated at Thu Feb 08 06:57:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.