[SQL] Right joins are generating invalid SQL

Bug #653206 reported by Luis Fernando Planella Gonzalez on 2010-10-01
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

Thanks for the bug report. Fixed in SVN trunk.

Changed in querydsl:
status: New → Fix Committed
importance: Undecided → High

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  Edit
Everyone can see this information.

Other bug subscribers