Bug #72768 When importing a CSV only the first line is displayed
Submitted: 27 May 2014 22:27 Modified: 21 Aug 2014 0:40
Reporter: Franck Dernoncourt Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.1.6 OS:Windows
Assigned to: CPU Architecture:Any

[27 May 2014 22:27] Franck Dernoncourt 
Description:
When importing a CSV only the first line is displayed. Demo: https://www.youtube.com/watch?v=4Nk_6VFNSKw (57 seconds)

How to repeat:
See demo: https://www.youtube.com/watch?v=4Nk_6VFNSKw (57 seconds)

import.csv contains:

a,a,b
d,x,a
e,x,a

import table:

CREATE TABLE `import` (
  `col1` varchar(100) NOT NULL,
  `col2` varchar(45) DEFAULT NULL,
  `col3` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`col1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Suggested fix:
Display all lines of the imported CSV.
[28 May 2014 0:19] MySQL Verification Team 
Thank you for te bug report.
[21 Aug 2014 0:40] Philip Olson 
Fixed as of the MySQL Workbench 6.2.0 release, and here's the changelog entry:

When importing a CSV file, only the first line was displayed.

Thank you for the bug report.