database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-11-03 17:13:17 +03:00
Code Activity
Files
cmapi-json-in-out-by-default
mariadb-columnstore-engine/mysql-test/columnstore/devregression/r/mcs7687_ssb_dim10.result
Daniel Lee 4c9d6e39ac Dlee mtr restructure (#2494) 
* 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>
2022-08-09 21:20:56 +03:00

842 lines
26 KiB
Plaintext
Raw Permalink Blame History

USE ssb1;
select count(*)
from dateinfo d1,
part p2_um,
customer c1,
part p4_um,
customer c3_um,
supplier s2,
part p1,
dateinfo d2,
part p3,
customer c2_um,
lineorder
where lo_orderkey > 0 and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
;
count(*)
184
select count(*)
from dateinfo d2,
part p3,
customer c2_um,
supplier s1,
customer c4,
dateinfo d1,
part p2_um,
customer c1,
part p4_um,
customer c3_um,
lineorder
where lo_orderkey > 0 and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
2080
select count(*)
from customer c1,
part p4_um,
customer c3_um,
supplier s2,
part p1,
dateinfo d2,
part p3,
customer c2_um,
supplier s1,
customer c4,
lineorder
where lo_orderkey > 0 and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
;
count(*)
164
select count(*)
from customer c2_um,
supplier s1,
customer c4,
dateinfo d1,
part p2_um,
customer c1,
part p4_um,
customer c3_um,
supplier s2,
part p1,
lineorder
where lo_orderkey > 0 and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
;
count(*)
44
select count(*)
from customer c3_um,
supplier s2,
part p1,
dateinfo d2,
part p3,
customer c2_um,
supplier s1,
customer c4,
dateinfo d1,
part p2_um,
lineorder
where lo_orderkey > 0 and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
;
count(*)
44
select count(*)
from customer c4,
dateinfo d1,
part p2_um,
customer c1,
part p4_um,
customer c3_um,
supplier s2,
part p1,
dateinfo d2,
part p3,
lineorder
where lo_orderkey > 0 and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
;
count(*)
86
select count(*)
from part p1,
dateinfo d2,
part p3,
customer c2_um,
supplier s1,
customer c4,
dateinfo d1,
part p2_um,
customer c1,
part p4_um,
lineorder
where lo_orderkey > 0 and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
;
count(*)
2028
select count(*)
from part p2_um,
customer c1,
part p4_um,
customer c3_um,
supplier s2,
part p1,
dateinfo d2,
part p3,
customer c2_um,
supplier s1,
lineorder
where lo_orderkey > 0 and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
312
select count(*)
from part p3,
customer c2_um,
supplier s1,
customer c4,
dateinfo d1,
part p2_um,
customer c1,
part p4_um,
customer c3_um,
supplier s2,
lineorder
where lo_orderkey > 0 and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
;
count(*)
45
select count(*)
from part p4_um,
customer c3_um,
supplier s2,
part p1,
dateinfo d2,
part p3,
customer c2_um,
supplier s1,
customer c4,
dateinfo d1,
lineorder
where lo_orderkey > 0 and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
;
count(*)
44
select count(*)
from supplier s1,
customer c4,
dateinfo d1,
part p2_um,
customer c1,
part p4_um,
customer c3_um,
supplier s2,
part p1,
dateinfo d2,
lineorder
where lo_orderkey > 0 and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
;
count(*)
44
select count(*)
from supplier s2,
part p1,
dateinfo d2,
part p3,
customer c2_um,
supplier s1,
customer c4,
dateinfo d1,
part p2_um,
customer c1,
lineorder
where lo_orderkey > 0 and lo_suppkey = s2.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and p3.p_category <= 'MFGR#13'
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
;
count(*)
44
select count(*)
from dateinfo d1,
customer c4,
supplier s1,
customer c2_um,
part p3,
dateinfo d2,
part p1,
supplier s2,
customer c3_um,
part p4_um,
lineorder
where lo_orderkey > 0 and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
;
count(*)
44
select count(*)
from dateinfo d2,
part p1,
supplier s2,
customer c3_um,
part p4_um,
customer c1,
part p2_um,
dateinfo d1,
customer c4,
supplier s1,
lineorder
where lo_orderkey > 0 and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
44
select count(*)
from customer c1,
part p2_um,
dateinfo d1,
customer c4,
supplier s1,
customer c2_um,
part p3,
dateinfo d2,
part p1,
supplier s2,
lineorder
where lo_orderkey > 0 and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
;
count(*)
44
select count(*)
from customer c2_um,
part p3,
dateinfo d2,
part p1,
supplier s2,
customer c3_um,
part p4_um,
customer c1,
part p2_um,
dateinfo d1,
lineorder
where lo_orderkey > 0 and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
;
count(*)
184
select count(*)
from customer c3_um,
part p4_um,
customer c1,
part p2_um,
dateinfo d1,
customer c4,
supplier s1,
customer c2_um,
part p3,
dateinfo d2,
lineorder
where lo_orderkey > 0 and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
;
count(*)
2080
select count(*)
from customer c4,
supplier s1,
customer c2_um,
part p3,
dateinfo d2,
part p1,
supplier s2,
customer c3_um,
part p4_um,
customer c1,
lineorder
where lo_orderkey > 0 and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
;
count(*)
164
select count(*)
from part p1,
supplier s2,
customer c3_um,
part p4_um,
customer c1,
part p2_um,
dateinfo d1,
customer c4,
supplier s1,
customer c2_um,
lineorder
where lo_orderkey > 0 and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
;
count(*)
44
select count(*)
from part p2_um,
dateinfo d1,
customer c4,
supplier s1,
customer c2_um,
part p3,
dateinfo d2,
part p1,
supplier s2,
customer c3_um,
lineorder
where lo_orderkey > 0 and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
44
select count(*)
from part p3,
dateinfo d2,
part p1,
supplier s2,
customer c3_um,
part p4_um,
customer c1,
part p2_um,
dateinfo d1,
customer c4,
lineorder
where lo_orderkey > 0 and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
;
count(*)
86
select count(*)
from part p4_um,
customer c1,
part p2_um,
dateinfo d1,
customer c4,
supplier s1,
customer c2_um,
part p3,
dateinfo d2,
part p1,
lineorder
where lo_orderkey > 0 and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
;
count(*)
2028
select count(*)
from supplier s1,
customer c2_um,
part p3,
dateinfo d2,
part p1,
supplier s2,
customer c3_um,
part p4_um,
customer c1,
part p2_um,
lineorder
where lo_orderkey > 0 and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
;
count(*)
312
select count(*)
from supplier s2,
customer c3_um,
part p4_um,
customer c1,
part p2_um,
dateinfo d1,
customer c4,
supplier s1,
customer c2_um,
part p3,
lineorder
where lo_orderkey > 0 and lo_suppkey = s2.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c4.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and s2.s_city in ('ALGERIA 0','ALGERIA 1','ALGERIA 2','GERMANY 0','GERMANY 1','UNITED KI2','UNITED KI3')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c4.c_region in ('EUROPE')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
;
count(*)
45
View Git Blame Copy Permalink