[TYPO3-dev] strange enableFields SQL with T3 4.0

[Florian Schaeffer]

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
- oracle also supports || as concatenation operator
- postgres only supports || as operator but not CONCAT

Florian