search

jlaine / qdjango

QDjango, a Qt-based C++ web framework
GNU Lesser General Public License v2.1
266 stars 96 forks source link

Bad compiled delete query with inner join for PostrgeSql #58

Open Sanych33 opened 6 years ago

Sanych33 commented 6 years ago

When I add a join to the delete operation (like a "table1___column") for postgreSql, an wrong result query is generated. Like this 

DELETE FROM "Table0"
 INNER JOIN "Table1" ON "Table0"."fk" = "Table1"."pk"
 WHERE "Table1"."column" = "something"

Correct query fo this operation like this

DELETE FROM "Table0"
      USING "Table1"
 WHERE "Table0"."fk" = "Table1"."pk" AND "Table1"."column" = "something"
jlaine commented 6 years ago

Would you consider submitting a pull request?