Bug #1235 SQL Views
Submitted: 9 Sep 2003 12:08 Modified: 27 Oct 2004 19:55
Reporter: W W D Dowdell Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0 OS:
Assigned to: CPU Architecture:Any

[9 Sep 2003 12:08] W W D Dowdell
I believe that SQL views are an extremely important feature addition. I know that they are being discussed for 5.1, but the large commercial applications I've worked on would have been far more costly to implement (in Oracle and DB2) and maintain if SQL views had not been available. I'd prefer to see them sooner rather than later.

Further, despite Dr. Codd's Rule #6, I have never found the need to update views directly, so I would prefer a simpler implemention that did not attempt to resolve the complex issues of updateable views.

How to repeat:

Suggested fix:
[27 Oct 2004 19:55] Jim Winstead
Views are supported as of MySQL 5.0.1, available from http://dev.mysql.com/