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
• Status: Won't Fix
• 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

[14 Sep 18:04] Omer Barnir

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.