statement ok
create table t(id int primary key, v1 bigint null, v2 varchar null, v3 decimal null)

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
insert into t(id, v1, v2, v3) values (5,1,10,100)

statement ok
insert into t(id, v1, v2) values (6,1,10)

statement ok
insert into t(id, v2, v1) values (7,1,10)

statement error
insert into t(id, v1, v2, v3) values (0)

statement error
insert into t(id, v1, v2, v3) values (0, 0)

statement error
insert into t(id, v1, v2, v3) values (0, 0, 0)

statement ok
insert into t values (8,NULL,NULL,NULL)

query IIII rowsort
select * from t
----
0 1 10 100
1 1 10 100
2 2 20 200
3 3 30 300
4 4 40 400
5 1 10 100
6 1 10 null
7 10 1 null
8 null null null

statement ok
create table t1(id int primary key, v1 bigint default 233)

statement ok
insert into t1 values (0)

statement ok
insert into t1 values (1)

statement ok
insert into t1 values (2)

query III rowsort
select * from t1
----
0 233
1 233
2 233