[TYPO3-core] Popular stdWrap issue

[Helmut Hummel]

Hi Ernesto,

On 17.07.12 21:22, Ernesto Baschny [cron IT] wrote:

> For the record, I also think this is a bit of a "hack" to parse SQL at
> this point. But alas, it works (despite the bugs) and now covered with
> some unit tests gives us at least a better groundwork for further "fine
> tunings" if they are required.

Agreed.

> Please note that the "rowNums" problem due to wrong SQL only pops up
> with MySQL 5.0 (e.g. debian lenny), so you *won't* be able to reproduce
> the bug in MySQL 5.1 (debian squeeze).

 From my understanding it does not depend on the MySQL version but on 
the sql-mode

If MySQL runs in ONLY_FULL_GROUP_BY [1] then the problem occurs.

Maybe 5.0 and 5.1 have different default settings though.

> Test with this snippet:

Nice, thanks.

Kind regards,
Helmut

[1]http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_only_full_group_by

-- 
Helmut Hummel
Release Manager TYPO3 6.0
TYPO3 Core Developer, TYPO3 Security Team Leader

TYPO3 .... inspiring people to share!
Get involved: typo3.org