[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