Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
We'll run into issues if updatable sibling views overlap with each other. For example, say you have the following hierarchy:
T (A, B, C)
V1 (D, E) FROM T WHERE A = 1
V2 (F, G) FROM T WHERE A = 1 and B = 2
In this case, there's no way to update both V1 and v2 columns. Secondary indexes wouldn't work either, if you had one on each V1 & V2.
We should restrict updatable views to
- views that filter on PK column(s)
- sibling views filter on same set of PK column(s)