Spring JDBC not correctly processing Postgresql ?-contained operator [SPR-13582]

[spring-projects-issues]

Artur Geraschenko opened SPR-13582 and commented

Postgresql has many functional operators such as ? (for example JSONB operators).

Spring JDBC processing for this case is not correct. When running the following SQL:

SELECT '["1","2","3"]'::jsonb ? '4'

... I see exceptions like this:

class org.springframework.dao.InvalidDataAccessApiUsageException
SQL [SELECT '["1","2","3"]'::jsonb ? '4']: given 1 parameters but expected 0

In pgjdbc this bug was fixed in 2014 (pgjdbc/pgjdbc#227).

---

Affects: 4.2.2

Reference URL: #892

Issue Links:

• Spring JDBC not correctly processing Postgresql ? operator [SPR-16511] #21054 Spring JDBC not correctly processing Postgresql ? operator
• Spring JDBC not correctly processing Postgresql ?| and ?& operator [SPR-15382] #19945 Spring JDBC not correctly processing Postgresql ?| and ?& operator

Referenced from: commits 11d1f05

[spring-projects-issues]

Artur Geraschenko commented

I fix it #892

[spring-projects-issues]

Artur Geraschenko commented

Juergen, hello! I really want to get this fix in the near release, whether it is possible to speed up the adoption of the revisions?

[spring-projects-issues]

Juergen Hoeller commented

Rolling this into 4.2.3 now, to appear in the 4.2.3.BUILD-SNAPSHOT...

Juergen