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

    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

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                Richard Richard Stracke
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: