Bug #56701 Show Broken Views

• Submitted: 9 Sep 2010 18:12
• Modified: 11 Nov 2011 2:27
• Reporter: Kyle Stevens
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S4 (Feature request)
• Version: 5.2.27
• OS: Any
• CPU Architecture: Any
• Tags: regression, VIEW, workbench

[9 Sep 2010 18:12] Kyle Stevens

Description:
In the old MySQL Administrator, if a view was broken (example, a column no longer exists), the view used to have an exclamation mark next to it.  In MySQL Workbench, there's no easy way to locate broken views.  

How to repeat:
CREATE TABLE `test` (
  `idtest` int(11) NOT NULL,
  `test2` varchar(45) DEFAULT NULL,
  `test3` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idtest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE VIEW `nepco2_dbo`.`new_view` AS
SELECT test2, test3
from test;

ALTER TABLE `nepco2_dbo`.`test` DROP COLUMN `test3` ;

Suggested fix:
In the SQL Editor Object Browser's list of views, the icon next to each view should display an error icon if the view's definition is invalid.

[10 Sep 2010 6:31] Valeriy Kravchuk

Thank you for the feature request.

[11 Nov 2011 2:27] Philip Olson

Fixed as of 5.2.36:

+        Broken views (e.g., a column no longer exists) are now displayed
+        as broken within the schema tree view.