Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13927

CONNECT engine table_type=JDBC escaping backslash character on UPDATE

    XMLWordPrintable

Details

    Description

      CONNECT with JDBC is trying to escape the backslash character when doing an UPDATE on a connect table.

      So when I update a row and set the value to
      here is my \ backslash character

      it returns from a query as
      here is my
      baclslash character

      It appears CONNECT in 10.1.27 for UPDATE statements is trying to escape characters in strings that it doesn't need to escape; previous bug reports about double quote char and single quote char. It seems CONNECT should not escape ANY characters in a string except the single quote char itself, which is escaped per the SQL standard by doubling up the single quote not using a backslash.

      Attachments

        Issue Links

          Activity

            People

              bertrandop Olivier Bertrand
              rdyas Robert Dyas
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.