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) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.10 OS:Any
Assigned to: 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] Umesh Shastry
Hello Daniël,

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

Thanks,
Umesh