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;
----
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
----
1 1 9 100
2 2 9 200
3 3 9 300
4 4 9 400

statement ok
update t set v2 = default

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

statement ok
drop table t