Chandrasekar Rajasekar (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ea9ddf...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiM2UwOGFkODJi...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-13990?atlOrigin=eyJpIjoiM2UwOG...
) HHH-13990 (
https://hibernate.atlassian.net/browse/HHH-13990?atlOrigin=eyJpIjoiM2UwOG...
) org.hibernate.QueryException occurs When Join Fetch is used on toOne relationship along
with memberOf filter on Element collection (
https://hibernate.atlassian.net/browse/HHH-13990?atlOrigin=eyJpIjoiM2UwOG...
)
Issue Type: Bug Affects Versions: 5.4.14 Assignee: Unassigned Components: hibernate-core
Created: 29/Apr/2020 13:56 PM Priority: Major Reporter: Chandrasekar Rajasekar (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ea9ddf...
)
Query exception error occurs when element collection is included in where clause along
with join fetch.
```java.lang.IllegalArgumentException: org.hibernate.QueryException: query specified join
fetching, but the owner of the fetched association was not present in the select list
[FromElement{explicit,not a collection join,fetch join,fetch non-lazy
properties,classAlias=null,role=example.Book.publisher,tableName=Publisher,tableAlias=publisher3_,origin=author
author0_,columns={book2_.publisher_id ,className=example.Publisher}}] [SELECT example_Book
FROM example.Author example_Author__fetch JOIN example_Author__fetch.books example_Book
LEFT JOIN FETCH example_Book.publisher WHERE :awards_3b62d810_0 MEMBER OF
example_Book.awards AND example_Author__fetch=:example_Author__fetch ] ```
`SELECT example_Book FROM example.Author example_Author_ fetch JOIN example_Author
fetch.books example_Book LEFT JOIN FETCH example_Book.publisher WHERE :awards_3b62d810_0
MEMBER OF example_Book.awards AND example_Author fetch=:example_Author _fetch`
Book and author has many-many relationship and book and publisher has many-one
relationship. Awards is a Element collection of type List<string>.
Some of working queries:
`SELECT example_Book FROM example.Book AS example_Book LEFT JOIN FETCH
example_Book.publisher WHERE :awards_3e8093d5_0 MEMBER OF example_Book.awards `
`SELECT example_Book FROM example.Author example_Author_ fetch JOIN example_Author
fetch.books example_Book LEFT JOIN FETCH example_Book.publisher WHERE
example_Book.publishDate > :publishDate_fd2879ac_0 AND example_Author
fetch=:example_Author _fetch`
(
https://hibernate.atlassian.net/browse/HHH-13990#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-13990#add-comment?atlOrigin=ey...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100125- sha1:e06514a )