[BUGFIX] Typo3DBQueryParser fails to wrap subselect in braces

When the Typo3DBQueryParser converts Extbase queries to Doctrine queries, it creates subselects for certain relation constraints. It fails to wrap the subselect in braces for has-many relations which leads to sql exceptions. This patch introduces braces around those subselects. Change-Id: Ie9721a01bf166391770c7a1471272af0e15f9ccb Fixes: #81240 Releases: master, 8.7 Reviewed-on: https://review.typo3.org/52847 Tested-by: TYPO3com <no-reply@typo3.com> Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch> Tested-by: Christian Kuhn <lolli@schwarzbu.ch>

[BUGFIX] Typo3DBQueryParser fails to wrap subselect in braces
When the Typo3DBQueryParser converts Extbase queries to Doctrine queries, it creates subselects for certain relation constraints. It fails to wrap the subselect in braces for has-many relations which leads to sql exceptions. This patch introduces braces around those subselects. Change-Id: Ie9721a01bf166391770c7a1471272af0e15f9ccb Fixes: #81240 Releases: master, 8.7 Reviewed-on: https://review.typo3.org/52847 Tested-by: TYPO3com <no-reply@typo3.com> Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch> Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
843a5d58 · Thomas Maroschik · Christian Kuhn · a819b117 · 843a5d58
Commit 843a5d58 authored 7 years ago by Thomas Maroschik Committed by Christian Kuhn 7 years ago
--- a/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php
+++ b/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php
@@ -359,7 +359,7 @@ class Typo3DbQueryParser
                        // Add it to the main query
                        return $this->queryBuilder->expr()->eq(
                            $tableName . '.uid',
-                            $queryBuilderForSubselect->getSQL()
+                            '(' . $queryBuilderForSubselect->getSQL() . ')'
                        );
                    } else {
                        return $this->queryBuilder->expr()->inSet(