RE: Aggregate functions in ORDER BY

lto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 11:10 PM To: Dave Pullin Cc: mysql@lists.mysql.com Subject: Re: Aggregate functions in ORDER BY Many thanks for that Dave. Do you know whether it's possible for MySQL to return fully qualified column names by default? For ex

RE: Signal 11 crashes on MySQL V5

nstable on high load insert/update/delete with kernel 2.6 (CentOS, Fedora, ...) you'll get more stability but it still not stable enough. Please see http://forums.mysql.com/read.php?22,74279,74279#msg-74279 It has been confirmed as bug on MySQL 5. Dave Pullin wrote: >I am running MySQL

RE: Aggregate functions in ORDER BY

All you are doing when you quote the expression like `COUNT(pets.pet_id)` is referencing the column in the select by its default column name (which is the same as the expression.) That's why it only works when the expression is a column. If you dont want the order by column to appear in the result

Signal 11 crashes on MySQL V5

I am running MySQL on 6 servers - 3 Linux and 3 Windows. I recently upgraded to V5 on all servers. Now MySQL is crashing regularly (several times per day, some days) with 'got signal 11'. My 3 Linux servers are very different machines running different software a uniprocessor Pentium with 512MB ru