statement ok
create table t(id int primary key, v1 int, v2 int not null)

statement ok
insert into t values (0, 2, 4), (1, 1, 3), (2, 3, 4), (3, 4, 3);

query III
select * from t where v1 > 1
----
0 2 4
2 3 4
3 4 3

query III
select * from t where v1 < 2
----
1 1 3

statement ok
drop table t

statement ok
create table t(id int primary key, v1 int null, v2 int)

statement ok
insert into t values (0, 2, 4), (1, null, 3), (2, 3, 4), (3, 4, 3)

query III
select * from t where v1 > 1
----
0 2 4
2 3 4
3 4 3

query III
select * from t where v1 is null
----
1 null 3

query III
select * from t where v1 is not null
----
0 2 4
2 3 4
3 4 3

query III
select * from t where null
----

statement ok
drop table t