[SQL] Right joins are generating invalid SQL

Bug #653206 reported by Luis Fernando Planella Gonzalez
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Querydsl
Fix Released
High
Unassigned

Bug Description

I have a very simple test model with Person and Department, where person has a FK to department.

These are the Q-types:
        QPerson p = QPerson.person;
        QDepartment d = QDepartment.department;

Both
    List<Object[]> list = DB.from(p).rightJoin(p.departmentIdFk, d).list(p.id, d.id);
And
    List<Object[]> list = DB.from(d).rightJoin(p).on(p.departmentId.eq(d.id)).list(p.id, d.id);
Generates:
select person.id, department.id
from person person, department department
on person.department_id = department.id

Revision history for this message
Timo Westkämper (timo-westkamper) wrote :

Thanks for the bug report. Fixed in SVN trunk.

Changed in querydsl:
status: New → Fix Committed
importance: Undecided → High
Revision history for this message
Timo Westkämper (timo-westkamper) wrote :

Released in 2.0.1

Changed in querydsl:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.