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

Oliver Hader oliver at typo3.org
Thu Oct 1 11:52:32 CEST 2009


FYI: Committed to SVN Trunk (rev. 6082)

I did not test with TYPO3_4-2 and TYPO3_4-1 and thus this stays pending
for the mentioned branches.

olly


Xavier Perseguers schrieb:
> 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.
> 
> [1] http://forge.typo3.org/repositories/revision/extension-dbal/24890
> (link might need a few more minutes in order to work)
-- 
Oliver Hader
TYPO3 Release Manager 4.3


More information about the TYPO3-team-core mailing list