phoenix icon indicating copy to clipboard operation
phoenix copied to clipboard

PHOENIX-4555 Only mark view as updatable if rows cannot overlap with other updatable views

Open jinggou opened this issue 1 year ago • 0 comments

Jira: PHOENIX-4555

Restrict view to be UPDATABLE if the view specification:

  1. uses only the PK columns
  2. starts from the first PK column if the parent table is not multi tenant;
otherwise, starts from the second PK column (the first column will be TENANT_ID)
  3. PK columns should be in the order they are defined
  4. uses the same set of PK columns as its sibling views' specification

Otherwise, mark the view as READ_ONLY.

jinggou avatar Mar 04 '24 22:03 jinggou