Actions
Bug #102175
closed
MySQL dissalows using same table in a sub-query for an delete-query
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2023-10-16
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
13
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
With #102171 a sub-query has been used to define
the records to delete. However, two things has
been missed:
- To create placeholders in the sub-query, the
correct outer QueryBuilder instance needs to
be used.
- MySQL don't allow using the same table from
the delete query in a sub-query, at least not
directly.
The subquery should be moved to the proper place
and a additional subquery used to enforce the
result materliazation into a temporary table.
Updated by 
Updated by 
Updated by
Actions