MySQL Bugs: #81718: "Refresh All" doesn't refresh previously broken views

Bug #81718	"Refresh All" doesn't refresh previously broken views
Submitted:	3 Jun 2016 17:16	Modified:	5 Jun 2016 14:07
Reporter:	Tony Brix	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.6	OS:	Windows (Microsoft Windows 10 Pro Insider Preview)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
After fixing a view that was broken (e.g. by changing a column name in a table the view references) the view still states "View 'view_name' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" after fixing the view and clicking refresh.

How to repeat:
1. Create a table
2. Create a view that references a column in that table
3. Change the column name in the table
4. Refresh the SCHEMAS in the Navigator pane
5. Click on the view in the navigator
   a. The Information panel will state "View 'view_name' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"
6. Change the column name in the table to the original name that the view references
7. Refresh the SCHEMAS in the Navigator pane
8. Click on the view in the navigator
   a. The Information panel will still state "View 'view_name' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"

Hello Tony Brix,

Thank you for the report.
Verified as described with WB 6.3.6 on Win7.

Thanks,
Umesh

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.