Sort order not working

I’ve confirmed this bug on 5.0.51a-community-nt and added a reduced test case at MySQL.com. For details, see this bug report:

http://bugs.mysql.com/bug.php?id=35181

We’re downgrading our live MySQL servers tonight.

I was going to do it ... thank you for that!

It looks like they finally fixed this nasty bug in version 5.0.67: http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0-67.html

In the big list under "bugs fixed" you’ll find:

Under certain conditions, the presence of a GROUP BY clause could cause an ORDER BY clause to be ignored. (Bug#32202)

Under certain conditions, the presence of a GROUP BY clause could cause an ORDER BY clause to be ignored. (Bug#32202)

LOL ... like "when it occurred ever" ...