You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
83 lines
2.3 KiB
Plaintext
83 lines
2.3 KiB
Plaintext
USE tpch1;
|
|
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_orderkey <= 100000 and 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' and l1.l_orderkey <= 100000 and l2.l_orderkey <= 100000
|
|
group by s_name order by numwait desc, s_name ;
|
|
s_name numwait
|
|
Supplier#000001150 2
|
|
Supplier#000001334 2
|
|
Supplier#000002860 2
|
|
Supplier#000005968 2
|
|
Supplier#000006382 2
|
|
Supplier#000006697 2
|
|
Supplier#000006831 2
|
|
Supplier#000007249 2
|
|
Supplier#000009245 2
|
|
Supplier#000009666 2
|
|
Supplier#000000961 1
|
|
Supplier#000001055 1
|
|
Supplier#000001060 1
|
|
Supplier#000001113 1
|
|
Supplier#000001211 1
|
|
Supplier#000001643 1
|
|
Supplier#000001798 1
|
|
Supplier#000002244 1
|
|
Supplier#000002437 1
|
|
Supplier#000002505 1
|
|
Supplier#000002605 1
|
|
Supplier#000002613 1
|
|
Supplier#000002754 1
|
|
Supplier#000002768 1
|
|
Supplier#000003044 1
|
|
Supplier#000003106 1
|
|
Supplier#000003160 1
|
|
Supplier#000003178 1
|
|
Supplier#000003295 1
|
|
Supplier#000003658 1
|
|
Supplier#000003703 1
|
|
Supplier#000004273 1
|
|
Supplier#000004490 1
|
|
Supplier#000004561 1
|
|
Supplier#000005147 1
|
|
Supplier#000005491 1
|
|
Supplier#000005719 1
|
|
Supplier#000005845 1
|
|
Supplier#000005853 1
|
|
Supplier#000005891 1
|
|
Supplier#000005898 1
|
|
Supplier#000006117 1
|
|
Supplier#000006174 1
|
|
Supplier#000006581 1
|
|
Supplier#000006614 1
|
|
Supplier#000006755 1
|
|
Supplier#000006945 1
|
|
Supplier#000007087 1
|
|
Supplier#000007496 1
|
|
Supplier#000007515 1
|
|
Supplier#000007785 1
|
|
Supplier#000008383 1
|
|
Supplier#000008493 1
|
|
Supplier#000008602 1
|
|
Supplier#000008652 1
|
|
Supplier#000008685 1
|
|
Supplier#000009008 1
|
|
Supplier#000009198 1
|
|
Supplier#000009510 1
|
|
Supplier#000009590 1
|
|
Supplier#000009807 1
|
|
select r_regionkey, n_regionkey, n_nationkey from region left join
|
|
nation on (r_regionkey=n_regionkey and R_regionkey>n_nationkey) order by 1, 2, 3;
|
|
r_regionkey n_regionkey n_nationkey
|
|
0 NULL NULL
|
|
1 NULL NULL
|
|
2 NULL NULL
|
|
3 NULL NULL
|
|
4 NULL NULL
|