[TYPO3-core] RFC #16508: Bug: tcaTree is not compatible DBAL due to mySQL specific use of CONCAT

[Steffen Ritter]

Hey list,
This is an SVN patch request.

Type: Bug

Bugtracker references:
http://bugs.typo3.org/view.php?id=16508

Branches:
trunk

Problem:
as already discussed in 0016336, the Usage of concat with more than 2 
parameters only is supported by MySQL.
Fix it, to make the Tree Available with other DBMSs, too.

Solution:
cite Xavier:
IND_IN_SET should be used whenever you want to search for (typically for 
us) an id stored in a comma-separated list
we have native support for MySQL, efficient support for MSSQL and 
PostgreSQL and fallback but still OK support for Oracle
FIND_IN_SET(<search>, <list>) > 0
There's already a few calls in core for FIND_IN_SET (not many). Point is 
to add "> 0" at the end for best DBAL support even if it is optional in 
MySQL

Notes:
this patch expects 16510 to be applied.

regards
Steffen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: rfc16508.patch
Type: text/x-diff
Size: 1832 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20101123/e0ec6f32/attachment.patch>