Bug #93062 intelli sense is going to a never ending loop
Submitted: 2 Nov 2018 12:45 Modified: 19 Nov 2018 8:11
Reporter: Peter Szabo Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.12 OS:Ubuntu (18.04.1)
Assigned to: CPU Architecture:Any

[2 Nov 2018 12:45] Peter Szabo 
Description:
If the query contains several sub-queries and a group / order by at the end,
tends to use high CPU, which never ends.

How to repeat:
Reproduction might be hard, although with sensible source code check the bug can be eliminated.

select * from
(select * from...) q
left join
(select * from...) q
group by order by

Naturally i might have a very extreme case as my query has 50 long lines with 20 sub-queries. Although problems won't occur, just after some time. (so i guess the group by was a problem, because the query was long before that also)

Suggested fix:
I have disabled intellisense on workbench.
[2 Nov 2018 12:46] Peter Szabo 
It's serious problem, as i need to kill the mysql workbench.
[2 Nov 2018 12:48] Peter Szabo 
version updated
[19 Nov 2018 8:11] MySQL Verification Team 
Thank you for the bug report duplicate of https://bugs.mysql.com/bug.php?id=92329.