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

Transform per 4 "\" to a "\" when LOAD DATA INFILE

    XMLWordPrintable

    Details

      Description

      CREATE TABLE escape_inno
      (
      id int AUTO_INCREMENT PRIMARY KEY,
      sVal varchar(50),
      createDate datetime
      ) ENGINE=INNODB DEFAULT CHARSET utf8;

      CREATE TABLE escape_columnstore
      (
      id int NOT NULL,
      sVal varchar(50),
      createDate datetime
      ) ENGINE=columnstore DEFAULT CHARSET utf8 COMMENT='autoincrement=id';

      LOAD DATA INFILE '/mnt/data/testEscape.asc.data1' INTO TABLE escape_inno CHARACTER SET UTF8; – GOOD: transform per 2 "\" to a "\"
      LOAD DATA INFILE '/mnt/data/testEscape.asc.data1' INTO TABLE escape_columnstore CHARACTER SET UTF8; – BAD: transform per 4 "\" to a "\"

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            gavin3180 Gavin Chen
            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.