| Bug #87250 | Client Connections: SQL is being truncated when clicking on "Show in Editor" | ||
|---|---|---|---|
| Submitted: | 30 Jul 2017 9:43 | Modified: | 31 Jul 2017 10:19 |
| Reporter: | Yoni Sade | Email Updates: | |
| Status: | Won't Fix | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 6.3.9 | OS: | Windows (Microsoft Windows 10 Home) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | performance_schema, statement, WBBugReporter | ||
[30 Jul 2017 15:39]
MySQL Verification Team
Thank you for the bug report. Please try version 6.3.9, if the issue remains please provide a screen-shot. Thanks.
[30 Jul 2017 16:56]
Yoni Sade
Bug still exist on Workbench 6.3.9
[31 Jul 2017 7:28]
Chiranjeevi Battula
Hello Yoni Sade, Thank you for the feedback. I could not repeat the issue at our end using with MySQL workbench 6.3.9 versions. Could you please provide repeatable test case (exact steps, create table statement, sample data, sample query etc. - please make it as private if you prefer) to confirm this issue at our end? Thanks, Chiranjeevi.
[31 Jul 2017 9:37]
Yoni Sade
In MySQL 5.6.35/5.7.x: 1. set performance_schema=1 2. reboot DB 3. connect to DB with latest version of MySQL Workbench. 4. run this query and try to "show it in editor" from "Client Connections": select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns union select * from information_schema.tables t join information_schema.columns limit 10000 5. You should see this at the end of the query /* statement may be truncated */
[31 Jul 2017 10:19]
Chiranjeevi Battula
Hello Yoni Sade, Thank you for the feedback. Verified this behavior on MySQL Workbench in 6.3.9 version. Thanks, Chiranjeevi.
[31 Jul 2017 10:20]
Chiranjeevi Battula
Screenshot
Attachment: 87250.JPG (image/jpeg, text), 179.77 KiB.
[14 Sep 18:03]
Omer Barnir
Posted by developer: This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained. MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation. Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.
Description: When performance_schema is enabled, Workbench always truncates the statement in the "Client Connections" screen ("Show in Editor"), no matter what settings I use in workbench/mysql. *When copying the query text from the "show full processlist" command output, I can see the whole query. How to repeat: Run a query with text more than 1100 characters and try to catch it in Client Connections screen (click on "Show in Editor").