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
• Status: Verified
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.3.6
• OS: Microsoft Windows (Microsoft Windows 10 Pro Insider Preview)
• 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] MySQL Verification Team

Hello Tony Brix,

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

Thanks,
Umesh