You may have encountered a bug; one thing you could do to avoid having to
downgrade is specify the column number you wish to sort on (4th column in
your case), as in:
ORDER BY 4 DESC LIMIT 10;
Dan
On 6/22/07, Andrew Carlson <[EMAIL PROTECTED]> wrote:
I upgraded to Mysql 5.0.42 from 4.1.14 ye
I upgraded to Mysql 5.0.42 from 4.1.14 yesterday. Afterwards, a query the I
run every day to capture data on nodes that have increased backup load the
most in TSM, seems to be ignoring my "order by" statement. Here is the query
and the output:
mysql> select occupancy.node_name as NodeName,nodet
