Affects Version/s: 10.8.2.2
Fix Version/s: None
java version "1.6.0_31"
Java(TM) SE Runtime Environment (build 1.6.0_31-b05)
Java HotSpot(TM) Client VM (build 20.6-b01, mixed mode, sharing)
The following query fails:
SELECT ID FROM CUSTOMER WHERE ((NULL IS NULL) OR (NAME = NULL))
Why this is an issue?
At least two major Java ORMs, Hibernate JPA and EclipseLink JPA have isues with generating SQL for trivial JPQL queries such as:
select object(c) from Customer c where ((name: is null) or (c.name = name)
where name: is a parameter
For why this is a fundamental issue, please see a minimalistic JPQL query at
Part of this has already been resolved by issue "Add support for setObject(<arg>, null)"
Please see EclipseLink and Hibernate test cases for verification.