Re: Bug: Cannot pass null in Parameter in Query for ISNULL - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Bug: Cannot pass null in Parameter in Query for ISNULL
Date
Msg-id CA+0W9LM-MeO5V66MNLWEG0LJwTZmKhaa5_FiEU_pU9-V_Ae0yQ@mail.gmail.com
Whole thread Raw
In response to Re: Bug: Cannot pass null in Parameter in Query for ISNULL  (bht@actrix.gen.nz)
Responses Re: Bug: Cannot pass null in Parameter in Query for ISNULL  (Maciek Sakrejda <msakrejda@truviso.com>)
List pgsql-jdbc
On 1 December 2011 20:58,  <bht@actrix.gen.nz> wrote:

> I hope you are not suggesting that I
> discuss this with PostgreSQL DB engine engineers. I really can't do
> that so I will keep requesting a fix here.

Actually, that was exactly what I was suggesting. As I described in my
previous mail, it's really not something that can be handled in the
driver. You want a change to how parameters of unknown type are
handled in IS NULL expressions; that's entirely server-side, the
driver has no idea what an IS NULL expression looks like. You'll
probably want a stronger argument than "our JPA implementation doesn't
pass type information" first though.

> Would it be possible that you open a request/ticket/issue where this
> can be addressed formally? This could be on the driver side or on the
> DB engine side - as long as the outcome is a resolution.

The -jdbc list is the right place to do this for the JDBC driver, so
you're already there.
For changes to the backend, the -hackers list is the place to discuss them.
There is a -bugs list & a bug reporting form that feeds that, but
usually any in-depth discussion moves on to the appropriate list.

That said, I don't have plans to look at this further, so you'll
either need to convince someone else that it's worth working on, or
provide a patch yourself. That's the way that most things beyond
obvious bugfixes get implemented - someone scratches their own itch
and contributes the changes.

If you want more support than that, there are 3rd parties that can
provide commercial support for you - see
http://www.postgresql.org/support/professional_support/

Oliver

pgsql-jdbc by date:

Previous
From: Mikko Tiihonen
Date:
Subject: Re: Bug: Cannot pass null in Parameter in Query for ISNULL
Next
From: Oliver Jowett
Date:
Subject: Re: Bug: Cannot pass null in Parameter in Query for ISNULL