mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-21 19:45:56 +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>
36 lines
898 B
Plaintext
36 lines
898 B
Plaintext
USE tpch1;
|
|
select p_brand, sum(l_quantity) tot_qty,
|
|
avg(l_quantity) avg_qty
|
|
from part, lineitem
|
|
where l_shipdate between '1996-04-01' and '1996-04-14'
|
|
and p_size = 5
|
|
and p_partkey = l_partkey
|
|
group by p_brand
|
|
order by 1;
|
|
p_brand tot_qty avg_qty
|
|
Brand#11 732.00 25.241379
|
|
Brand#12 986.00 28.171429
|
|
Brand#13 814.00 25.437500
|
|
Brand#14 704.00 26.074074
|
|
Brand#15 580.00 23.200000
|
|
Brand#21 664.00 25.538462
|
|
Brand#22 518.00 22.521739
|
|
Brand#23 964.00 28.352941
|
|
Brand#24 460.00 20.000000
|
|
Brand#25 632.00 25.280000
|
|
Brand#31 674.00 28.083333
|
|
Brand#32 653.00 25.115385
|
|
Brand#33 710.00 25.357143
|
|
Brand#34 414.00 23.000000
|
|
Brand#35 516.00 19.846154
|
|
Brand#41 797.00 29.518519
|
|
Brand#42 1003.00 30.393939
|
|
Brand#43 823.00 23.514286
|
|
Brand#44 1026.00 27.729730
|
|
Brand#45 435.00 21.750000
|
|
Brand#51 739.00 25.482759
|
|
Brand#52 880.00 28.387097
|
|
Brand#53 837.00 24.617647
|
|
Brand#54 1126.00 30.432432
|
|
Brand#55 525.00 21.000000
|