[
https://issues.apache.org/jira/browse/DERBY-5629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13215566#comment-13215566
]
Knut Anders Hatlen commented on DERBY-5629:
-------------------------------------------
According to SQL:2003, part 2, section 8.7 <null predicate>, the null predicate
takes a <row value predicand>. As far as I can see, <row value predicand>
doesn't allow untyped NULL. (It has to be a <contextually typed row value
expression> to allow that.)
So it looks like accepting "values null is null" would be an extension of the
standard. The portable way to write that query is "values cast(null as integer)
is null" to explicitly state the type of the null value. Or just "values
true"... :)
> Queries with guarded null Parameter fail
> ----------------------------------------
>
> Key: DERBY-5629
> URL: https://issues.apache.org/jira/browse/DERBY-5629
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.8.2.2
> Environment: java version "1.6.0_30"
> Java(TM) SE Runtime Environment (build 1.6.0_30-b12)
> Java HotSpot(TM) Client VM (build 20.5-b03, mixed mode, sharing)
> Reporter: Bernard
> Attachments: NullParameterHibernateDerbyMaven.zip
>
>
> Some test cases in the attached Maven project fail where a null parameter is
> passed in or a null value is coded in the query.
> In the context of this issue, a recently closed issue appears to be relevant:
> "Add support for setObject(<arg>, null)"
> https://issues.apache.org/jira/browse/DERBY-1938
> Some test cases in the attached project are Hibernate JPQL cases where
> Hibernate takes care of generating the SQL queries.
> I thought it was appropriate to make a few cases not only one so that the
> issue gets a little more test coverage.
> I also assume that issue DERBY-1938 aims to fix what we can see in these
> cases.
> This has become a major issue because it causes failure of a minimalistic
> JPQL query as shown at
> http://en.wikipedia.org/wiki/Java_Persistence_Query_Language#Examples
> that shows a JPQL query:
> SELECT a FROM Author a WHERE :lastName IS NULL OR LOWER(a.lastName) =
> :lastName
--
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
