[TYPO3-ttnews] broken sort with mysql 5.0.50

[Georg Rehfeld]

Hi Stefano, all,

stefano cecere wrote:
> this "minor" bug http://bugs.typo3.org/view.php?id=7181 is not as minor 
> as it could be
> 
> everybody is updating their PHP/mysql (he new typo3 4.2 requires PHP 5.2)
> and tt_news has a problem with latest mysql, as decribed in the 
> bugtracker..
> 
> what do you think?
> could we get rid of the GROUP BY statement?

As far as I can see, GROUP BY is used in several places in tt_news.
Without trying to understand all the implications I think it wouldn't
be wise, to "get rid" of all these GROUP BY settings.

Also the bug obviously is inside some current versions of MySQL and
NOT in tt_news! Compare the bug report and especially the link to
http://lists.mysql.com/commits/37447 . Also note, that this MySQL bug
seems to be fixed already by MySQL AB staff into their repository and
will most likely show up in one of the next releases of MySQL.

"GROUP BY" combined with "ORDER BY" is allowed in any SQL dialect and
expected to work.

Modifications of tt_news could only work around that bug (if at all) in
MySQL and at the same time would introduce _strange_ dependencies!

So I conclude:

- don't modify tt_news for this issue
- down/upgrade your MySQL

best regards,
Georg
-- 
   ___   ___
  | + | |__    Georg Rehfeld      Woltmanstr. 12     20097 Hamburg
  |_|_\ |___   rehfeld at georg-rehfeld.de       +49 (40) 23 53 27 10