statement ok
create table t(v1 int, v2 int, v3 int)

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

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

statement ok
insert into t(v1, v2, v3) values (1,10,100)

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

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

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

query III rowsort
select * from t
----
1	10	100
1	10	100
1	10	100
1	10	NULL
10	1	NULL
2	20	200
3	30	300
4	40	400
NULL	NULL	NULL