Bug #36878 main.tmp_table_size_basic_32 fails on some systems
Submitted: 22 May 2008 6:49 Modified: 21 Jan 2009 16:16
Reporter: Konstantin Osipov (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:Tests Severity:S7 (Test Cases)
Version:6.0 OS:Any
Assigned to: Horst Hunger CPU Architecture:Any
Tags: test

[22 May 2008 6:49] Konstantin Osipov 
Description:
The symptoms are:
ain.tmp_table_size_basic_32   [ fail ]

--- C:/cygwin/home/pushbuild/pb1/pb/mysql-6.0-runtime/277/mysql-6.0.6-alpha-pb277/mysql-test/r/tmp_table_size_basic_32.result	2008-05-21 23:19:03.000000000 +0300
+++ C:\cygwin\home\pushbuild\pb1\pb\mysql-6.0-runtime\277\mysql-6.0.6-alpha-pb277\mysql-test\r\tmp_table_size_basic_32.reject	2008-05-22 01:20:52.978375000 +0300
@@ -122,7 +122,7 @@
 SET @@session.tmp_table_size = 12345678901;
 SELECT @@session.tmp_table_size;
 @@session.tmp_table_size
-4294967295
+12345678901
 '#------------------FN_DYNVARS_005_06-----------------------#'
 SELECT @@global.tmp_table_size = VARIABLE_VALUE 
 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 

mysqltest: Result content mismatch

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

Suggested fix:
Yet another system-dependent test.
[3 Dec 2008 15:43] 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/60505

2719 Horst Hunger	2008-12-03
      (No) fix for Bug#36878: The test has been taken out fo main and put into "sys_vars", but the opportunity to check the test has been take to improve it.
[4 Dec 2008 13:42] 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/60605

2720 Horst Hunger	2008-12-04
      fix for Bug#36878: Only one line in the result files of 32 bit and 64 bit platforms differed and made problems on 64 bit machine with 32 bit mysqld. The removal of the separation into 32 bit and 64 bit versions of that test fixes also this problem.
[5 Dec 2008 15:42] 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/60750

2720 Horst Hunger	2008-12-05
      Fix for Bug#36878 after review by Matthias: Only one line in the result files of 32 bit and 64 bit platforms differed and made problems on 64 bit machine with 32 bit mysqld. The removal of the separation into 32 bit and 64 bit versions of that test fixes also this problem.
[5 Dec 2008 17:51] Patrick Crews 
Ok to push.  Nice consolidation of the test.
[9 Dec 2008 16:13] 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/61099

2790 Horst Hunger	2008-12-09
      Merge of fix for Bug #36878 to 6.0.
[15 Jan 2009 6:34] Bugs System 
Pushed into 5.1.31 (revid:joro@sun.com-20090115053147-tx1oapthnzgvs1ro) (version source revid:azundris@mysql.com-20081230114838-cn52tu180wcrvh0h) (merge vers: 5.1.31) (pib:6)
[16 Jan 2009 3:39] Paul DuBois 
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[19 Jan 2009 11:21] Bugs System 
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090115073240-1wanl85vlvw2she1) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 12:59] Bugs System 
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 15:44] Jon Stephens 
Setting status back to NDI pending merge to 6.0 tree.
[19 Jan 2009 16:05] Bugs System 
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)
[20 Jan 2009 18:52] Bugs System 
Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version source revid:azundris@mysql.com-20081230114916-c290n83z25wkt6e4) (merge vers: 6.0.9-alpha) (pib:6)
[21 Jan 2009 16:16] Paul DuBois 
Test case changes. No changelog entry needed.