MySQL Bugs: #1235: SQL Views

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:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.0	OS:
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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:
N/A

Suggested fix:
N/A

Views are supported as of MySQL 5.0.1, available from http://dev.mysql.com/

Thanks.