Bug #36877 main.max_heap_table_size_basic_32 fails on some systems
Submitted: 22 May 2008 6:44 Modified: 25 Jun 2009 11:09
Reporter: Konstantin Osipov (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:6.0 OS:Windows (64 bit)
Assigned to: Jon Olav Hauglid CPU Architecture:Any
Tags: disabled

[22 May 2008 6:44] Konstantin Osipov
Description:
The symptoms are:

--- C:/cygwin/home/pushbuild/pb1/pb/mysql-6.0-runtime/277/mysql-6.0.6-alpha-pb277/mysql-test/r/max_heap_table_size_basic_32.result	2008-05-21 23:18:56.000000000 +0300
+++ C:\cygwin\home\pushbuild\pb1\pb\mysql-6.0-runtime\277\mysql-6.0.6-alpha-pb277\mysql-test\r\max_heap_table_size_basic_32.reject	2008-05-22 00:49:28.744000000 +0300
@@ -98,17 +98,17 @@
 SET @@global.max_heap_table_size = 4294967296;
 SELECT @@global.max_heap_table_size;
 @@global.max_heap_table_size
-4294966272
+4294967296
 SET @@global.max_heap_table_size = 65530.34.;
 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
 SELECT @@global.max_heap_table_size;
 @@global.max_heap_table_size
-4294966272
+4294967296
 SET @@global.max_heap_table_size = test;
 ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
 SELECT @@global.max_heap_table_size;
 @@global.max_heap_table_size
-4294966272
+4294967296
 SET @@session.max_heap_table_size = -1;
 Warnings:
 Warning	1292	Truncated incorrect max_heap_table_size value: '0'
@@ -124,19 +124,19 @@
 SET @@session.max_heap_table_size = 4294967296;
 SELECT @@session.max_heap_table_size;
 @@session.max_heap_table_size
-4294966272
+4294967296
 SET @@session.max_heap_table_size = 65530.34.;
 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
 SET @@session.max_heap_table_size = 10737418241;
 SELECT @@session.max_heap_table_size;
 @@session.max_heap_table_size
-4294966272
+10737418240
 'Bug # 34837: Errors are not coming on assigning invalid values to variable';
 SET @@session.max_heap_table_size = test;
 ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
 SELECT @@session.max_heap_table_size;
 @@session.max_heap_table_size
-4294966272
+10737418240
 '#------------------FN_DYNVARS_077_06-----------------------#'
 SELECT @@global.max_heap_table_size = VARIABLE_VALUE 
 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 

How to repeat:
https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-6.0-runtime&entry=kosipov@...

Suggested fix:
This test is apparently system-dependent.
[25 Jun 2009 10:58] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/77156

2804 Jon Olav Hauglid	2009-06-25
      Bug #36877 main.max_heap_table_size_basic_32 fails on some systems
      
      Unable to reproduce the bug using mysql-azalea-bugfixing
      on a 64 bit Windows machine using 32 bit binaries.
      
      This patch re-eables the max_heap_table_size_basic_32
      test case.
[3 Jul 2009 6:13] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090702084644-k95gd2asolvz2zpu) (version source revid:jon.hauglid@sun.com-20090625105803-wqlg5jhqk4e8iuwo) (merge vers: 5.4.4-alpha) (pib:11)
[9 Jul 2009 7:34] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090702084644-k95gd2asolvz2zpu) (version source revid:jon.hauglid@sun.com-20090625105803-wqlg5jhqk4e8iuwo) (merge vers: 5.4.4-alpha) (pib:11)