What about performance if triggers are used?
Anyway, the topic is about updatable views and I found this in the manual:
To be more specific, a view is not updatable if it contains any of the following
...
* Multiple references to any column of a base table.
With respect to insertability (being updatable with INSERT statements), an updatable view is insertable if it also satisfies these additional requirements for the view columns:
* There must be no duplicate view column names.
* The view must contain all columns in the base table that do not have a default value.
* The view columns must be simple column references and not derived columns. A derived column is one that is not a simple column reference but is derived from an expression.
It seems like duplicate columns (id, members_id refer to the same field) should prevent updates, but it works. Even this query works:
[sql]UPDATE ibf_members SET mgroup =4, member_group_id =3 WHERE name = '***'[/sql]
(mgroup and member_group_id refer to one and the same column)
So my view contains all the fields in the base table. It have only simple column references. I'm still not clear why I can't insert, even when I provide all of the columns)
Actually on the question about queries that would fail:
INSERT DELAYED is not supported for views
and it's not translated into plain insert, as I would expect, but produce an error...
It was interesting research anyway and I hope this topic will be interesting for someone.
Thank you for your participation, tomorrow I'm starting to rewrite queries.