Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN".
Thanks.
Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN".
Thanks.
Thank you for this report. Please try build 2.3.7_18 that should fix this issue.
Great and fast solution but it doesn't work with the following JPQL queries string:
- "SELECT a,b FROM A a LEFT OUTER JOIN a.listB b WHERE b IS NULL"
where the output would be [A4, null] or even throw an Exception
instead [A3, null] [A4, null]??? NULL is only for single-valued field.
- "SELECT a,b FROM A a LEFT OUTER JOIN a.listB b WHERE b.id IS NULL"
but it works fine with an relationship comparison:
"SELECT a,b FROM A a LEFT OUTER JOIN a.listB b WHERE b.a IS NULL"
By the way, it is a workaround for issue 146 ("SELECT a FROM A a WHERE a.list IS EMPTY")
Thanks.
You are right. Please try build 2.3.7_20 that should cover this case as well.