Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-12764

Regression: Thin JDBC streaming fails/BatchUpdateException if function is used

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.8
    • Fix Version/s: 2.8.1
    • Component/s: sql
    • Labels:
      None

      Description

      insert INTO city1(id,name,name1) VALUES(?,?,RANDOM_UUID())

      happily worked in 2.7.6 but will fail on 2.8.0 with:

      Exception in thread "main" java.sql.BatchUpdateException: class org.apache.ignite.IgniteCheckedException: null
      at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection$StreamState.readResponses(JdbcThinConnection.java:1364)
      at java.base/java.lang.Thread.run(Thread.java:834)

      Suspected reason is that function RANDOM_UUID() is not processed correctly here. Column type does not matter between UUID and VARCHAR.

        Attachments

        1. SqlMain.java
          1 kB
          Ilya Kasnacheev

          Activity

            People

            • Assignee:
              cyberdemon Dmitriy Sorokin
              Reporter:
              ilyak Ilya Kasnacheev
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 1h 50m
                1h 50m