Bug #11512 "sp" test failure - wrong result order
Submitted: 22 Jun 2005 16:30 Modified: 14 Jul 2005 15:40
Reporter: Lenz Grimmer Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.8-pre OS:Linux (SUSE Linux 9.3/x86)
Assigned to: Per-Erik Martin CPU Architecture:Any

[22 Jun 2005 16:30] Lenz Grimmer 
Description:
A current 5.0 tree, built with BUILD/compile-dist on SUSE 9.3/x86 with gcc 3.3.5 fails in the "sp" test with the following diff:

-------------------------------------------------------
*** r/sp.result 2005-06-22 09:59:42.000000000 +0300
--- r/sp.reject 2005-06-22 19:26:50.000000000 +0300
***************
*** 1936,1943 ****
  select * from t3 where match (title,body) against (param1)|
  call bug3734('database')|
  id    title   body
- 5     MySQL vs. YourSQL       In the following database comparison ...
  1     MySQL Tutorial  DBMS stands for DataBase ...
  call bug3734('Security')|
  id    title   body
  6     MySQL Security  When configured properly, MySQL ...
--- 1936,1943 ----
  select * from t3 where match (title,body) against (param1)|
  call bug3734('database')|
  id    title   body
  1     MySQL Tutorial  DBMS stands for DataBase ...
+ 5     MySQL vs. YourSQL       In the following database comparison ...
  call bug3734('Security')|
  id    title   body
  6     MySQL Security  When configured properly, MySQL ...
-------------------------------------------------------

This build was based on this last ChangeSet:

ChangeSet@1.1986, 2005-06-22 13:33:53+03:00, marko@hundin.mysql.fi
  Merge marko@bk-internal.mysql.com:/home/bk/mysql-5.0
  into hundin.mysql.fi:/home/marko/mysql-5.0-current

How to repeat:
Compile using BUILD/compile-dist on SUSE 9.3, observe the failure.
[14 Jul 2005 15:40] Lenz Grimmer 
It's no longer reproducable with the current 5.0 tree - please disregard. Thanks!