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

[Xavier Perseguers]

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?

Did not check this very case but yes, I would say "not-done" yet.

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away