JDBC and the hstore ? operator - no longer working with build 1211

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC and the hstore ? operator - no longer working with build 1211
Date: 2016-10-31 21:07:01
Message-ID: nv8bpg$ivu$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

The support for using the hstore ? operator without a PreparedStatement worked with build 1208, but is broken (again) with build 1211

The following works with build 1208

Connection conn = DriverManager.getConnection(...);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from some_table where hstore_column ? 'foo');

with build 1211 it throws an exception with the message:

org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"

Was this intended to work in build 1208 or was that just by accident?

Thomas

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2016-11-01 03:06:48 Re: [RFC] How about changing the default value of defaultRowFetchSize?
Previous Message Vladimir Gordiychuk 2016-10-30 22:47:39 Re: [RFC] How about changing the default value of defaultRowFetchSize?