eclipselink
eclipselink copied to clipboard
SQL generation of JPQL IS EMPTY with printInnerJoinInWhereClause=false
Let's have 2 tables:
-
OrderHeader
- @Id long id
- @OneToMany(mappedBy = "header") List<OrderItems> orderItems
-
OrderItems
- @Id long id
- @ManyToOne OrderHeader header
and JPQL statement SELECT o FROM OrderHeader o WHERE o.orderItems IS EMPTY
Execution of this statement fails when printInnerJoinInWhereClause
is set to false
in session/DB platform.