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:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.6	OS:	Microsoft 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