MySQL Bugs: #25121: contratiction in documentation about VIEWs

Bug #25121	contratiction in documentation about VIEWs
Submitted:	17 Dec 2006 20:03	Modified:	11 Jan 2007 15:40
Reporter:	Martin Friebe (Gold Quality Contributor) (SCA)
Status:	Closed
Category:	Server: Docs	Severity:	S3 (Non-critical)
Version:	5.0/5.1	OS:	-
Assigned to:	Paul DuBois	Target Version:
Tags:	VIEW, documentation
Triage:	D4 (Minor)

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.