statement ok
create table t(id int primary key, v1 int, v2 int, v3 int default 233)

statement ok
insert into t values (0,1,10,100)

statement ok
insert into t values (1,1,10,100), (2,2,20,200), (3,3,30,300), (4,4,40,400)

statement ok
update t set v2 = 9 where v1 = 1

query IIII rowsort
select * from t;
----
0 1 9 100
1 1 9 100
2 2 20 200
3 3 30 300
4 4 40 400

statement ok
update t set v2 = 9

query IIII rowsort
select * from t
----
0 1 9 100
1 1 9 100
2 2 9 200
3 3 9 300
4 4 9 400

statement ok
update t set v3 = default

query IIII rowsort
select * from t
----
0 1 9 233
1 1 9 233
2 2 9 233
3 3 9 233
4 4 9 233

statement ok
update t set v3 = v1 + 1

query IIII rowsort
select * from t
----
0 1 9 2
1 1 9 2
2 2 9 3
3 3 9 4
4 4 9 5

statement ok
drop table t
