You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-10-31 18:30:33 +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>
209 lines
12 KiB
Plaintext
209 lines
12 KiB
Plaintext
USE tpch1;
|
|
select count(l_orderkey), min(l_orderkey), max(l_orderkey) , sum(l_orderkey), avg(l_orderkey) from lineitem;
|
|
count(l_orderkey) min(l_orderkey) max(l_orderkey) sum(l_orderkey) avg(l_orderkey)
|
|
6001215 1 6000000 18005322964949 3000279.6042
|
|
select count(l_partkey), min(l_partkey), max(l_partkey) , sum(l_partkey), avg(l_partkey) from lineitem;
|
|
count(l_partkey) min(l_partkey) max(l_partkey) sum(l_partkey) avg(l_partkey)
|
|
6001215 1 200000 600229457837 100017.9893
|
|
select count(l_suppkey), min(l_suppkey), max(l_suppkey) , sum(l_suppkey), avg(l_suppkey) from lineitem;
|
|
count(l_suppkey) min(l_suppkey) max(l_suppkey) sum(l_suppkey) avg(l_suppkey)
|
|
6001215 1 10000 30009691369 5000.6026
|
|
select count(l_linenumber), min(l_linenumber), max(l_linenumber) , sum(l_linenumber), avg(l_linenumber) from lineitem;
|
|
count(l_linenumber) min(l_linenumber) max(l_linenumber) sum(l_linenumber) avg(l_linenumber)
|
|
6001215 1 7 18007100 3.0006
|
|
select count(l_quantity), min(l_quantity), max(l_quantity) , sum(l_quantity), avg(l_quantity) from lineitem;
|
|
count(l_quantity) min(l_quantity) max(l_quantity) sum(l_quantity) avg(l_quantity)
|
|
6001215 1.00 50.00 153078795.00 25.507967
|
|
select count(l_extendedprice), min(l_extendedprice), max(l_extendedprice) , sum(l_extendedprice), avg(l_extendedprice) from lineitem;
|
|
count(l_extendedprice) min(l_extendedprice) max(l_extendedprice) sum(l_extendedprice) avg(l_extendedprice)
|
|
6001215 901.00 104949.50 229577310901.20 38255.138485
|
|
select count(l_discount), min(l_discount), max(l_discount) , sum(l_discount), avg(l_discount) from lineitem;
|
|
count(l_discount) min(l_discount) max(l_discount) sum(l_discount) avg(l_discount)
|
|
6001215 0.00 0.10 300057.33 0.049999
|
|
select count(l_tax), min(l_tax), max(l_tax) , sum(l_tax), avg(l_tax) from lineitem;
|
|
count(l_tax) min(l_tax) max(l_tax) sum(l_tax) avg(l_tax)
|
|
6001215 0.00 0.08 240129.67 0.040014
|
|
select count(l_returnflag), min(l_returnflag), max(l_returnflag) from lineitem;
|
|
count(l_returnflag) min(l_returnflag) max(l_returnflag)
|
|
6001215 A R
|
|
select count(l_linestatus), min(l_linestatus), max(l_linestatus) from lineitem;
|
|
count(l_linestatus) min(l_linestatus) max(l_linestatus)
|
|
6001215 F O
|
|
select count(l_shipdate), min(l_shipdate), max(l_shipdate) from lineitem;
|
|
count(l_shipdate) min(l_shipdate) max(l_shipdate)
|
|
6001215 1992-01-02 1998-12-01
|
|
select count(l_commitdate), min(l_commitdate), max(l_commitdate) from lineitem;
|
|
count(l_commitdate) min(l_commitdate) max(l_commitdate)
|
|
6001215 1992-01-31 1998-10-31
|
|
select count(l_receiptdate), min(l_receiptdate), max(l_receiptdate) from lineitem;
|
|
count(l_receiptdate) min(l_receiptdate) max(l_receiptdate)
|
|
6001215 1992-01-04 1998-12-31
|
|
select count(*) from lineitem;
|
|
count(*)
|
|
6001215
|
|
select count(o_orderkey), min(o_orderkey), max(o_orderkey) , sum(o_orderkey), avg(o_orderkey) from orders;
|
|
count(o_orderkey) min(o_orderkey) max(o_orderkey) sum(o_orderkey) avg(o_orderkey)
|
|
1500000 1 6000000 4499987250000 2999991.5000
|
|
select count(o_custkey), min(o_custkey), max(o_custkey) , sum(o_custkey), avg(o_custkey) from orders;
|
|
count(o_custkey) min(o_custkey) max(o_custkey) sum(o_custkey) avg(o_custkey)
|
|
1500000 1 149999 112509060862 75006.0406
|
|
select count(o_orderstatus), min(o_orderstatus), max(o_orderstatus) from orders;
|
|
count(o_orderstatus) min(o_orderstatus) max(o_orderstatus)
|
|
1500000 F P
|
|
select count(o_totalprice), min(o_totalprice), max(o_totalprice) , sum(o_totalprice), avg(o_totalprice) from orders;
|
|
count(o_totalprice) min(o_totalprice) max(o_totalprice) sum(o_totalprice) avg(o_totalprice)
|
|
1500000 857.71 555285.16 226829306447.46 151219.537632
|
|
select count(o_orderdate), min(o_orderdate), max(o_orderdate) from orders;
|
|
count(o_orderdate) min(o_orderdate) max(o_orderdate)
|
|
1500000 1992-01-01 1998-08-02
|
|
select count(o_orderpriority), min(o_orderpriority), max(o_orderpriority) from orders;
|
|
count(o_orderpriority) min(o_orderpriority) max(o_orderpriority)
|
|
1500000 1-URGENT 5-LOW
|
|
select count(o_clerk), min(o_clerk), max(o_clerk) from orders;
|
|
count(o_clerk) min(o_clerk) max(o_clerk)
|
|
1500000 Clerk#000000001 Clerk#000001000
|
|
select count(o_shippriority), min(o_shippriority), max(o_shippriority) from orders;
|
|
count(o_shippriority) min(o_shippriority) max(o_shippriority)
|
|
1500000 0 0
|
|
select count(o_comment), min(o_comment), max(o_comment) from orders;
|
|
count(o_comment) min(o_comment) max(o_comment)
|
|
1500000 about the accounts zzle? furiously ironic instructions among the unusual t
|
|
select count(*) from orders;
|
|
count(*)
|
|
1500000
|
|
select count(n_nationkey), min(n_nationkey), max(n_nationkey) , sum(n_nationkey), avg(n_nationkey) from nation;
|
|
count(n_nationkey) min(n_nationkey) max(n_nationkey) sum(n_nationkey) avg(n_nationkey)
|
|
25 0 24 300 12.0000
|
|
select count(n_name), min(n_name), max(n_name) from nation;
|
|
count(n_name) min(n_name) max(n_name)
|
|
25 ALGERIA VIETNAM
|
|
select count(n_regionkey), min(n_regionkey), max(n_regionkey) , sum(n_regionkey), avg(n_regionkey) from nation;
|
|
count(n_regionkey) min(n_regionkey) max(n_regionkey) sum(n_regionkey) avg(n_regionkey)
|
|
25 0 4 50 2.0000
|
|
select count(n_comment), min(n_comment), max(n_comment) from nation;
|
|
count(n_comment) min(n_comment) max(n_comment)
|
|
25 haggle. carefully final deposits detect slyly agai y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
|
|
select count(*) from nation;
|
|
count(*)
|
|
25
|
|
select count(r_regionkey), min(r_regionkey), max(r_regionkey) , sum(r_regionkey), avg(r_regionkey) from region;
|
|
count(r_regionkey) min(r_regionkey) max(r_regionkey) sum(r_regionkey) avg(r_regionkey)
|
|
5 0 4 10 2.0000
|
|
select count(r_name), min(r_name), max(r_name) from region;
|
|
count(r_name) min(r_name) max(r_name)
|
|
5 AFRICA MIDDLE EAST
|
|
select count(r_comment), min(r_comment), max(r_comment) from region;
|
|
count(r_comment) min(r_comment) max(r_comment)
|
|
5 ges. thinly even pinto beans ca uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
|
|
select count(*) from region;
|
|
count(*)
|
|
5
|
|
select count(c_custkey), min(c_custkey), max(c_custkey) , sum(c_custkey), avg(c_custkey) from customer;
|
|
count(c_custkey) min(c_custkey) max(c_custkey) sum(c_custkey) avg(c_custkey)
|
|
150000 1 150000 11250075000 75000.5000
|
|
select count(c_name), min(c_name), max(c_name) from customer;
|
|
count(c_name) min(c_name) max(c_name)
|
|
150000 Customer#000000001 Customer#000150000
|
|
select count(c_address), min(c_address), max(c_address) from customer;
|
|
count(c_address) min(c_address) max(c_address)
|
|
150000 2uZwVhQvwA zzZWJlpDD8eDh8BaXld7BMBX0w
|
|
select count(c_nationkey), min(c_nationkey), max(c_nationkey) , sum(c_nationkey), avg(c_nationkey) from customer;
|
|
count(c_nationkey) min(c_nationkey) max(c_nationkey) sum(c_nationkey) avg(c_nationkey)
|
|
150000 0 24 1801005 12.0067
|
|
select count(c_phone), min(c_phone), max(c_phone) from customer;
|
|
count(c_phone) min(c_phone) max(c_phone)
|
|
150000 10-100-106-1617 34-999-618-6881
|
|
select count(c_acctbal), min(c_acctbal), max(c_acctbal) , sum(c_acctbal), avg(c_acctbal) from customer;
|
|
count(c_acctbal) min(c_acctbal) max(c_acctbal) sum(c_acctbal) avg(c_acctbal)
|
|
150000 -999.99 9999.99 674326849.74 4495.512332
|
|
select count(c_mktsegment), min(c_mktsegment), max(c_mktsegment) from customer;
|
|
count(c_mktsegment) min(c_mktsegment) max(c_mktsegment)
|
|
150000 AUTOMOBILE MACHINERY
|
|
select count(c_comment), min(c_comment), max(c_comment) from customer;
|
|
count(c_comment) min(c_comment) max(c_comment)
|
|
150000 about the accounts nag slyly ironic theodolites. furiously i zzle. blithely regular instructions cajol
|
|
select count(*) from customer;
|
|
count(*)
|
|
150000
|
|
select count(s_suppkey), min(s_suppkey), max(s_suppkey) , sum(s_suppkey), avg(s_suppkey) from supplier;
|
|
count(s_suppkey) min(s_suppkey) max(s_suppkey) sum(s_suppkey) avg(s_suppkey)
|
|
10000 1 10000 50005000 5000.5000
|
|
select count(s_name), min(s_name), max(s_name) from supplier;
|
|
count(s_name) min(s_name) max(s_name)
|
|
10000 Supplier#000000001 Supplier#000010000
|
|
select count(s_address), min(s_address), max(s_address) from supplier;
|
|
count(s_address) min(s_address) max(s_address)
|
|
10000 9aW1wwnBJJPnCx,nox0MA48Y0zpI1IeVfYZ ZZZwPfP9X1xcLQ
|
|
select count(s_nationkey), min(s_nationkey), max(s_nationkey) , sum(s_nationkey), avg(s_nationkey) from supplier;
|
|
count(s_nationkey) min(s_nationkey) max(s_nationkey) sum(s_nationkey) avg(s_nationkey)
|
|
10000 0 24 119353 11.9353
|
|
select count(s_phone), min(s_phone), max(s_phone) from supplier;
|
|
count(s_phone) min(s_phone) max(s_phone)
|
|
10000 10-102-116-6785 34-998-900-4911
|
|
select count(s_acctbal), min(s_acctbal), max(s_acctbal) from supplier;
|
|
count(s_acctbal) min(s_acctbal) max(s_acctbal)
|
|
10000 -998.22 9999.72
|
|
select count(s_comment), min(s_comment), max(s_comment) from supplier;
|
|
count(s_comment) min(s_comment) max(s_comment)
|
|
10000 about the blithely express foxes. bli zzle furiously. bold accounts haggle furiously ironic excuses. fur
|
|
select count(*) from supplier;
|
|
count(*)
|
|
10000
|
|
select count(ps_partkey), min(ps_partkey), max(ps_partkey) , sum(ps_partkey), avg(ps_partkey) from partsupp;
|
|
count(ps_partkey) min(ps_partkey) max(ps_partkey) sum(ps_partkey) avg(ps_partkey)
|
|
800000 1 200000 80000400000 100000.5000
|
|
select count(ps_suppkey), min(ps_suppkey), max(ps_suppkey) , sum(ps_suppkey), avg(ps_suppkey) from partsupp;
|
|
count(ps_suppkey) min(ps_suppkey) max(ps_suppkey) sum(ps_suppkey) avg(ps_suppkey)
|
|
800000 1 10000 4000400000 5000.5000
|
|
select count(ps_availqty), min(ps_availqty), max(ps_availqty) , sum(ps_availqty), avg(ps_availqty) from partsupp;
|
|
count(ps_availqty) min(ps_availqty) max(ps_availqty) sum(ps_availqty) avg(ps_availqty)
|
|
800000 1 9999 4002581547 5003.2269
|
|
select count(ps_supplycost), min(ps_supplycost), max(ps_supplycost) , sum(ps_supplycost), avg(ps_supplycost) from partsupp;
|
|
count(ps_supplycost) min(ps_supplycost) max(ps_supplycost) sum(ps_supplycost) avg(ps_supplycost)
|
|
800000 1.00 1000.00 400420638.54 500.525798
|
|
select count(ps_comment), min(ps_comment), max(ps_comment) from partsupp;
|
|
count(ps_comment) min(ps_comment) max(ps_comment)
|
|
800000 about the accounts are furiously slyly pending escapades. fluffily pending packages sublate quickly carefully final dependencies. regular ideas maint zzle. unusual decoys detect slyly blithely express frays. furiously ironic packages about the bold accounts are close requests. slowly silent reque
|
|
select count(*) from partsupp;
|
|
count(*)
|
|
800000
|
|
select count(p_partkey), min(p_partkey), max(p_partkey) , sum(p_partkey), avg(p_partkey) from part;
|
|
count(p_partkey) min(p_partkey) max(p_partkey) sum(p_partkey) avg(p_partkey)
|
|
200000 1 200000 20000100000 100000.5000
|
|
select count(p_name), min(p_name), max(p_name) from part;
|
|
count(p_name) min(p_name) max(p_name)
|
|
200000 almond antique blue royal burnished yellow white seashell lavender black
|
|
select count(p_mfgr), min(p_mfgr), max(p_mfgr) from part;
|
|
count(p_mfgr) min(p_mfgr) max(p_mfgr)
|
|
200000 Manufacturer#1 Manufacturer#5
|
|
select count(p_brand), min(p_brand), max(p_brand) from part;
|
|
count(p_brand) min(p_brand) max(p_brand)
|
|
200000 Brand#11 Brand#55
|
|
select count(p_type), min(p_type), max(p_type) from part;
|
|
count(p_type) min(p_type) max(p_type)
|
|
200000 ECONOMY ANODIZED BRASS STANDARD POLISHED TIN
|
|
select count(p_size), min(p_size), max(p_size) , sum(p_size), avg(p_size) from part;
|
|
count(p_size) min(p_size) max(p_size) sum(p_size) avg(p_size)
|
|
200000 1 50 5085421 25.4271
|
|
select count(p_container), min(p_container), max(p_container) from part;
|
|
count(p_container) min(p_container) max(p_container)
|
|
200000 JUMBO BAG WRAP PKG
|
|
select count(p_retailprice), min(p_retailprice), max(p_retailprice) , sum(p_retailprice), avg(p_retailprice) from part;
|
|
count(p_retailprice) min(p_retailprice) max(p_retailprice) sum(p_retailprice) avg(p_retailprice)
|
|
200000 901.00 2098.99 299899200.00 1499.496000
|
|
select count(p_comment), min(p_comment), max(p_comment) from part;
|
|
count(p_comment) min(p_comment) max(p_comment)
|
|
200000 abou zzle. quickly si
|
|
select count(*) from part;
|
|
count(*)
|
|
200000
|
|
select count(l_shipinstruct), min(l_shipinstruct), max(l_shipinstruct) from lineitem;
|
|
count(l_shipinstruct) min(l_shipinstruct) max(l_shipinstruct)
|
|
6001215 COLLECT COD TAKE BACK RETURN
|
|
select count(l_shipmode), min(l_shipmode), max(l_shipmode) from lineitem;
|
|
count(l_shipmode) min(l_shipmode) max(l_shipmode)
|
|
6001215 AIR TRUCK
|
|
select count(l_comment), min(l_comment), max(l_comment) from lineitem;
|
|
count(l_comment) min(l_comment) max(l_comment)
|
|
6001215 about the zzle? slyly final platelets sleep quickly.
|