[TYPO3-ttnews] broken sort with mysql 5.0.50

[Christian Lerrahn]

On Sun, 10 Feb 2008 10:03:22 +0100
stefano cecere <scecere at krur.com> wrote:

> Thanks Georg
> 
> i didn't know the bug was fixed in mysql (yes i did downgrade mysql
> to previous version to fix my site)
> 
> let's find the minimun mysql 5 version with this bug fixed!

That's not really that hard, is it. If you had followed the link that
Georg posted, you would also have found a link to the bug on the bug
tracker on that page and there you will find


[19 Nov 2007 5:31] Paul DuBois

Noted in 5.0.52, 5.1.23, 6.0.4 changelogs.

Under certain conditions, the presence of a GROUP BY clause could
cause an ORDER BY clause to be ignored.


In other words, the bug has been fixed for a long time and you just
need a recent version (e.g. Gentoo x86 is already at 5.0.54).

Cheers,
Christian