Bug #36877 main.max_heap_table_size_basic_32 fails on some systems
Submitted: 22 May 2008 8:44 Modified: 25 Jun 13:09
Reporter: Konstantin Osipov
Status: Closed
Category:Server: Tests Severity:S1 (Critical)
Version:6.0 OS:Microsoft Windows (64 bit)
Assigned to: Jon Olav Hauglid Target Version:6.0
Tags: disabled
Triage: Triaged: D3 (Medium) / R2 (Low) / E2 (Low)

[22 May 2008 8: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@
bodhi.none-20080521215149&name=test_n_mix&plat=vm-win2003-64-b

Suggested fix:
This test is apparently system-dependent.
[25 Jun 12: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 8: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 9: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)