[TYPO3-core] RFC: Bug #11903: Use separate tables for tags in the caching framework

[Xavier Perseguers]

Hi Masi,

>>>> For the SQL Server (and Oracle) I haven't found a way to get the job
>>>> done in a single (nested)
>>>> statement. So have to use two statements:
>>>>
>>>> DELETE FROM table2
>>>>  WHERE id IN
>>>>   (SELECT table1.id
>>>>    FROM table1 JOIN table2 ON (table1.id=table2.id)
>>>>    WHERE table1.column1=value)
>>>> DELETE FROM table1
>>>>  WHERE table1.column1=value
>>> If both tables have a key (which they do for our use cases) then on
>>> Oracle this might work:
>>>
>>> DELETE FROM
>>>  (SELECT table1.id, table2.id
>>>    FROM table1 JOIN table2 ON (table1.id=table2.id)
>>>    WHERE table1.column1=value)
>>>
>>> Maybe DELETEmultipleTablesQuery() won't fly, but there is a chance for
>>> DELETEqueryTwoTables().
>> Tested the latest statement (with single DELETE) on Oracle: does only
>> delete items from table1, not from table2.
> 
> Maybe with "SELECT *"?

Does not help :-/

-- 
Xavier Perseguers
MVC ExtJS Leader

http://forge.typo3.org/projects/show/extension-mvc_extjs