Uploaded image for project: 'Spring Framework'
  1. Spring Framework
  2. SPR-13582

Spring JDBC not correctly processing Postgresql ?-contained operator

    Details

      Description

      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 (https://github.com/pgjdbc/pgjdbc/pull/227).

        Issue Links

          Activity

          Show
          arturgspb Artur Geraschenko added a comment - I fix it https://github.com/spring-projects/spring-framework/pull/892
          Hide
          arturgspb Artur Geraschenko added a comment -

          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?

          Show
          arturgspb Artur Geraschenko added a comment - 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?
          Hide
          juergen.hoeller Juergen Hoeller added a comment -

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

          Juergen

          Show
          juergen.hoeller Juergen Hoeller added a comment - Rolling this into 4.2.3 now, to appear in the 4.2.3.BUILD-SNAPSHOT ... Juergen

            People

            • Assignee:
              juergen.hoeller Juergen Hoeller
              Reporter:
              arturgspb Artur Geraschenko
              Last updater:
              Juergen Hoeller
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 17 weeks, 5 days ago