====
---- QUERY
# This memory limit causes a spill to happen for this query
set buffer_pool_limit=250m;
# This query forces many joins and aggregations with spilling
# and can expose race conditions in the spilling code if run in parallel
select
  count(distinct l2.l_comment)
from
  lineitem l1,
  lineitem l2,
  lineitem l3
where
  # We can make the query faster by lowering the values below
  l1.l_tax < 1.0
  and l2.l_tax < 1.0
  and l1.l_orderkey = l2.l_orderkey
  and l1.l_orderkey = l3.l_orderkey
  and l1.l_comment = l3.l_comment
  and l1.l_shipdate = l3.l_shipdate;
---- RESULTS
4580667
---- TYPES
BIGINT
====