[TYPO3-project-4-3] fe_group SQL-statement, question out of curiosity

Niels Fröhling niels.froehling at adsignum.com
Sat Jun 13 22:23:58 CEST 2009


Xavier Perseguers wrote:
> 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...
> 

  It seems listQuery/searchQuery are not overloaded in dbal, presumably this is 
not and issue of "not-allowed", but "not-done". Correct?

  Ciao
   Niels


More information about the TYPO3-project-4-3 mailing list