Yes, that is exactly what I am experiencing. The result comes back, and the server dies.... So it's probably a known bug.... It s via mysqlcc. With command line it works fine in fact (good catch). I'm not familiar with the JDBC driver/mysqlcc. Does it (the JDBC) also use mysqlcc ? Or can I run safely my queries with the JDBC driver ? (or shall I test too:)
Thanks, Irwin Boutboul Advanced Internet Technology 150 Kettletown Road, B2-N06 Southbury, CT 06488 Phone: 203-486-5614 "Little, Tim" <[EMAIL PROTECTED]> 09/12/2003 01:58 PM To Irwin Boutboul/Watson/[EMAIL PROTECTED] cc Subject RE: SQL query crashes MySQL Does that crash the server in command-line mode (via mysql) or just in MySQLcc? I've seen similar crashes (actual full server crashes) in similar queries but only under mysqlcc. It seems that the results come back but the server dies just after that point. Is this what you are experiencing? Tim... -----Original Message----- From: Irwin Boutboul [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:03 PM To: [EMAIL PROTECTED] Subject: SQL query crashes MySQL 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