No Resultset for TPCH Q22

[Shining]

OS: CentOS 5.7 x86_64
InfiniDB: 2.2.4

CPU: Q8200
MEM: 8G

There's no result returned when executing TPCH Q22 on tpc-h 1scale data and 10scale data.

select s_name, count(distinct(l1.l_orderkey+10*l1.l_linenumber)) as numwait from supplier, orders, nation, lineitem l1 left join lineitem l2 on (l2.l_orderkey = l1.l_orderkey and l2.l_suppkey <> l1.l_suppkey) left join (select l3.l_orderkey,l3.l_suppkey from lineitem l3 where l3.l_receiptdate > l3.l_commitdate) l4 on (l4.l_orderkey = l1.l_orderkey and l4.l_suppkey <> l1.l_suppkey) where s_suppkey = l1.l_suppkey and o_orderkey = l1.l_orderkey and o_orderstatus = 'F' and l1.l_receiptdate > l1.l_commitdate and l2.l_orderkey is not null and l4.l_orderkey is null and s_nationkey = n_nationkey and n_name = 'MOROCCO' group by s_name order by numwait desc, s_name LIMIT 100;

[Robert Adams (radams-calpont)]

Please try the normal tpch q22.

mysql> select cntrycode, count(*) as numcust, sum(c_acctbal) as totacctbal from ( select substr(c_phone, 1, 2) as cntrycode, c_acctbal from customer where substr(c_phone, 1, 2) in ('13', '31', '23', '29', '30', '18', '17') and c_acctbal > ( select avg(c_acctbal) from customer where c_acctbal > 0.00 and substr(c_phone, 1, 2) in ('13', '31', '23', '29', '30', '18', '17')) and not exists ( select * from orders where o_custkey = c_custkey ) ) custsale group by cntrycode order by cntrycode;
+-----------+---------+------------+
| cntrycode | numcust | totacctbal |
+-----------+---------+------------+
| 13 | 888 | 6737713.99 |
| 17 | 861 | 6460573.72 |
| 18 | 964 | 7236687.40 |
| 23 | 892 | 6701457.95 |
| 29 | 948 | 7158866.63 |
| 30 | 909 | 6808436.13 |
| 31 | 922 | 6806670.18 |
+-----------+---------+------------+
7 rows in set (1.52 sec)