[MDEV-4629] MTR tests main.variables and some of sys_vars.* fail on 32-bit builds - JIRA

Details

Type: Bug
Status: Closed
Priority: Critical
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 5.5.32
Component/s: None
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-----------------------#'

Gliffy Diagrams

Attachments

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Michael Widenius added a comment - 2013-06-11 13:51

Fixed and pushed the test cases into 5.5

Show

Michael Widenius added a comment - 2013-06-11 13:51 Fixed and pushed the test cases into 5.5

Hide

Permalink

Elena Stepanova added a comment - 2013-06-12 04:13

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;

Show

Elena Stepanova added a comment - 2013-06-12 04:13 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;

People

Assignee:

Michael Widenius

Reporter:

Elena Stepanova

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Created:

2013-06-10 09:54

Updated:

2013-06-12 04:13

Resolved:

2013-06-12 04:13

Agile

View on Board