Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1518

Escaped Single Quote and Hash cause error in strings

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.1.2
    • Icebox
    • MariaDB Server
    • None

    Description

      An SQL Query that does not touch ColumnStore tables running on a MariaDB ColumnStore
      version "10.2.10-MariaDB-log - Columnstore 1.1.2-1" fails when the same query run against MariaDB version "10.1.26-MariaDB-0+deb9u1 - Debian 9.1" executes successfully when a hash (#) follows an escaped single quote (\').
      Below queries do not need any tables to be set up beforehand.
      Example Query:

      SELECT `test_col`
      FROM `test_table`
      WHERE test_table.test_col =  '\' #'
      

      Expected Result:

      #1146 - Table '<database>.test_table' doesn't exist

      Result on "10.2.10-MariaDB-log - Columnstore 1.1.2-1":
      #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''\'' at line 1

      Result on "10.1.26-MariaDB-0+deb9u1 - Debian 9.1"
      #1146 - Table '<database>.test_table' doesn't exist

      Unfortunately I do not currently have a newer version of MariaDB Columnstore to test against.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Sear Toby Sear
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.