Bug #88557 Workbench becomes extremly slow with a SQL script with DOS line endings

• Submitted: 20 Nov 2017 12:59
• Modified: 20 Nov 2017 13:18
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 6.3.10
• OS: Any
• CPU Architecture: Any

[20 Nov 2017 12:59] Daniël van Eeden

Description:
Opening a script with "\n" line endings (UNIX style) is much faster than opening the same script but with "\r\n" line endings (MS-DOS style)

How to repeat:
See attached files.

[20 Nov 2017 13:00] Daniël van Eeden

File with UNIX line endings

Attachment: wb_inlist.sql (application/sql, text), 1.42 MiB.

[20 Nov 2017 13:01] Daniël van Eeden

file with MS-DOS line endinges (I did use unix2dos)

Attachment: wb_inlist2.sql (application/sql, text), 1.61 MiB.

[20 Nov 2017 13:05] Daniël van Eeden

This is on Fedora 27 x86_64

[20 Nov 2017 13:13] Daniël van Eeden

This is just for opening the script, not for executing it.

[20 Nov 2017 13:18] MySQL Verification Team

Hello Daniël,

Thank you for the report.
I quickly tried on Win7 with provided .sql files and observed that noticeable slowness when DOS line endings file is opened.

Thanks,
Umesh