Bug #90915 Code completion with user-defined variable defined in subquery crashes Workbench
Submitted: 17 May 2018 13:09 Modified: 21 May 2018 21:31
Reporter: Fredric Johansson Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.11 OS:Any
Assigned to: CPU Architecture:Any

[17 May 2018 13:09] Fredric Johansson
If a user-defined variable is defined in a subquery, invoking code-completion for the select list either manually or automatically crashes Workbench.

Example query where code-completion may crash.

FROM (SELECT @rn:=0) b;

Placing the cursor in the SELECT list and invoking code-completion will reliably cause a crash. I have only managed to trigger this when a variable exist in the subquery

How to repeat:
See above
[17 May 2018 13:14] MySQL Verification Team
Hello Fredric,

Thank you for the report and test case!

[21 May 2018 21:31] Christine Cole
Posted by developer:
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

With code completion enabled, defining a custom variable within a subquery
caused an unexpected exit.

Thank you for the bug report.