Query Accelerator | large dataset retrieval bug

select

  s_name,

  count(*) as numwait

from

  (

    select

      *

    from

      tpc_h.supplier,

      tpc_h.lineitem l1,

      tpc_h.orders,

      tpc_h.nation

    where

      s_suppkey = l1.l_suppkey

      and o_orderkey = l1.l_orderkey

      and s_nationkey = n_nationkey

      and 0 = 1

    UNION ALL

    select

      *

    from

      supplier,

      lineitem l1,

      orders,

      nation

    where

      s_suppkey = l1.l_suppkey

      and o_orderkey = l1.l_orderkey

      and o_orderstatus = 'F'

      and l1.l_receiptdate > l1.l_commitdate

      and exists(

        select

          *

        from

          lineitem l2

        where

          l2.l_orderkey = l1.l_orderkey

          and l2.l_suppkey <> l1.l_suppkey

      )

      and not exists (

        select

          *

        from

          lineitem l3

        where

          l3.l_orderkey = l1.l_orderkey

          and l3.l_suppkey <> l1.l_suppkey

          and l3.l_receiptdate > l3.l_commitdate

      )

      and s_nationkey = n_nationkey

      and n_name = 'SAUDI ARABIA'

  ) tmp

group by

  s_name

order by

  numwait desc,

  s_name

limit

  100;