| Bug #117320 | block of code with repeat() function doesn't end after semicolon on its end | ||
|---|---|---|---|
| Submitted: | 28 Jan 22:18 | Modified: | 29 Jan 11:25 |
| Reporter: | Sergii Matsiupa | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
| Version: | 8.0.41 | OS: | Windows (Microsoft Windows 10 Enterprise) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[29 Jan 6:21]
MySQL Verification Team
Hello Sergii Matsiupa, Thank you for the report and feedback. Could you please attach the screenshot(or video demonstrating the problem) to the bug report? I'm requesting you to attach here because it is showing me blank when I'm trying to see. Thank you. regards, Umesh
[29 Jan 10:54]
Sergii Matsiupa
I added screenshot with demonstration, it's very easy to reproduce in application
[29 Jan 11:07]
MySQL Verification Team
Thank you, for the feedback.
Verified as described.
In general, it is not affecting the execution of individual statements but "grouping" of statements after "select repeat('x', 4);" gives impression that it is single statement.
regards,
Umesh
[29 Jan 11:25]
Sergii Matsiupa
yes, exactly But anyway I don't think it's correct behavior of GUI.
Description: When typing something in the code editor of MySQL Workbench after query like select repeat('x', 4); - the editor obviously considered all the next code as a continuation of the query with repeat() function. How to repeat: - open the new query tab in the MySQL workbench - type 'show tables' (+ empty line) - type 'select repeat('x', 4);' (+ empty line) - type 'select trim('smth');' (+ empty line) - type 'show DATABASES;' (+ empty line) - make sure that last 2 queries considered in editor as a part of the one with repeat() (see on screenshot https://imgur.com/a/9nT1BwX)