broken-updatable-views.sql

text/plain

Filename: broken-updatable-views.sql

Type: text/plain

Part: 1

Message: Re: fill_extraUpdatedCols is done in completely the wrong place

drop view v1;
drop table tab1;

create table tab1 (f1 int, f2 int generated always as (f1 * 2) stored);

insert into tab1 values (42);

table tab1;

create view v1 as select * from tab1;

update v1 set f1 = 11;

table tab1;