[TYPO3-core] Popular stdWrap issue
Helmut Hummel
helmut.hummel at typo3.org
Wed Jul 18 21:45:49 CEST 2012
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
More information about the TYPO3-team-core
mailing list