Bug #102175: MySQL dissalows using same table in a sub-query for an delete-query - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #102175

closed

MySQL dissalows using same table in a sub-query for an delete-query

Added by Stefan Bürk about 1 year ago. Updated 5 months ago.

Status:

Closed

Priority:

Should have

Assignee:

Stefan Bürk

Category:

Database API (Doctrine DBAL)

Target version:

Start date:

2023-10-16

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

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.

Related issues 1 (0 open — 1 closed)

Actions

Copy link

Updated by Stefan Bürk about 1 year ago

Related to Task #102171: Speed up bin/typo3 referencindex:update added

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Patch set 5 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Patch set 6 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Patch set 7 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

Updated by Gerrit Code Review about 1 year ago

Patch set 8 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

#10

Updated by Gerrit Code Review about 1 year ago

Patch set 9 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

#11

Updated by Gerrit Code Review about 1 year ago

Patch set 10 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

#12

Updated by Gerrit Code Review about 1 year ago

Patch set 11 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81434

Actions

Copy link

#13