Category: | Bug report |
Priority: | Normal |
Status: | Assigned |
Project: | Severity: | Minor |
Resolution: | Open |
|
Component: | Reproducibility: | Always |
Assigned to: |
the SQL designer do not recognize LEFT JOIN, but worse it screw up the previously written SQL query.
Example :
In the syntax part of the designer, write :
SELECT a.c, a.d, b.e, b.f FROM tbl_a a LEFT JOIN tbl_b b ON b.a = a.a
go in the designer tab and choose to apply the changes. now go back to the syntax tab : the query has been rewritten to :
SELECT a."c", a."d", b."e", b."f" FROM "tbl_a" b INNER JOIN "a" a ON b."a" = a."a"
-> LEFT JOIN became an INNER JOIN, no more tbl_b in the query, b is not the good alias ....
best regards
1 Comment:
I'm having the same problem. The left join doesn't work. It just operates as an innerjoin.