[TYPO3-ttnews] broken sort with mysql 5.0.50

[stefano cecere]

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!

ciao
stefano


Georg Rehfeld wrote:
> 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