| 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: | Verified | 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.
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").