Here it is: select floor(avg(selection.bandwidth))*8000 as avgbandwidth from (select avg(bandwidth) as bandwidth from FEEDBACK_DOWNLOADS where servername= ? and ( bytesdownloaded > 500000 or timeduration > 3000 ) group by id order by starttime desc limit 20) as selection;
This complex (?) query makes mySQL crash everytime. If I replace the inner 'select avg(bandwidth)' by 'select *' it works fine. I am pretty sure this is not related to my table. You could create any table and try a query like that on it... If you can t reproduce the bug, I can give the details of my table. Shall I file a bug for this one ? (MySQL 4.1) Irwin Boutboul Advanced Internet Technology 150 Kettletown Road, B2-N06 Southbury, CT 06488 Phone: 203-486-5614