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

[Martin Kutschker]

Xavier Perseguers schrieb:
> Hi,
> 
>>> 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 *"?

Masi