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

SQLException when backslash (\), which doesn't escape any character, is used together with setParameter()

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.3.0, 2.2.6
    • 2.4.0
    • protocol
    • None

    Description

      In the following description it is not possible to write two backslashes after each other. That's why I wrote '\ \' with space between in meaning two following backslashes without space.

      Commit https://github.com/MariaDB/mariadb-connector-j/commit/e9e8acc400d5935082b9d4d5255d5e735eae7a8f
      causes problems if SELECT or WHERE contains backspace(s) without following ' or "
      Simple Select doesn't work any more without ...?sessionVariables=sql_mode=NO_BACKSLASH_ESCAPES
      getSession().createSQLQuery("SELECT CONCAT('\\\\', '') FROM (SELECT '') AS a WHERE :q = 1").setParameter("q", 1).list();

      Caused by: java.sql.SQLException: Could not set parameter at position 1 (values was 1)
      Query - conn:1180011(M) - "SELECT CONCAT('\ \', '') FROM (SELECT '') AS a WHERE ? = 1"
      at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getSqlException(ExceptionMapper.java:211)
      at org.mariadb.jdbc.MariaDbPreparedStatementClient.setParameter(MariaDbPreparedStatementClient.java:438)
      at org.mariadb.jdbc.BasePrepareStatement.setInt(BasePrepareStatement.java:1436)
      ...

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. CONJ-618 Client preparestatement parsing error on escaped ' / " in query

          • Major - Major loss of function.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. CONJ-740 client-side failure to parse PreparedStatement with placeholders and escape characters

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CONJ-1034 Issue with escape character + question mark

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONJ-662 SQLException on PreparedStatement with special chars

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONJ-668 Prepared Statement parser incorrectly handles consecutive ESCAPE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            divus Leonid M. created issue -
            divus Leonid M. made changes -
            Field Original Value New Value
            diego dupin Diego Dupin made changes -
            Fix Version/s 2.3.1 [ 23245 ]
            diego dupin Diego Dupin made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            diego dupin Diego Dupin made changes -
            issue.field.resolutiondate 2018-12-14 14:28:07.0 2018-12-14 14:28:07.087
            diego dupin Diego Dupin made changes -
            Component/s protocol [ 14418 ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            Fix Version/s 2.4.0 [ 23154 ]
            Fix Version/s 2.3.1 [ 23245 ]
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 91035 ] MariaDB v4 [ 135089 ]
            diego dupin Diego Dupin made changes -

            People

              diego dupin Diego Dupin
              divus Leonid M.
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.