Bug #96346 Workbench is not responding
Submitted: 26 Jul 2019 18:04 Modified: 8 Sep 2019 19:00
Reporter: Emmanuel Louis Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:8.0.15 OS:Windows (x62)
Assigned to: CPU Architecture:Any
Tags: Workbench not responding

[26 Jul 2019 18:04] Emmanuel Louis
Description:
Every time I start adding a lot of columns together the system (workbench) crashes into a not responding state. I below this is a critical issue.

How to repeat:
The code is below. When you start adding too many columns it starts not responding.

create view PQ_v1 as select SUBJID,VISITN,
case when PQ0201 = "" then 10 end as PQ0201a,
case when PQ0202 = "" then 10 end as PQ0202a,
case when PQ0203 = "" then 10 end as PQ0203a,
case when PQ0204 = "" then 10 end as PQ0204a,
case when PQ0205 = "" then 10 end as PQ0205a,
case when PQ0206 = "" then 10 end as PQ0206a,
case when PQ0207 = "" then 10 end as PQ0207a,
case when PQ0208 = "" then 10 end as PQ0208a,
case when PQ0209 = "" then 10 end as PQ0209a,
case when PQ0210 = "" then 10 end as PQ0210a,
case when PQ0211 = "" then 10 end as PQ0211a,
case when PQ0212 = "" then 10 end as PQ0212a,
case when PQ0213 = "" then 10 end as PQ0213a,
case when PQ0214 = "" then 10 end as PQ0214a,
case when PQ0215 = "" then 10 end as PQ0215a,
case when PQ0216 = "" then 10 end as PQ0216a,
case when PQ0217 = "" then 10 end as PQ0217a,
case when PQ0218 = "" then 10 end as PQ0218a,
case when PQ0219 = "" then 10 end as PQ0219a,
case when PQ0220 = "" then 10 end as PQ0220a,
case when PQ0221 = "" then 10 end as PQ0221a,
case when PQ0222 = "" then 10 end as PQ0222a,
case when PQ0223 = "" then 10 end as PQ0223a,
case when PQ0224 = "" then 10 end as PQ0224a,
case when PQ0225 = "" then 10 end as PQ0225a,
case when PQ0226 = "" then 10 end as PQ0226a,
case when PQ0227 = "" then 10 end as PQ0227a,
case when PQ0228 = "" then 10 end as PQ0228a,
(PQ0201+PQ0202+PQ0203+PQ0204+PQ0205+PQ0206+PQ0207+PQ0208+PQ0209+PQ0210+PQ0211+PQ0212+PQ0213+PQ0214+PQ0215+PQ0216+PQ0217+PQ0218+PQ0219+PQ0220+PQ0221+PQ0222+PQ0223+PQ0224+PQ0225+PQ0226+PQ0227+PQ0228)
as FTOTAL from UPD where VISITN = "V5 Wash Out Period" order by SUBJID;

Suggested fix:
This should not happen to the workbench.
[27 Jul 2019 16:55] MySQL Verification Team
Please try version 8.0.17. Thanks.
[28 Jul 2019 0:42] Emmanuel Louis
I have the same issue with version .17
[8 Aug 2019 19:00] MySQL Verification Team
Thank you for feedback. I couldn't repeat trying the partial script here, please provide a complete script sql file attached with Files tab. Thanks.
[9 Sep 2019 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".