#56499SqlParser: Subselect in WHERE not suported
Description
Hello TYPO3 team,
updating the extension list after deleting “1.extensions.xml.gz” and “1.mirrors.xml.gz” results in a catchable fatal error:
> PHP Catchable Fatal Error: Argument 1 passed to TYPO3\CMS\Dbal\Database\DatabaseConnection::_quoteWhereClause() must be an array, string given, called in typo3/sysext/dbal/Classes/Database/DatabaseConnection.php on line 1214 and defined in typo3/sysext/dbal/Classes/Database/DatabaseConnection.php line 1702
After some investigation I found out that the error is triggered by the following part:
integer_version=(SELECT MAX("integer_version") FROM "tx_extensionmanager_domain_model_extension" "b" WHERE "b"."repository" = 1 AND "a"."extension_key" = "b"."extension_key") AND repository=1
in typo3/sysext/core/Classes/Database/SqlParser.php in line 1210.
The used regex does not support any subselect in WHERE clause, so the following parse error is triggered:
> No operator, but parsing not finished in parseWhereClause()
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.