[TYPO3-core] RFC #12071: t3lib_sqlparser is not able to parse alias of a joined table

Xavier Perseguers typo3 at perseguers.ch
Wed Sep 30 23:42:26 CEST 2009


Hi,

> Thanks to Ries who tested my patch against a PostgreSQL TYPO3 install, 
> we found out that the table alias was not properly quoted (whenever a 
> database needs quotes around table names).
> 
> Please find enclosed v3 of the patch. I hope having a feedback that it 
> works.
> 
> There was a related change in DBAL to properly quote the table name. The 
> corresponding patch has already been committed to DBAL trunk in 
> changeset #24890 [1].
> 
> Regards
> 
> Sidenote: you may test that the patch does not crash a standard 
> *MySQL-based* TYPO3 install by simply installing DBAL without 
> configuring any external database. This will force the use of the 
> integrated Core SQL parser even for MySQL database.

Just to make a statement here, waiting for some feedback from users and of course some core dev. I successfully use this patch on a mixed MySQL + MSSQL TYPO3 website.

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away


More information about the TYPO3-team-core mailing list