Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11631

LOAD DATA INFILE fails to load data with an escape character followed by a multi-byte character

    XMLWordPrintable

Details

    Description

      Bug MDEV-11343 still exist in 5.5.52 and 5.5.53

      Same steps to reproduce

      echo "\ä" >/tmp/test.txt
      

      Now I try to load this file into a table:

      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8);
      LOAD DATA INFILE '/tmp/test.txt' INTO TABLE t1 CHARACTER SET utf8;
      

      It fails with this error:

      ERROR 1300 (HY000): Invalid utf8 character string: ''
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              Richard Richard Stracke
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.