MySQL Bugs: #103572: DATA EXPORT FAILED NO SCHEMA OBJECTS DISPLAYED

Bug #103572	DATA EXPORT FAILED NO SCHEMA OBJECTS DISPLAYED
Submitted:	4 May 2021 12:51	Modified:	15 Sep 2022 6:49
Reporter:	Chris Stromberg	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	8.0.24	OS:	MacOS (macOS 11.2.x Big Sur x86_64)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
I cannot perform a Data Export of a selected schema.  When the tables to export schema is selected, there are no schema objects listed to select.

When the start export button is pressed, it displays the following error:

Error Fetching Table List From troop95Db (DbMySQLQuery.resultFieldStringValueByName(): MySQL_ResultSet::isNull: invalid value of 'columnLabel')
23:56:55 Export of /Users/chrisstromberg/dumps/Dump20210503 (4) has finished

How to repeat:
Select Data Export from Administration or from Server menu.

Select Tables to Export from Data Export window.

No Schema Objects are available to choose from.

Select Start Export and error message is generated.

Thank you for the bug report. Which server version are you connected? Please attach here the wb.log.

I am using this server version.

8.0.24 (MySQL Community Server - GPL)

Hello Chris Stromberg,

Thank you for the bug report.
I tried to reproduce your issue on workbench 8.0.24 using dummy database but I am not seeing any issues at my end.

Regards,
Ashwini Patil

screen shot tables in database.

Attachment: Screen Shot 2021-05-05 at 8.59.31 AM.jpg (image/jpeg, text), 1.88 MiB.

Screen shot of right pane with no selectable schemas displayed from db

Attachment: Screen Shot 2021-05-05 at 8.58.44 AM.jpg (image/jpeg, text), 1.71 MiB.

Same with mysql server and workbench version 8.0.26, Data Export is not showing the objects of selected schema.

I got the same bug. Happened when I import my DB from another export. 
After the Import I see the tables and I can see the data in them, But in the Export wizard I am not able to see the tables from a schema.

Using the 8.0.26 version of MySQL Workbench

Got the same behavior with Version 8.0.27 (Server & Workbench) under Windows 10. Server 8.0.27 with Workbench 8.0.19 works fine.
regards Gerd

Still there:
mysqld --version
/usr/local/mysql-8.0.30-macos12-x86_64/bin/mysqld  Ver 8.0.30 for macos12 on x86_64 (MySQL Community Server - GPL)

Workbench: 8.0.30

logged in as 'root'

Interestingly, 3 of my schema show tables when selected,
two schemas show no tables.

All these table were dumped/reloaded from mysqld 5.7.16

All schema have the same creation incantation in the dump.sql 
(for 5 different `schema1`, `schema2`, `schema3`...) 
1, 2, 5 "work" in export/dump; 3,4 show no tables.

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `schema1` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `schema1`;

After careful creation/editing/deleting of the .sql dump/load files
I have an answer:

The schemas that have are named with a Capital letter (eg: schemaZ) FAIL
Schema names that are all lowercase show up in the data/export listing of tables.

Therefore: since mysql does not appear to restrict the schema names from using occasional CAPS, I suggest that the data/export function be extended to search for the tables of such schema.

Ashwini said: "I tried to reproduce your issue on workbench 8.0.24 using dummy database but I am not seeing any issues at my end."

Please try again with a "Dummy" db, or a "dummyDb"

a schema that works

Attachment: schema1.sql (application/octet-stream, text), 2.57 KiB.

a Schema that fails

Attachment: Schema2.sql (application/octet-stream, text), 2.57 KiB.

Ashwini notes: this is duplicate of Bug #103783