bernard created DERBY-5728:
------------------------------
Summary: Add Support for NULL IS NULL
Key: DERBY-5728
URL: https://issues.apache.org/jira/browse/DERBY-5728
Project: Derby
Issue Type: Improvement
Components: SQL
Affects Versions: 10.8.2.2
Environment: Windows XP
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)
Reporter: bernard
Priority: Critical
Attachments: NullParameterEclipseLinkDerbyMaven.zip
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
http://en.wikipedia.org/wiki/Java_Persistence_Query_Language#Examples
Part of this has already been resolved by issue "Add support for
setObject(<arg>, null)"
https://issues.apache.org/jira/browse/DERBY-1938
I am attaching an EclipseLink test case for verification.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
