[BUGFIX] Fix regression due to Doctrine DBAL refactoring 47/61847/2
authorBenni Mack <benni@typo3.org>
Fri, 27 Sep 2019 09:10:18 +0000 (11:10 +0200)
committerBenni Mack <benni@typo3.org>
Fri, 27 Sep 2019 10:07:02 +0000 (12:07 +0200)
As added in change 6ef46cab02f754d0809daf751ec3385021ab9387
see https://review.typo3.org/c/Packages/TYPO3.CMS/+/49530/, the RelationHandler
works on deleted elements ON ALL OTHER workspaces instead of
the current one, as the SQL query does a "neq", but prior did a "wsid=".

Resolves: #89291
Related: #77565
Releases: master, 9.5, 8.7
Change-Id: Ide82a779f1f4ba3daa064243361b9a370198d958
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/61847
Tested-by: TYPO3com <noreply@typo3.com>
Tested-by: Andreas Fernandez <a.fernandez@scripting-base.de>
Tested-by: Daniel Gorges <daniel.gorges@b13.com>
Tested-by: Benni Mack <benni@typo3.org>
Reviewed-by: Benjamin Franzke <bfr@qbus.de>
Reviewed-by: Andreas Fernandez <a.fernandez@scripting-base.de>
Reviewed-by: Daniel Gorges <daniel.gorges@b13.com>
Reviewed-by: Benni Mack <benni@typo3.org>
typo3/sysext/core/Classes/Database/RelationHandler.php

index f20a0b8..9acfdb0 100644 (file)
@@ -1547,7 +1547,7 @@ class RelationHandler
                         't3ver_oid',
                         $queryBuilder->createNamedParameter($chunk, Connection::PARAM_INT_ARRAY)
                     ),
-                    $queryBuilder->expr()->neq(
+                    $queryBuilder->expr()->eq(
                         't3ver_wsid',
                         $queryBuilder->createNamedParameter(
                             $this->getWorkspaceId(),