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

CONNECT engine table_type=JDBC escaping backslash character on UPDATE

    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

              • Assignee:
                bertrandop Olivier Bertrand
                Reporter:
                rdyas Robert Dyas
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: