Bug #22804 it is possible to create views with syntax errors

• Submitted: 28 Sep 2006 21:19
• Reporter: Peter Lavin
• Status: Won't fix
• Category: MySQL Workbench Preview
• Severity: S3 (Non-critical)
• Version: 1.1.3alpha
• OS: Windows (xp)
• CPU Architecture: Any
• Tags: Views

[28 Sep 2006 21:19] Peter Lavin

Description:
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.