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

            Unassigned Unassigned
            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.