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

Backslash (Escape character) as last character in a field breaks inserts into columnstore tables of the form INSERT INTO A SELECT * FROM B

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 1.0.11
    • Icebox
    • MDB Plugin
    • None
    • Debian GNU/Linux 9, 4.9.0-3-amd64, MariaDB: 10.1.26-MariaDB - Columnstore 1.0.11-1
      AWS EC2 m4.4xlarge - 3 PM / 3 UM

    Description

      We noticed that some of the data in our Columnstore tables had incorrect values stored.
      We use a MyISAM table as a backup for our columnstore tables, on comparison of our MyISAM tables to our Columnstore tables we saw that some rows had values in fields shifted to the left by 1 column.
      On review it turned out that rows that contained a \ as the last character in a string field had all the subsequent fields shifted left.
      Our system makes changes to our MyISAM table and then does a "INSERT INTO <Columnstore> SELECT * FROM <MyISAM>" we have narrowed it down to this SQL Query causing the issue.

      I have attached some example sql files that demonstrate the problem.
      After Importing the SQL running the query:
      "INSERT INTO testing_backslash_cs SELECT * FROM testing_backslash"
      will demonstrate the issue. Notice that row with id 2 has erroneous data in the name field and all subsequent fields are shifted to the left by 1.

      The query only runs successfully when columns at the end of the table have default values set.

      Attachments

        Issue Links

          Activity

            People

              LinuxJedi Andrew Hutchings (Inactive)
              Toby.Sear Toby Sear
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.