MySQL Bugs: #97005: Error if try to expand the object-tree in schemas while an invalid object exists

Bug #97005	Error if try to expand the object-tree in schemas while an invalid object exists
Submitted:	25 Sep 2019 8:48	Modified:	25 Sep 2019 9:59
Reporter:	Hartmut Mehnert	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.17	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
We have renamed any views to mark it for delete.
In one of these views is another renamed view with his origin name, so the first view is not longer correct.
After connet to the server in the Action Output appears the line:
"Error loading schema content
Error Code: 1356 View 'webhaus_live.del_undenbetr_servicekontakt_kommunikationsweg_email_versenden' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
". 
This is ok, but in the schema tree appears after each entry "could not be fetched". This is not good. To expand the entrys for Tables, Views, Procedures und Functions is possible and all objects are visible.
But if the first view is filtered with ".del_undenbetr_servicekontakt_kommunikationsweg_email_versenden" then this object was found and the entry "Views" is marked to expand. On try to expand appeaers the error.
Without filter it is possible to expand Views and open the corrupt view del_undenbetr_servicekontakt_kommunikationsweg_email_versenden.
The error occurs only with filter.

How to repeat:
Rename to views, where the second is used in the first with the previous name.

Suggested fix:
My workaround is:
change the second renamed viewname in the first view. Then is the first view correct and all is ok, the error no more appears.

Errormessage in Action Output

Attachment: Output.JPG (image/jpeg, text), 32.26 KiB.

'Could not be fetched ' in schema tree

Attachment: could not be fetched.JPG (image/jpeg, text), 19.88 KiB.

schema tree with filter-entry

Attachment: with filter.JPG (image/jpeg, text), 20.90 KiB.

error-window after clicking views with filter

Attachment: encountered a problem.JPG (image/jpeg, text), 47.12 KiB.

Hello Hartmut Mehnert,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil

8.0.17 test results

Attachment: 97005_results.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 434.61 KiB.