db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bernard (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5728) Add Support for NULL IS NULL
Date Wed, 25 Apr 2012 20:40:17 GMT
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

        

Mime
View raw message