Message Title

Jordan created an issue

Issue Type:	Bug
Affects Versions:	5.0.5
Assignee:	Unassigned
Components:	hibernate-core, hibernate-entitymanager
Created:	17/Dec/2015 02:46 AM
Priority:	Minor
Reporter:	Jordan

We have a query with the following parts:

 
                                                                    LEFT JOIN (reservation_detail rd INNER JOIN reservation r ON (r.id = rd.reservation_id AND r.status NOT IN :cancelled ))
    ...
    WHERE hrt.hotel_id IN :hotelIds AND ...

The second one that doesn't have any parentheses is generated properly

 
                                                                     WHERE hrt.hotel_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,...)

But the first part becomes

 
                                                                    LEFT JOIN (reservation_detail rd INNER JOIN reservation r ON (r.id = rd.reservation_id AND r.status NOT IN ?, ?, ? ))

Currently the workaround is to add the parentheses, so I'm submitting this as minor priority, but it's my understanding that the JPA implementation is supposed to add them.

Add Comment

This message was sent by Atlassian JIRA