====
---- QUERY
# Test that we materialize the right number of nulls.
select count(*),
  count(id),
  count(nullcol),
  sum(nullcol)
from manynulls
---- RESULTS
11000,11000,5500,28870000
---- TYPES
BIGINT,BIGINT,BIGINT,BIGINT
====
---- QUERY
# Spot check some values.
select id, nullcol
from manynulls
where id >= 4490 and id <= 4510
order by id
---- RESULTS
4490,NULL
4490,NULL
4491,NULL
4492,NULL
4493,NULL
4494,NULL
4495,NULL
4496,NULL
4497,NULL
4498,NULL
4499,NULL
4500,4500
4500,4500
4501,4501
4502,4502
4503,4503
4504,4504
4505,4505
4506,4506
4507,4507
4508,4508
4509,4509
4510,4510
4510,4510
---- TYPES
INT,INT
====