Bug #9284 Wrong result: NULL vs. 4 in 'olap'
Submitted: 18 Mar 2005 17:31 Modified: 16 Jun 2005 13:20
Reporter: Joerg Bruehe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.3-pre OS:IBM AIX (AIX 4.3, HP-UX, Tru64)
Assigned to: CPU Architecture:Any

[18 Mar 2005 17:31] Joerg Bruehe 
Description:
Trying to build a 5.0.3 release based on ChangeSet
  1.1824.1.1 05/03/17 22:15:23 mysqldev@mysql.com +4 -0
  sp.test, sp.result:
    transactional test removed
  sp_trans.test, sp_trans.result:
    new file

-------------------------------------------------------
*** r/olap.result       Fri Mar 18 01:19:18 2005
--- r/olap.reject       Fri Mar 18 05:06:32 2005
***************
*** 377,381 ****
  2     4
  2     6
  4     4
! NULL  14
  DROP TABLE t1;
--- 377,381 ----
  2     4
  2     6
  4     4
! 4     14
  DROP TABLE t1;
-------------------------------------------------------

On most platforms, it crashes (bug#9254), but this here happens on
aix43, barney, hp3750 (32 + 64), hpita2, hpux11 (32 + 64).  All were "debug" builds.

The patch for #9254 was not yet included in this build!

How to repeat:
Build + test.
[28 May 2005 10:15] Alexander Keremidarski 
can't repeat with 
ChangeSet@1.1923, 2005-05-26 23:33:20+03:00, monty@mysql.com
[16 Jun 2005 13:20] Joerg Bruehe 
I cannot say when it disappeared, but it is definitely gone in 5.0.7:
Test "olap" passed on all platforms, and it still contains these output lines.