New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Bad compiled delete query with inner join for PostrgeSql #58

Open

Sanych33 opened this issue Oct 27, 2017 · 1 comment

Sanych33 commented Oct 27, 2017

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"

The text was updated successfully, but these errors were encountered:

Owner

jlaine commented Mar 7, 2018

Would you consider submitting a pull request?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment