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:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.9 OS:Microsoft Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: performance_schema, statement, WBBugReporter

[30 Jul 2017 9:43] Yoni Sade
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").
[30 Jul 2017 15:39] Miguel Solorzano
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.