Bug #36878 main.tmp_table_size_basic_32 fails on some systems
Submitted: 22 May 2008 8:49 Modified: 21 Jan 17:16
Reporter: Konstantin Osipov
Status: Closed
Category:Tests Severity:S1 (Critical)
Version:6.0 OS:Any
Assigned to: Horst Hunger Target Version:6.0
Tags: test
Triage: D3 (Medium) / R2 (Low) / E2 (Low)

[22 May 2008 8: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 16: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 14: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 16: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 18:51] Patrick Crews 
Ok to push.  Nice consolidation of the test.
[9 Dec 2008 17: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 7: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 4:39] Paul DuBois 
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[19 Jan 12: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 13: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 16:44] Jon Stephens 
Setting status back to NDI pending merge to 6.0 tree.
[19 Jan 17: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 19: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 17:16] Paul DuBois 
Test case changes. No changelog entry needed.