Re: Cannot pass null in Parameter in Query for ISNULL

Bernard,

This from Tom

http://archives.postgresql.org/pgsql-jdbc/2011-12/msg00007.php

Suggests that this is not a simple problem. Can you send me the unit
tests though.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca



On Sat, Apr 21, 2012 at 8:57 PM, Bernard <bht237@gmail.com> wrote:
> Hi,
>
> We have a driver issue with postgresl that doesn't exist with other
> databases.
>
> It happens with Java JPA implementations when a very simple query is
> executed like:
>
> SELECT a FROM Author a WHERE :lastName IS NULL OR LOWER(a.lastName) =
> :lastName
>
> See
> http://en.wikipedia.org/wiki/Java_Persistence_Query_Language#Examples
>
> :lastName is a parameter, and the null check is on the parameter so
> there shouldn't be a problem with this at all.
>
> Maciek has suggested a solution for this driver issue at
> http://archives.postgresql.org/pgsql-jdbc/2011-12/msg00017.php
>
> I wonder when this could be resolved? Apparently there is a related
> back-end issue.
>
> I have a few JUnit test for this so please ask.
>
> Kind Regards,
>
> Bernard
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc