Bug #28015 Order By + Group by does not Sort - Mac OS x x86
Submitted: 22 Apr 2007 11:23 Modified: 22 May 2007 16:26
Reporter: Christian Horn Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.x & 5.x OS:MacOS (x86)
Assigned to: CPU Architecture:Any
Tags: GROUP BY, order by, Sort-Problem

[22 Apr 2007 11:23] Christian Horn 
Description:
Order By, does not sort the column "count(*) as `xcounter`

SQL-Statement: select count(x_field1) as `xcounter`, `xfield2` from table where id>0 group by `xfield1` order by `xcounter` desc limit 50; 

How to repeat:
SQL-Statement: select count(x_field1) as `xcounter`, `xfield2` from table where id>0 group by `xfield1` order by `xcounter` desc limit 50; 

Suggested fix:
Does not sort the resultset with `xcounter`
[22 Apr 2007 16:26] Valeriy Kravchuk 
Thank you for a problem report. Please, send a complete test case, with CREATE TABLE, some data inserted and the description of results you expected.
[22 May 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".