[TYPO3-dev] strange enableFields SQL with T3 4.0

[Martin Kutschker]

Florian Schaeffer schrieb:
> Hello all,
> 
> Martin Kutschker schrieb:
> 
>>>> What would a CONCAT do? The statement above tests if fe_group starts 
>>>> with -2, ends with -2 has a -2 in it or is -2.
> 
> 
>>> AND CONCAT(',', fe_group, ',') LIKE '%,2,%'
> 
> 
> As this SQL statement clearly simplifies the query and gains much more 
> performance, one have to keep in mind that CONCAT is not ANSI-SQL and 
> that e.g. Postgres doesn't about that function.
> 
> So would there be a way to handle this query via DBAL ?
> 
> - oracle, mssql and mysql know this function and use the same syntax

Does Oracle support now multiple strings in CONCAT? It used to take exactly 
2 arguments for CONCAT

> - oracle also supports || as concatenation operator
> - postgres only supports || as operator but not CONCAT

It is possible that DBAL/adoDB already support CONCAT somehow.

A possible is IMHO to use a set of stored procedures for other DBs that 
emulate the more common (and useful) Mysql functions.

Masi