Bug #7270 Test failure: 'select' (using '--ps-protocol': results re-ordered)
Submitted: 14 Dec 2004 15:11 Modified: 14 Jan 2005 18:48
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-pre OS:Linux (Linux / Athlon)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[14 Dec 2004 15:11] Joerg Bruehe
Description:
Test 'select' fails for me in current 5.0, when I run the test suite with '--ps-protocol'.
In a standard run, this test passes.

This is a non-debug build: 'compile-pentium-max'.

Failure report:
-------------------------------------------------------
*** r/select.result     2004-12-10 18:05:58.000000000 +0300
--- r/select.reject     2004-12-14 13:26:14.000000000 +0300
***************
*** 1798,1803 ****
--- 1798,1804 ----
  Chicana       038203  1       39654943        39654943        39654943        39654943.0000
  select t3.companynr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 group by companynr,fld3;
  companynr     fld3    sum(price)
+ 512   skies   786542
  512   boat    786542
  512   capably 786542
  512   cupboard        786542
***************
*** 1807,1813 ****
  512   erases  786542
  512   Micronesia      786542
  512   Miles   786542
- 512   skies   786542
  select t2.companynr,count(*),min(fld3),max(fld3),sum(price),avg(price) from t2,t3 where t3.companynr >= 30 and t3.companynr <= 58 and t3.t2nr = t2.fld1 and
 1+1=2 group by t2.companynr;
  companynr     count(*)        min(fld3)       max(fld3)       sum(price)      avg(price)
  00    1       Omaha   Omaha   5987435 5987435.0000
--- 1808,1813 ----
-------------------------------------------------------

Latest changeset on my PC:
ChangeSet@1.1738, 2004-12-14 13:41:32+03:00, gluh@gluh.mysql.r18.ru
  Fix for bug #7223: information_schema: error in "views"

The error is older, as I got it already yesterday but did not yet report.

How to repeat:
Run the test suite with '--ps-protocol'.
[14 Jan 2005 18:48] Joerg Bruehe
I cannot reproduce it any more, seems to have been corrected (there were corrections for the '--ps-protocol' case).