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'.