MySQL Bugs: #25121: contratiction in documentation about VIEWs

Bug #25121	contratiction in documentation about VIEWs
Submitted:	17 Dec 2006 19:03	Modified:	11 Jan 2007 14:40
Reporter:	Martin Friebe (Gold Quality Contributor) (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.0/5.1	OS:	-
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	documentation, VIEW

Description:
there are 2 opposing statements in the documentation

the View FAQ on http://dev.mysql.com/doc/refman/5.0/en/faqs-views.html#qandaitem-26-6-4 says:

" 26.6.6:  Can you insert into views that are based on joins?
It is possible, provided that your INSERT statement has a column list that makes it clear there's only one table involved.
You cannot insert into multiple tables with a single insert on a view. "

BUT http://dev.mysql.com/doc/refman/5.0/en/create-view.html

" There are also certain other constructs that make a view non-update-able. To be more specific, a view is not update-able if it contains any of the following:
....
    *    Join  "

followed by specifying insert-able views as a subset of update-able

How to repeat:
-

Suggested fix:
The FAQ seems (in most cases) to be right. Views with a join are insert-able (and update-able), If the insert, or update matches the restrictions for updating views

The "create view page" should be fixed, to either not mention join, or state "certain join"

Thank you for the bug report.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Yes, it should be only "certain joins" - the conditions are
described later on the page.