You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-05 15:41:14 +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>
39 lines
1.7 KiB
Plaintext
39 lines
1.7 KiB
Plaintext
USE ssb1;
|
|
select lo_shipmode, c_region, sum(lo_extendedprice), count(*) from lineorder join customer on lo_custkey = c_custkey where lo_orderdate between (select d_start from ( select d_yearmonthnum * 100 + 1 d_start , count(*) from dateinfo where d_weekdayfl = 1 and d_year = 1998 group by 1 order by 2 desc limit 1) alias1) and (select d_end from ( select d_yearmonthnum * 100 + 31 d_end , count(*) from dateinfo where d_weekdayfl = 1 and d_year = 1998 group by 1 order by 2 desc limit 1) alias2) group by 1,2 order by 1,2;
|
|
lo_shipmode c_region sum(lo_extendedprice) count(*)
|
|
AIR AFRICA 8291782410.00 2170
|
|
AIR AMERICA 8436416712.00 2214
|
|
AIR ASIA 8586449147.00 2237
|
|
AIR EUROPE 8453917173.00 2198
|
|
AIR MIDDLE EAST 8374048202.00 2175
|
|
FOB AFRICA 8222451296.00 2151
|
|
FOB AMERICA 8795070316.00 2262
|
|
FOB ASIA 8721414039.00 2259
|
|
FOB EUROPE 8581506525.00 2249
|
|
FOB MIDDLE EAST 8975397130.00 2318
|
|
MAIL AFRICA 8318241157.00 2199
|
|
MAIL AMERICA 8230593182.00 2103
|
|
MAIL ASIA 8754808681.00 2267
|
|
MAIL EUROPE 8051255917.00 2116
|
|
MAIL MIDDLE EAST 8604590488.00 2242
|
|
RAIL AFRICA 8959535402.00 2319
|
|
RAIL AMERICA 8654124417.00 2264
|
|
RAIL ASIA 8792793574.00 2282
|
|
RAIL EUROPE 8186982361.00 2189
|
|
RAIL MIDDLE EAST 8149675405.00 2145
|
|
REG AIR AFRICA 8199132520.00 2141
|
|
REG AIR AMERICA 8351964483.00 2176
|
|
REG AIR ASIA 8541147824.00 2291
|
|
REG AIR EUROPE 8603274423.00 2302
|
|
REG AIR MIDDLE EAST 8016893567.00 2122
|
|
SHIP AFRICA 8412953175.00 2253
|
|
SHIP AMERICA 8208649535.00 2160
|
|
SHIP ASIA 8746116053.00 2253
|
|
SHIP EUROPE 8483100040.00 2242
|
|
SHIP MIDDLE EAST 8687217441.00 2256
|
|
TRUCK AFRICA 8613962857.00 2253
|
|
TRUCK AMERICA 8635423089.00 2203
|
|
TRUCK ASIA 8204740240.00 2127
|
|
TRUCK EUROPE 8281322322.00 2198
|
|
TRUCK MIDDLE EAST 8502459194.00 2252
|