Issue Feature Closed

#21688Add support for IN and EXISTS subqueries

Xavier Perseguers 11/25/09, 17:23 updated 12/27/09, 14:43

Description

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.