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

Moreno Feltscher moreno at luagsh.ch
Thu Oct 1 00:19:51 CEST 2009


Here you have my +1 by reading and testing your v3 on a Oracle environment.

Don't we have special rules of committing for DBAL?

Cheers
Moreno

On Wed, 30 Sep 2009 23:42:26 +0200, Xavier Perseguers  
<typo3 at perseguers.ch> wrote:

> 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.
>


More information about the TYPO3-team-core mailing list