Bug #91021 If data contains single quotes, import wizard fails to handle double quotes

• Submitted: 25 May 2018 7:45
• Modified: 28 May 2018 13:01
• Reporter: NA Morty
• Status: Verified
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.11
• OS: Windows
• CPU Architecture: Any

[25 May 2018 7:45] NA Morty

Description:
If data contains single quotes, import wizard fails to handle double quotes.

https://i.stack.imgur.com/zmFh1.png
https://i.stack.imgur.com/qlzcs.png
https://i.stack.imgur.com/Vb9ts.png

Navicat works fine.

How to repeat:
1. Create a utf8 encoding csv with MS Excel.
2. Input some data, make sure that record contains single quotes comes before record contains double quotes.

[25 May 2018 12:38] Chiranjeevi Battula

Hello Morty,

Thank you for the bug report.
I could not repeat the issue at our end using with MySQL Workbench 8.0.11 version on Windows 10.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.

[25 May 2018 12:39] Chiranjeevi Battula

Screenshot

Attachment: Bug_91021.png (image/png, text), 48.06 KiB.

[26 May 2018 1:23] NA Morty

Aren't data 4 and 5 different from the one you see in Excel? The double quotes

[28 May 2018 13:01] Chiranjeevi Battula

Hello Morty,

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

Thanks,
Chiranjeevi.