Bug #22804 it is possible to create views with syntax errors
Submitted: 28 Sep 2006 21:19
Reporter: Peter Lavin Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Workbench Preview Severity:S3 (Non-critical)
Version:1.1.3alpha OS:Windows (xp)
Assigned to: CPU Architecture:Any
Tags: Views

[28 Sep 2006 21:19] Peter Lavin
It is possible to create a view with syntax errors.

How to repeat:
Select the "Create View" option. Deliberately introduce syntax errors into the view creation - I referenced a non-existent table. Apply the changes and the view will appear in the object tree.

Suggested fix:
Disallow creation of illegal views.