TYPO3 Core

When trying to use EXT:crawler on an Oracle database, CLI dispatcher fails because some queries cannot be parsed in class.tx_crawler_lib.php:

$GLOBALS['TYPO3_DB']->exec_UPDATEquery(
'tx_crawler_queue',
'process_id IN (SELECT process_id FROM tx_crawler_process WHERE active=0 AND deleted=0)',
array(
'process_scheduled' => 0,
'process_id' => ''
)
);

or

$GLOBALS['TYPO3_DB']->exec_UPDATEquery(
'tx_crawler_process',
'active = 0
AND NOT EXISTS (
SELECT * FROM tx_crawler_queue
WHERE tx_crawler_queue.process_id = tx_crawler_process.process_id
AND tx_crawler_queue.exec_time = 0
)',
array(
'deleted'=>'1'
)
);

As such support for subqueries should be added :-)

(issue imported from #M12758)