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:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.75d
                  0.75d

                  Git Integration

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