Bug #3425

Delete + Inner Join

Details

Request #3425	Delete + Inner Join
Submitted	2005-02-10 16:19 UTC
From	sylfradev at yahoo dot fr
Status	Suspended
Package	DB_DataObject
PHP Version	4.3.3
OS	Windows 200
Roadmaps	(Not assigned)

Comments

[2005-02-10 16:19 UTC] sylfradev at yahoo dot fr

Description:
------------
When you add joins with joinAdd, they are not used in DELETE queries, whereas they work with SELECT queries

Expected result:
----------------
This should produce a query like that :
DELETE FROM X USING X INNER JOIN Y ON X.a=Y.a
whereas it gives :
DELETE FROM X

So I have to use :
$factory->query("DELETE FROM ". $factory->tableName()
. " USING " . $factory->tableName()
. " " . $factory->_join
. " " . $factory->_query['condition']);