Bug #102718 Workbench shows blank line when trying to edit a very large field
Submitted: 24 Feb 2021 7:17 Modified: 25 Feb 2021 17:03
Reporter: Andries Venter Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:8.0.23 OS:Windows
Assigned to: CPU Architecture:x86

[24 Feb 2021 7:17] Andries Venter
When populating a TEXT field with a very long string (7712 characters), the data is shown in the Result Grid.  However, when trying to edit the data by clicking on the field, only a blank line is shown.  You can move the cursor around, but the data is invisible!

You can however copy the "blank" field and paste it to a text editor...

How to repeat:
Create a table with only 2 fields:
id (integer, NN, PK, AI)
test (text)

Populate it with a 7750 character string

When you insert it, the field is blank.  When you click on another record, you see the data...
[25 Feb 2021 12:24] MySQL Verification Team
Hello Andries Venter,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.23 but I am not seeing any issues at my end. 

Ashwini Patil
[25 Feb 2021 12:25] MySQL Verification Team
8.0.23 test results

Attachment: 102718_test_results.PNG (image/png, text), 55.36 KiB.

[25 Feb 2021 17:01] Andries Venter
I am using Windows 8.1.  Doubtful if it makes a difference.  I don't have a Windows 10 PC to test it, so I am going to live with the problem for now...
[25 Feb 2021 17:03] Andries Venter
Also, I have spaces in between.  With my test string, I had about 1200 groups of 7 letter words with spaces in between.  Maybe that is part of the problem???