Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-222

StringOutOfBoundsException in prepareStatement when rewriteBatchedStatements=true

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.3.0, 1.2.2, 1.2.3, 1.3.1
    • 1.3.2
    • Other
    • None

    Description

      This statement causes a StringOutOfBoundsException when rewriteBatchedStatement=true:

      INSERT INTO table1 SELECT a1.col21 b1 FROM table2 a1 LEFT OUTER JOIN table3 c1 ON a1.col21 = c1.col31 AND c1.col32 = ? WHERE c1.col33 IS NULL AND a1.col22 = ? AND a1.col21 IN (?,?,?,?,?)

      Exception (with version 1.3.1):

      Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: -59
      		 
      	at java.lang.String.substring(String.java:1931)
      		 
      	at org.mariadb.jdbc.internal.query.MariaDbClientParameterizeQuery.<init>(MariaDbClientParameterizeQuery.java:134)
      		 
      	at org.mariadb.jdbc.MariaDbClientPreparedStatement.<init>(MariaDbClientPreparedStatement.java:89)

      It worked fine with version 1.2.0, so it could be the CONJ-168 fix that broke something.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          andreas Andreas Persson created issue -
          diego dupin Diego Dupin made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          diego dupin Diego Dupin made changes -
          Component/s Other [ 12201 ]
          Fix Version/s 1.3.2 [ 20602 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          diego dupin Diego Dupin added a comment -

          This case INSERT ... SELECT in not handle : it has not to be rewriten but driver was trying to.
          Will be handle in the 1.3.2 correction version (this week).

          diego dupin Diego Dupin added a comment - This case INSERT ... SELECT in not handle : it has not to be rewriten but driver was trying to. Will be handle in the 1.3.2 correction version (this week).
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 72651 ] MariaDB v4 [ 134815 ]

          People

            diego dupin Diego Dupin
            andreas Andreas Persson
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.