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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      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

          Activity

            People

            Assignee:
            georg Georg Richter
            Reporter:
            sandhyasriraj Sandhya Sriraj
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration