Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.5

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


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 44 + 46 = ?

 
 [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']);

Comments

 [2005-02-24 09:45 UTC] alan_k
I'm open to patches..
 [2009-10-13 05:47 UTC] alan_k (Alan Knowles)
-Status: Verified +Status: Suspended
needs patch