Uploaded image for project: 'MariaDB Connector/C'
  1. MariaDB Connector/C
  2. CONC-49

LOAD DATA LOCAL query fails to import all rows with mariadb client revision 80

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None
    • None
    • Windows

    Description

      LOAD DATA LOCAL query fails to import all rows. It fails after importing first row and shows warning "Data truncated for column 'c' at row 1".
      It was working fine till revision 79.

      Here are the details:
      Table Structure:
      CREATE TABLE `csv_table` (
      `a` int(11) DEFAULT NULL,
      `b` int(11) DEFAULT NULL,
      `c` int(11) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1

      LOAD LOCAL QUERY:
      LOAD DATA LOCAL INFILE 'C:\\Users\\XYZ\\Desktop
      sample.csv' INTO TABLE `csv_db`.`csv_table` FIELDS ESCAPED BY '
      ' TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (`a`, `b`, `c`);

      sample.csv attached here.

      Attachments

        1. sample.csv
          0.0 kB
          Sandhya Sriraj

        Activity

          Peter Laursen Peter Laursen added a comment -

          It seems that 'Windows Linebreaks' (\r\n) are broken in revision 80 with LOAD DATA LOCAL.

          Please also observe that "LINES TERMINATED BY" can specify any character sequence.
          It is not restricted to 'visual linebreaks' (neither Linux, Windows nor Mac -style) actually.

          Peter Laursen Peter Laursen added a comment - It seems that 'Windows Linebreaks' (\r\n) are broken in revision 80 with LOAD DATA LOCAL. Please also observe that "LINES TERMINATED BY" can specify any character sequence . It is not restricted to 'visual linebreaks' (neither Linux, Windows nor Mac -style) actually.
          georg Georg Richter added a comment -

          fixed in rev. 84

          georg Georg Richter added a comment - fixed in rev. 84

          People

            georg Georg Richter
            sandhyasriraj Sandhya Sriraj
            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.