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

XML

Word

Printable

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

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.