Queries used in the experiments of the paper "Lazy vs Eager Query Plans for Tuple-Independent Probabilistic Databases" (ICDE'09)

select 
	l_returnflag, 
	l_linestatus, 
	conf() 
from 
	lineitem 
where 
	l_shipdate <= date '1998-09-01' 
group by 
	l_returnflag, 
	l_linestatus;

select 
	conf()
from 
	lineitem 
where 
	l_shipdate <= date '1998-09-01';

select
	s_acctbal,
	s_name,
	n_name,
	p_partkey,
	p_mfgr,
	s_address,
	s_phone,
	s_comment,
	conf()
from
	part,
	supplier,
	partsupp,
	nation,
	region
where
	p_partkey = ps_partkey
	and s_suppkey = ps_suppkey
	and p_size = 15
	and p_type like '%BRASS'
	and s_nationkey = n_nationkey
	and n_regionkey = r_regionkey
	and r_name = 'EUROPE'
group by
	s_acctbal,
	s_name,
	n_name,
	p_partkey,
	p_mfgr,
	s_address,
	s_phone,
	s_comment;

select
	l_orderkey,
  	o_orderdate,
   	o_shippriority,
	conf()
from
  	customer,
   	orders,
   	lineitem
where
  	c_mktsegment = 'BUILDING'
   	and c_custkey = o_custkey
   	and l_orderkey = o_orderkey
   	and o_orderdate < date '1992-01-10'
   	and l_shipdate > date '1992-01-10'
group by
   	l_orderkey,
   	o_orderdate,
 	o_shippriority;

select
	conf()
from
  	customer,
  	orders,
  	lineitem
where
  	c_mktsegment = 'BUILDING'
   	and c_custkey = o_custkey
 	and l_orderkey = o_orderkey
   	and o_orderdate < date '1992-01-10'
 	and l_shipdate > date '1992-01-10';

select
	o_orderpriority,
	conf()
from
	orders,
	lineitem
where
	o_orderdate >= date '1993-07-01'
	and o_orderdate < date '1993-10-01'
	and l_orderkey = o_orderkey
	and l_commitdate < l_receiptdate
group by
	o_orderpriority;

select
	conf()
from
	orders,
	lineitem
where
	o_orderdate >= date '1993-07-01'
	and o_orderdate < date '1993-10-01'
	and l_orderkey = o_orderkey
	and l_commitdate < l_receiptdate;

The same as the Boolean version.

select
	conf()
from
	lineitem
where
	l_shipdate >= '1994-01-01'
	and l_shipdate < '1995-01-01'
	and l_discount >= 0.05 
	and l_discount <= 0.07
	and l_quantity < 24;

select
	s_suppkey,
	n1.n_name,
	conf()	
from
	supplier,
	lineitem,
	orders,
	customer,
	nation n1,
	nation n2
where
	s_suppkey = l_suppkey
	and o_orderkey = l_orderkey
	and c_custkey = o_custkey
	and s_nationkey = n1.n_nationkey
	and c_nationkey = n2.n_nationkey
	and ((n1.n_name = 'GERMANY' and n2.n_name = 'FRANCE')
            or (n1.n_name = 'FRANCE' and n2.n_name = 'GERMANY'))
	and l_shipdate between '1995-01-01' and '1996-12-31'
group by 
	s_suppkey,
	n1.n_name;

select
	c_custkey,
	c_name,
	c_acctbal,
	n_name,
	c_address,
	c_phone,
	c_comment,
	conf()
from
	customer,
	orders,
	lineitem,
	nation
where    
	c_custkey = o_custkey
	and l_orderkey = o_orderkey
 	and o_orderdate >= '1993-01-01' 
 	and o_orderdate < '1993-1-10'
  	and l_returnflag = 'N'
  	and c_nationkey = n_nationkey
group by
	c_custkey,
	c_name,
	c_acctbal,
	n_name,
	c_address,
	c_phone,
	c_comment;

select
	conf()
from
	customer,
	orders,
	lineitem,
	nation
where    
	c_custkey = o_custkey
	and l_orderkey = o_orderkey
 	and o_orderdate >= '1993-01-01' 
 	and o_orderdate < '1993-1-10'
  	and l_returnflag = 'N'
  	and c_nationkey = n_nationkey;

select
	ps_partkey,
	conf()
from
	partsupp,
	supplier,
	nation
where
	ps_suppkey = s_suppkey
	and s_nationkey = n_nationkey
	and n_name = 'GERMANY'
group by
	ps_partkey;

select
	conf()
from
	partsupp,
	supplier,
	nation
where
	ps_suppkey = s_suppkey
	and s_nationkey = n_nationkey
	and n_name = 'GERMANY';

select
	l_shipmode,
	conf()
from
	orders,
	lineitem
where
	orders.o_orderkey = lineitem.l_orderkey
  	and (l_shipmode = 'MAIL' 
		or l_shipmode = 'SHIP')
   	and l_commitdate < l_receiptdate
   	and l_shipdate < l_commitdate
   	and l_receiptdate >= '1992-01-01'
   	and l_receiptdate < '1999-01-01'
group by
	l_shipmode;

select
	conf()
from
	orders,
	lineitem
where
	orders.o_orderkey = lineitem.l_orderkey
  	and (l_shipmode = 'MAIL' 
		or l_shipmode = 'SHIP')
   	and l_commitdate < l_receiptdate
   	and l_shipdate < l_commitdate
   	and l_receiptdate >= '1992-01-01'
   	and l_receiptdate < '1999-01-01';

The same as the Boolean version.

select
    conf()
from
    lineitem,
    part
where
    l_partkey = p_partkey
    and l_shipdate >= date '1995-09-01'
    and l_shipdate < date '1995-10-01';

select
    s_suppkey,
    s_name,
    s_address,
    s_phone,
    conf()
from
    supplier,
    lineitem
where
    s_suppkey = l_suppkey
    and l_shipdate >= date '1991-10-10'
    and l_shipdate < date '1992-01-10'
group by
    s_suppkey,
    s_name,
    s_address,
    s_phone;

select
    conf()
from
    supplier,
    lineitem
where
    s_suppkey = l_suppkey
    and l_shipdate >= date '1991-10-10'
    and l_shipdate < date '1992-01-10';

select
    p_brand,
    p_type,
    p_size,
    conf()
from
    partsupp,
    part
where
    p_partkey = ps_partkey
    and p_brand = 'Brand#45'
    and p_type like 'MEDIUM POLISHED%'
    and p_size in ( 49, 14, 23, 45, 19, 3, 36, 9 )
group by
    p_brand,
    p_type,
    p_size;

select
    conf()
from
    partsupp,
    part
where
    p_partkey = ps_partkey
    and p_brand <> 'Brand#45'
    and p_type like 'MEDIUM POLISHED%'
    and p_size in ( 49, 14, 23, 45, 19, 3, 36, 9 );

The same as the Boolean version.

select
    conf()
from
    lineitem,
    part
where
    p_partkey = l_partkey
    and p_brand = 'Brand#23'
    and p_container = 'MED BOX';

select
    c_custkey,
    c_name,
    o_orderkey,
    o_orderdate,
    o_totalprice,
    conf()
from
    customer,
    orders,
    lineitem
where
    c_custkey = o_custkey
    and o_orderkey = l_orderkey
    and c_name = 'Customer#000148949'
group by
    c_custkey,
    c_name,
    o_orderkey,
    o_orderdate,
    o_totalprice;

select
    conf()
from
    customer,
    orders,
    lineitem
where
    c_custkey = o_custkey
    and o_orderkey = l_orderkey
    and c_name = 'Customer#000148949';

The same as the Boolean version.

select
    conf()
from
    lineitem,
    part
where
    p_partkey = l_partkey and (
    (       p_brand = 'Brand#12'             
        and p_container in ('SM CASE','SM BOX','SM PACK','SM PKG')
        and l_quantity >= 1 and l_quantity <= 1 + 10
        and p_size between 1 and 5
        and l_shipmode in ('AIR', 'AIR REG')
        and l_shipinstruct = 'DELIVER IN PERSON' )
    or (     
            p_brand = 'Brand#23'
        and p_container in ('MED BAG','MED BOX','MED PKG','MED PACK')
        and l_quantity >= 10 and l_quantity <= 10 + 10
        and p_size between 1 and 10
        and l_shipmode in ('AIR', 'AIR REG')
        and l_shipinstruct = 'DELIVER IN PERSON')
    or (
            p_brand = 'Brand#34'
        and p_container in ('LG CASE','LG BOX','LG PACK','LG PKG')
        and l_quantity >= 20 and l_quantity <= 20 + 10
        and p_size between 1 and 15
        and l_shipmode in ('AIR', 'AIR REG')
        and l_shipinstruct = 'DELIVER IN PERSON'));

select
    s_suppkey,
    s_name,
    s_address,
    conf()
from
    supplier,
    nation,
    partsupp,
    part
where
    s_suppkey = ps_suppkey
    and p_partkey = ps_partkey
    and p_name like 'forest%'
    and s_nationkey = n_nationkey
    and n_name = 'CANADA'
group by
    s_suppkey,
    s_name,
    s_address;

select
    s_suppkey,
    conf()
from
    supplier,
    lineitem,
    orders,
    nation
where
    s_suppkey = l_suppkey
    and o_orderkey = l_orderkey
    and o_orderstatus = 'F'
    and l_receiptdate > l_commitdate
    and s_nationkey = n_nationkey
    and n_name = 'SAUDI ARABIA'
group by
    s_suppkey;