ObjectDB ObjectDB

Possible issue for JPQL "LEFT [OUTER] JOIN"

#1

Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN".

 

Thanks.

edit
delete
#2

Thank you for this report. Please try build 2.3.7_18 that should fix this issue.

ObjectDB Support
edit
delete
#3

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.
 

edit
delete
#4

You are right. Please try build 2.3.7_20 that should cover this case as well.

ObjectDB Support
edit
delete

Reply

To post on this website please sign in.