Bug #97532 Not able to concat long string
Submitted: 7 Nov 2019 11:33 Modified: 7 Nov 2019 23:46
Reporter: Shehzad Momin Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.7.26 OS:Windows (Microsoft Windows 7 Professional Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[7 Nov 2019 11:33] Shehzad Momin
Description:
I have two strings, string 1 with 208 characters and string 2 with 104 characters.

I want to concat them like below script.

SELECT CONCAT('ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ','ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ');

But I am getting result as
ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRST...

After specific length I am getting output with ...(3 dots).

But If i execute the same script in console I am getting correct output.

Would you please help me to get correct output in MySQL workbench as well?

How to repeat:
Execute below script in MySQL workbench,

SELECT CONCAT('ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ','ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ');
[7 Nov 2019 23:43] MySQL Verification Team
Concat more than defaults 256 bytes

Attachment: 97532.png (image/png, text), 225.80 KiB.

[7 Nov 2019 23:45] MySQL Verification Team
Preference to setup Field Value Length to Display

Attachment: 97532_1.png (image/png, text), 91.35 KiB.

[7 Nov 2019 23:46] MySQL Verification Team
Thank you for the bug report. Please see screenshots.
[8 Nov 2019 6:10] Shehzad Momin
My system screen shot

Attachment: mysql_workbench.png (image/png, text), 86.41 KiB.

[8 Nov 2019 8:08] MySQL Verification Team
Increase the value of: Field Value Length to Display using Edit->Preference->SQL Editor->SQL Execution, changing 256 to suitable value.