It's also updated if the clustered index is changed.
Maria DB stores an IS_UPDATABLE flag with each view, so it is always possible to see if Maria DB considers a view updatable (although not necessarily insertable) by querying the IS_UPDATABLE column in the INFORMATION_SCHEMA. The WITH CHECK OPTION clause is used to prevent updates or inserts to views unless the WHERE clause in the SELECT statement is true. WITH LOCAL CHECK OPTION restricts the CHECK OPTION to only the view being defined, while WITH CASCADED CHECK OPTION checks all underlying views as well.
There are several common reason an UPDATE statement may fail.
Some of the common ones are: In these cases, the UPDATE statement execution stops and the UPDATE generates an error.
No rows from the UPDATE statement are saved into the table, even those rows that didn’t generate an error.
This “all or nothing” behavior can be modified for arithmetic errors. Will generate an error if SET ARITHABORT is set to ON.