Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.11.7
-
None
-
None
Description
Documentation suggests that a view will not be updatable or insertable if it contains an outer join, however the attached example containing a view with a left join allows updates on the view but not inserts.
https://mariadb.com/kb/en/inserting-and-updating-with-views/#inserting-with-views
This is inconsistent and either the documentation is wrong or the server is behaving incorrectly.