Bug #87904 Return comma missing from CSV when using export
Submitted: 28 Sep 2017 17:46 Modified: 26 Jan 2018 15:15
Reporter: Web Dev Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3.10 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[28 Sep 2017 17:46] Web Dev
When exporting to CSV using the Export Button (next to the Filter Rows box) the file is missing the , at the end of every row so the CSV is corrupt when importing into various systems

How to repeat:
Run a query where some columns have commas (,) in the fields, so the CSV file will need to enclose them in quote marks (")

The resultant CSV will be missing the final , character

When looked at in Notepad++, is has the LF but no CR or , at the end of each line
[29 Sep 2017 13:24] Chiranjeevi Battula
Hello Web,

Thank you for the bug report.
Could you please provide repeatable test case (exact steps, create table scripts, tables data etc. - please make it as private if you prefer) to confirm this issue at our end?

[4 Oct 2017 10:11] Chiranjeevi Battula
Hello Web,

Thank you for the feedback..
Verified this behavior on MySQL Workbench in 6.3.9 version.

[5 Oct 2017 7:20] Web Dev
Glad it is not just me losing my mind!

Do I need to roll back to a previous version? I've got a bit of work I need to do using this.

[26 Jan 2018 15:15] Web Dev
This bug is still present in the latest version (6.3.10)