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

    • 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

          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.