MySQL Bugs: #100941: Result set looks empty in Workbench although the data does export

Bug #100941	Result set looks empty in Workbench although the data does export
Submitted:	24 Sep 2020 11:09	Modified:	8 Oct 2020 17:13
Reporter:	Lou Radwan	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.21	OS:	Windows (10 64 bit)
Assigned to:		CPU Architecture:	Any

Description:
I downloaded the 8.0.21 version yesterday.  All queries show empty cells, unless I click in a cell, then that one cell will show its data. If I click on the upper left box in the grid and select all, then right click on the grid and Copy Row (with names, tab separated), and paste into excel, all of the data is there.  The data is just invisible in the Result Grid.

How to repeat:
This happens with every query I run since I installed 8.0.21

file shows invisible cells

Attachment: WB_bug_100941.JPG (image/jpeg, text), 54.96 KiB.

PS.  When I select all cells and CTRL C and paste in to excel, the empty results are what paste in.  This method has worked for me since I installed WB years ago.

Hello Lou Radwan,

Thank you for the bug report.
May I request you to please provide table structure and data to reproduce at our end? Thanks.

Regards,
Ashwini Patil

Hi Ashwini Patil,

Every DB, every schema, every table, is having this error.  Every query I run shows empty result sets.  

If you truly need samples, how should I submit them, is there a standard format?  Note, others in the the company that use WB and the same DBs, schemas and tables are not having this issue, just me after the latest WB update.

Thanks,
Lou

Hello Lou Radwan,

Thank you for the feedback.
Please share the sample file with .sql format and make it as private if you prefer.

Regards,
Ashwini Patil

SQL dump of a table showing invisible results

Attachment: databook_type.sql.gz (application/x-gzip, text), 940 bytes.

Ashwini Patil,

I have attached  table of data for you to reproduce at your end.

Thanks,
Lou Radwan

Screenshot of the invisible result set of the table in the zipped file

Attachment: WB_bug_empty.JPG (image/jpeg, text), 23.27 KiB.

Hello Lou Radwan,

Thank you for the details.
I tried to reproduce your issue on windows 10 with MySQL workbench 8.0.21 and imported the file shared in this bug report but I am not seeing any issues at my end. Please see the attached screenshot. 

Regards,
Ashwini Patil

8.0.21 test results

Attachment: 100941_results.PNG (image/png, text), 67.45 KiB.

Hi Ashwini Patil,

So, what do I do now?  I continue to get invisible results in 100% of the queries I run, in all DBs and all schemas.

Lou

Trying to repair or modify WB, gives me this message.

Attachment: WB_bug_C.JPG (image/jpeg, text), 41.81 KiB.

WB_bug_C.JPG

Ashwini Patil,

This attachment shows a message I get when I try to repair WB.  And when I click the download button, it takes me to a download page of:
mysql-installer-web-community-8.0.21.0.msi

Lou

Hello Lou Radwan,

Please download as it is one of the prerequisite for the WB. For more information please see here  https://dev.mysql.com/downloads/workbench/  and click on "i" icon and also, https://dev.mysql.com/doc/workbench/en/wb-installing-windows.html

Regards,
Ashwini Patil

Ashwini Patil,

I installed:  VC_redist.x64.exe as required when I try to run Repair for WB.  I rebooted as required, and WB Repair again tells me I need Visual C++ 2019 Redistributable Packed to be installed.  Checking Programs and Features, it shows installed.

What will happen if I Remove WB and reinstall?  Or do you have any ideas what else I can do?

Thanks,
Lou

Ashwini Patil,

I tried to Remove WB using the install .msi and I again get the message that I need to install Visual C++ 2019 Redistributable Pack, even after rebooting a second time.

Lou

Ashwini Patil,

I used Windows to remove WB and reinstalled, and it did not fix the issue, all data is still invisible.

Lou

Ashwini Patil,

Today I tried the following:

1. Removed WB with Windows, and reinstalled with:
mysql-installer-web-community-8.0.21.0.msi

2. Removed that install, and installed the previous version with:
mysql-workbench-community-8.0.15-winx64.msi

3. Removed that and reinstalled with:
mysql-workbench-community-8.0.21-winx64.msi

Every version shows invisible records.

Lou

Switching to DBeaver