[TYPO3-project-4-3] fe_group SQL-statement, question out of curiosity
Xavier Perseguers
typo3 at perseguers.ch
Sat Jun 13 16:57:20 CEST 2009
Hi,
> I'd like to know why actually the SQL statement for group-enableFields
> contains
> this condition this way:
>
> getMultipleGroupsWhereClause() :=
>
> AND (pages.fe_group='' OR pages.fe_group IS NULL OR pages.fe_group='0' OR
> (pages.fe_group LIKE '%,0,%' OR pages.fe_group LIKE '0,%' OR
> pages.fe_group LIKE
> '%,0' OR pages.fe_group='0') OR (pages.fe_group LIKE '%,-1,%' OR
> pages.fe_group
> LIKE '-1,%' OR pages.fe_group LIKE '%,-1' OR pages.fe_group='-1'))
>
> Is there a deeper reason, like an SQL-compatibility issue? Because this
> can be a
> single condition (per group to check for) with 'FIND_IN_SET' and 'FIELD':
DBAL is part of core and it enables another DBMS than MySQL. For
instance Postgres or Oracle...
--
Xavier Perseguers
http://xavier.perseguers.ch/en
One contribution a day keeps the fork away
More information about the TYPO3-project-4-3
mailing list