mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-06-10 17:41:44 +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>
54 lines
732 B
Plaintext
54 lines
732 B
Plaintext
USE tpch1;
|
|
Select l_quantity, count(*) from lineitem where l_orderkey < 1000000 group by l_quantity order by l_quantity;
|
|
l_quantity count(*)
|
|
1.00 19945
|
|
2.00 19804
|
|
3.00 19993
|
|
4.00 19815
|
|
5.00 19775
|
|
6.00 19743
|
|
7.00 19614
|
|
8.00 19883
|
|
9.00 20161
|
|
10.00 19980
|
|
11.00 19636
|
|
12.00 20041
|
|
13.00 20086
|
|
14.00 19800
|
|
15.00 20092
|
|
16.00 20169
|
|
17.00 20158
|
|
18.00 19830
|
|
19.00 20056
|
|
20.00 20013
|
|
21.00 20136
|
|
22.00 19961
|
|
23.00 20176
|
|
24.00 20224
|
|
25.00 20171
|
|
26.00 20117
|
|
27.00 20041
|
|
28.00 20193
|
|
29.00 19999
|
|
30.00 19821
|
|
31.00 19895
|
|
32.00 20042
|
|
33.00 19786
|
|
34.00 20124
|
|
35.00 20224
|
|
36.00 20274
|
|
37.00 19997
|
|
38.00 19982
|
|
39.00 19932
|
|
40.00 20000
|
|
41.00 20160
|
|
42.00 20198
|
|
43.00 19967
|
|
44.00 19940
|
|
45.00 20064
|
|
46.00 20082
|
|
47.00 20042
|
|
48.00 20076
|
|
49.00 19920
|
|
50.00 19910
|