eclipselink icon indicating copy to clipboard operation
eclipselink copied to clipboard

SQL generation of JPQL IS EMPTY with printInnerJoinInWhereClause=false

Open Tomas-Kraus opened this issue 2 years ago • 0 comments

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.

Tomas-Kraus avatar May 27 '22 13:05 Tomas-Kraus