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

[3 Jun 2016 17:16] Tony Brix
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"
[5 Jun 2016 14:07] Umesh Shastry
Hello Tony Brix,

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

Thanks,
Umesh