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

Steffen Ritter info at rs-websystems.de
Sun Nov 28 09:48:09 CET 2010


Am 23.11.2010 12:57, schrieb 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
committed v2 tu trunk (rev 9661) - fixed the missing $ Thomas mentioned 
on commit


More information about the TYPO3-team-core mailing list