[hibernate-issues] [JIRA] (HHH-17028) Unrelated left join fails when query has multiple roots

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-17028 ( https://hibernate.atlassian.net/browse/HHH-17028?atlOrigin=eyJpIjoiOGMyZm... ) Re: Unrelated left join fails when query has multiple roots ( https://hibernate.atlassian.net/browse/HHH-17028?atlOrigin=eyJpIjoiOGMyZm... ) I’m pretty sure I recently added support for rendering cross join to Blaze-Persistence. Did you try version 1.6.9 yet? If it doesn’t work, please create a GitHub issue and I’ll try to look into it. ANSI SQL is actually what defines this isolation. Tryout the following query in e.g. PostgreSQL and you’ll see that this is not allowed: select 1 from (values(1)) t1 , (values (1)) t2 join (values (1)) t3 on t1.x = t3.x ( https://hibernate.atlassian.net/browse/HHH-17028#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17028#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#100233- sha1:06f5c37 )