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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11343 LOAD DATA INFILE fails to load data with an escape character followed by a multi-byte character

          • Major - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              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.