> > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
> >
> > The problem that has cropped up I have is that in all GROUP BY column DESC
> > statements, the DESC is now not being recognized, and the query is being
> > returned in ascending order. If I use ORDER BY... DESC that works fine.
>
>I'm seeing the same bug on 3.23.45 (and maybe others but I can't remember
>all the versions I've played with recently). It does the same thing where
>it accepts the syntax but does not respect it (and returns rows in the
>default ASC ordering).
The problem is apparently solved if you kluge with e.g.
select field, count(field) from table group by field order by
field desc
but it IS a kluge.
AJ
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
