Opened 13 years ago

Closed 13 years ago

#1562 closed defect (fixed)

Automatic use of join aliases in HQL doesn't work for fetch joins

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: minor Milestone: BASE 2.16.2
Component: core Version:
Keywords: Cc:

Description

The automatic expanding was needed due to a change in Hibernate 3.5 (see #1364). The issue was fixed in [5261], but the fix doesn't work for fetch joins. The reason is that a fetch join would be written as

SELECT smp FROM SampleData smp 
LEFT JOIN FETCH bioWell.bioPlate alj1

and the regular expression we use doesn't know about the FETCH keyword. This is most likely not a commonly encountered problem. I noticed it while working with a list page for bioplate events (#1536) and it can probably be worked around by manually coding the correct join.

Change History (4)

comment:1 by Nicklas Nordborg, 13 years ago

Owner: changed from everyone to Nicklas Nordborg
Status: newassigned

comment:2 by Nicklas Nordborg, 13 years ago

Resolution: fixed
Status: assignedclosed

(In [5524]) Fixes #1562: Automatic use of join aliases in HQL doesn't work for fetch joins

comment:3 by Nicklas Nordborg, 13 years ago

Milestone: BASE 2.17BASE 2.16.2
Resolution: fixed
Status: closedreopened

This issue is conflicting with #1571 so I'll move this to 2.16.2 and will also merge back changes to the trunk immediately so I can solve the conflicts with this fresh in my mind.

comment:4 by Nicklas Nordborg, 13 years ago

Resolution: fixed
Status: reopenedclosed

(In [5546]) Fixes #1562: Automatic use of join aliases in HQL doesn't work for fetch joins

Applied the fix to 2.16-stable branch.

Note: See TracTickets for help on using tickets.