Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple queries with JDBC escaped scalar functions result in exceptions - Mailing list pgsql-jdbc

From Vladimir Sitnikov
Subject Re: Simple queries with JDBC escaped scalar functions result in exceptions
Date
Msg-id CAB=Je-FeBZ0yis7OeJ7WH0cGLkDCUeZ4G0D37FxJLPij0v2KZg@mail.gmail.com
Whole thread Raw
In response to Re: Simple queries with JDBC escaped scalar functions result in exceptions  (Adam Rauch <adam@labkey.com>)
Responses Re: Simple queries with JDBC escaped scalar functions result in exceptions  (Adam Rauch <adam@labkey.com>)
Re: Simple queries with JDBC escaped scalar functions resultin exceptions  (Adam Rauch <adam@labkey.com>)
List pgsql-jdbc
Tree view
>The dollar sign ($) is the only case we came across in our test environments, but it looks like a single quote (') or double quote (") in a comment also trips up the parser. As do the two-character combinations {D, {E, {F, {O, and {T... and their lowercase equivalents. A full set of test queries that fail when executed via postgresql-9.4.1209.jar:

Thanks for the analysis.


The fix is available in 9.4.1210-SNAPSHOT

Vladimir

pgsql-jdbc by date:

Previous
From: Adam Rauch
Date:
Subject: Re: Simple queries with JDBC escaped scalar functions result in exceptions
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Simple queries with JDBC escaped scalar functions result in exceptions