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

Details

Type: Bug
Status: Closed (View Workflow)
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 @@

 '#------------------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

 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

 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-----------------------#'

Attachments

Activity

Ascending order - Click to sort in descending order

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

Fixed and pushed the test cases into 5.5

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

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;

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

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server