Bug #88558 Workbench becomes extremly slow with a SQL script with a huge in-list

• Submitted: 20 Nov 2017 13:18
• Modified: 22 Nov 2017 8:05
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.3.10
• OS: Any
• CPU Architecture: Any

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

Description:
A query with a huge in list which operates on an empty table is very slow.

1. mysqld takes some time for the exmplain, this is expected.
2. Workbench eats a lot of CPU and doesn't seem to return a result.
3. The "Action" text in "Action Output" seems to be corrupted.

This is on Fedora 27 x86_64 with Wayland.

How to repeat:
CREATE TABLE t1 (id int primary key, name varchar(10));

SELECT
  id,
  name
FROM t1
WHERE id IN (
1,
2,
......
199995,
199996,
199997,
199998,
199999,
200000);

Now:
1. Run explain (takes some time for mysqld to execute)
2. Run the query.

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

example file

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

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

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

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

Screenshot showing corrupted text for "Action"

Attachment: Screenshot from 2017-11-20 14-23-39.png (image/png, text), 124.97 KiB.

[22 Nov 2017 8:05] MySQL Verification Team

Hello Daniël,

Thank you for the report and feedback.
Observed this on Fed26 with WB 6.3.10.

Thanks,
Umesh