mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +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>
118 lines
4.0 KiB
Plaintext
118 lines
4.0 KiB
Plaintext
USE ssb1;
|
|
select d_year, s_nation, p_category,
|
|
sum(lo_revenue - lo_supplycost) as profit
|
|
from customer, supplier, part, dateinfo, lineorder # changed order
|
|
where lo_custkey = c_custkey
|
|
and lo_suppkey = s_suppkey
|
|
and lo_partkey = p_partkey
|
|
and lo_orderdate = d_datekey
|
|
and c_region = 'AMERICA'
|
|
and s_region = 'AMERICA'
|
|
and (d_year = 1997 or d_year = 1998)
|
|
and lo_orderdate between 19970101 and 19981231 # added matching predicate
|
|
and (p_mfgr = 'MFGR#1'
|
|
or p_mfgr = 'MFGR#2')
|
|
group by d_year, s_nation, p_category
|
|
order by d_year, s_nation, p_category;
|
|
d_year s_nation p_category profit
|
|
1997 ARGENTINA MFGR#11 1046230125.00
|
|
1997 ARGENTINA MFGR#12 1108301658.00
|
|
1997 ARGENTINA MFGR#13 1076239089.00
|
|
1997 ARGENTINA MFGR#14 1131439492.00
|
|
1997 ARGENTINA MFGR#15 1078746087.00
|
|
1997 ARGENTINA MFGR#21 957263735.00
|
|
1997 ARGENTINA MFGR#22 1031211752.00
|
|
1997 ARGENTINA MFGR#23 1046883608.00
|
|
1997 ARGENTINA MFGR#24 951412143.00
|
|
1997 ARGENTINA MFGR#25 1054327484.00
|
|
1997 BRAZIL MFGR#11 954093212.00
|
|
1997 BRAZIL MFGR#12 1038093317.00
|
|
1997 BRAZIL MFGR#13 1063341981.00
|
|
1997 BRAZIL MFGR#14 1037205025.00
|
|
1997 BRAZIL MFGR#15 925421639.00
|
|
1997 BRAZIL MFGR#21 965589092.00
|
|
1997 BRAZIL MFGR#22 996999098.00
|
|
1997 BRAZIL MFGR#23 1007918298.00
|
|
1997 BRAZIL MFGR#24 1094578535.00
|
|
1997 BRAZIL MFGR#25 1055718671.00
|
|
1997 CANADA MFGR#11 1107648111.00
|
|
1997 CANADA MFGR#12 1000123669.00
|
|
1997 CANADA MFGR#13 1172022564.00
|
|
1997 CANADA MFGR#14 1053363700.00
|
|
1997 CANADA MFGR#15 1059672985.00
|
|
1997 CANADA MFGR#21 1031318213.00
|
|
1997 CANADA MFGR#22 1131105195.00
|
|
1997 CANADA MFGR#23 1081071368.00
|
|
1997 CANADA MFGR#24 1004291452.00
|
|
1997 CANADA MFGR#25 1005065645.00
|
|
1997 PERU MFGR#11 1261604004.00
|
|
1997 PERU MFGR#12 1000222177.00
|
|
1997 PERU MFGR#13 1135148016.00
|
|
1997 PERU MFGR#14 1177303901.00
|
|
1997 PERU MFGR#15 1093903237.00
|
|
1997 PERU MFGR#21 1085650080.00
|
|
1997 PERU MFGR#22 1068901001.00
|
|
1997 PERU MFGR#23 1243191792.00
|
|
1997 PERU MFGR#24 1088650504.00
|
|
1997 PERU MFGR#25 1029659928.00
|
|
1997 UNITED STATES MFGR#11 1040517148.00
|
|
1997 UNITED STATES MFGR#12 1062308744.00
|
|
1997 UNITED STATES MFGR#13 989444729.00
|
|
1997 UNITED STATES MFGR#14 1120496880.00
|
|
1997 UNITED STATES MFGR#15 1081280930.00
|
|
1997 UNITED STATES MFGR#21 900529598.00
|
|
1997 UNITED STATES MFGR#22 1071679717.00
|
|
1997 UNITED STATES MFGR#23 1091519252.00
|
|
1997 UNITED STATES MFGR#24 983128411.00
|
|
1997 UNITED STATES MFGR#25 983183914.00
|
|
1998 ARGENTINA MFGR#11 686392460.00
|
|
1998 ARGENTINA MFGR#12 524836909.00
|
|
1998 ARGENTINA MFGR#13 690523361.00
|
|
1998 ARGENTINA MFGR#14 649476801.00
|
|
1998 ARGENTINA MFGR#15 615799216.00
|
|
1998 ARGENTINA MFGR#21 634110060.00
|
|
1998 ARGENTINA MFGR#22 597419332.00
|
|
1998 ARGENTINA MFGR#23 689697302.00
|
|
1998 ARGENTINA MFGR#24 669199878.00
|
|
1998 ARGENTINA MFGR#25 610484751.00
|
|
1998 BRAZIL MFGR#11 668899901.00
|
|
1998 BRAZIL MFGR#12 561512876.00
|
|
1998 BRAZIL MFGR#13 633186070.00
|
|
1998 BRAZIL MFGR#14 572722037.00
|
|
1998 BRAZIL MFGR#15 651686093.00
|
|
1998 BRAZIL MFGR#21 531465629.00
|
|
1998 BRAZIL MFGR#22 506038184.00
|
|
1998 BRAZIL MFGR#23 645491859.00
|
|
1998 BRAZIL MFGR#24 648560186.00
|
|
1998 BRAZIL MFGR#25 602757291.00
|
|
1998 CANADA MFGR#11 671353176.00
|
|
1998 CANADA MFGR#12 612239521.00
|
|
1998 CANADA MFGR#13 660720266.00
|
|
1998 CANADA MFGR#14 626172058.00
|
|
1998 CANADA MFGR#15 671287287.00
|
|
1998 CANADA MFGR#21 529119747.00
|
|
1998 CANADA MFGR#22 667604878.00
|
|
1998 CANADA MFGR#23 596683357.00
|
|
1998 CANADA MFGR#24 554893189.00
|
|
1998 CANADA MFGR#25 710933244.00
|
|
1998 PERU MFGR#11 750316502.00
|
|
1998 PERU MFGR#12 693122370.00
|
|
1998 PERU MFGR#13 650706633.00
|
|
1998 PERU MFGR#14 578951333.00
|
|
1998 PERU MFGR#15 705353465.00
|
|
1998 PERU MFGR#21 603219507.00
|
|
1998 PERU MFGR#22 704738239.00
|
|
1998 PERU MFGR#23 677041815.00
|
|
1998 PERU MFGR#24 625168316.00
|
|
1998 PERU MFGR#25 794375754.00
|
|
1998 UNITED STATES MFGR#11 682079660.00
|
|
1998 UNITED STATES MFGR#12 565159069.00
|
|
1998 UNITED STATES MFGR#13 565717243.00
|
|
1998 UNITED STATES MFGR#14 599523448.00
|
|
1998 UNITED STATES MFGR#15 511332610.00
|
|
1998 UNITED STATES MFGR#21 554993261.00
|
|
1998 UNITED STATES MFGR#22 633727751.00
|
|
1998 UNITED STATES MFGR#23 623152694.00
|
|
1998 UNITED STATES MFGR#24 650447386.00
|
|
1998 UNITED STATES MFGR#25 584068884.00
|