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

CONNECT engine table_type=JDBC UPDATE containing single or double quote chars produces wrong result

    XMLWordPrintable

Details

    Description

      In testing with the Microsoft JDBC environemnt,

      INSERTing a value like the following DOES work: Bob's
      INSERTing a value like the following DOES work: size is 24"

      However, trying to UPDATE a column and specifying those values does NOT work...
      for UPDATE with a string like Bob's you get an error, and for UPDATE with size is 24" you don't get an error but it is saved as \" and the next query returns that.

      The escaping is the same for INSERT and UPDATE, but it doesn't seem to work correctly for UPDATE.

      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.