Changeset: 1b4de2cabe57 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1b4de2cabe57
Added Files:
sql/benchmarks/tpch/Tests/compress.test
sql/benchmarks/tpch/Tests/create.test
sql/benchmarks/tpch/Tests/load.test
sql/benchmarks/tpch/Tests/q1.test
sql/benchmarks/tpch/Tests/q10.test
sql/benchmarks/tpch/Tests/q11.test
sql/benchmarks/tpch/Tests/q12.test
sql/benchmarks/tpch/Tests/q13.test
sql/benchmarks/tpch/Tests/q14.test
sql/benchmarks/tpch/Tests/q15.test
sql/benchmarks/tpch/Tests/q16.test
sql/benchmarks/tpch/Tests/q17.test
sql/benchmarks/tpch/Tests/q18.test
sql/benchmarks/tpch/Tests/q19.test
sql/benchmarks/tpch/Tests/q2.test
sql/benchmarks/tpch/Tests/q20.test
sql/benchmarks/tpch/Tests/q21.test
sql/benchmarks/tpch/Tests/q22.test
sql/benchmarks/tpch/Tests/q3.test
sql/benchmarks/tpch/Tests/q4.test
sql/benchmarks/tpch/Tests/q5.test
sql/benchmarks/tpch/Tests/q6.test
sql/benchmarks/tpch/Tests/q7.test
sql/benchmarks/tpch/Tests/q8.test
sql/benchmarks/tpch/Tests/q9.test
sql/benchmarks/tpch/Tests/rest.test
Removed Files:
sql/benchmarks/tpch/Tests/one.test
Modified Files:
sql/benchmarks/tpch/Tests/All
sql/benchmarks/tpch/Tests/SingleServer
testing/Mtest.py.in
Branch: Aug2024
Log Message:
If SingleServer contains option "nodrop" don't drop anything between tests.
diffs (truncated from 3794 to 300 lines):
diff --git a/sql/benchmarks/tpch/Tests/All b/sql/benchmarks/tpch/Tests/All
--- a/sql/benchmarks/tpch/Tests/All
+++ b/sql/benchmarks/tpch/Tests/All
@@ -1,1 +1,26 @@
-one
+create
+load
+compress
+q1
+q2
+q3
+q4
+q5
+q6
+q7
+q8
+q9
+q10
+q11
+q12
+q13
+q14
+q15
+q16
+q17
+q18
+q19
+q20
+q21
+q22
+rest
diff --git a/sql/benchmarks/tpch/Tests/SingleServer
b/sql/benchmarks/tpch/Tests/SingleServer
--- a/sql/benchmarks/tpch/Tests/SingleServer
+++ b/sql/benchmarks/tpch/Tests/SingleServer
@@ -0,0 +1,1 @@
+nodrop
diff --git a/sql/benchmarks/tpch/Tests/compress.test
b/sql/benchmarks/tpch/Tests/compress.test
new file mode 100644
--- /dev/null
+++ b/sql/benchmarks/tpch/Tests/compress.test
@@ -0,0 +1,522 @@
+statement ok
+create procedure sys.dict_compress( sname string, tname string, cname string,
ordered_values bool) external name dict.compress
+
+statement ok
+create procedure sys.for_compress( sname string, tname string, cname string)
external name "for".compress
+
+statement ok
+call dict_compress('sys', 'region', 'r_regionkey', true)
+
+statement ok
+call dict_compress('sys', 'nation', 'n_nationkey', true)
+
+statement ok
+call dict_compress('sys', 'nation', 'n_regionkey', true)
+
+statement ok
+call dict_compress('sys', 'supplier', 's_nationkey', true)
+
+statement ok
+call dict_compress('sys', 'customer', 'c_nationkey', true)
+
+statement ok
+call dict_compress('sys', 'customer', 'c_mktsegment', true)
+
+statement ok
+call dict_compress('sys', 'part', 'p_mfgr', true)
+
+statement ok
+call dict_compress('sys', 'part', 'p_brand', true)
+
+statement ok
+call dict_compress('sys', 'part', 'p_type', true)
+
+statement ok
+call dict_compress('sys', 'part', 'p_size', true)
+
+statement ok
+call dict_compress('sys', 'part', 'p_container', true)
+
+statement ok
+call dict_compress('sys', 'part', 'p_retailprice', true)
+
+statement ok
+call dict_compress('sys', 'partsupp', 'ps_availqty', true)
+
+statement ok
+call dict_compress('sys', 'orders', 'o_orderstatus', true)
+
+statement ok
+call dict_compress('sys', 'orders', 'o_orderdate', true)
+
+statement ok
+call dict_compress('sys', 'orders', 'o_orderpriority', true)
+
+statement ok
+call dict_compress('sys', 'orders', 'o_clerk', true)
+
+statement ok
+call dict_compress('sys', 'orders', 'o_shippriority', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_linenumber', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_quantity', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_discount', true)
+
+# testing l_tax now with for compression.
+# not dict call dict_compress('sys', 'lineitem', 'l_tax', true);
+#
+statement ok
+call for_compress('sys', 'lineitem', 'l_tax')
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_returnflag', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_linestatus', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_shipdate', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_commitdate', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_shipinstruct', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_receiptdate', true)
+
+statement ok
+call dict_compress('sys', 'lineitem', 'l_shipmode', true)
+
+query ITT nosort
+select * from region order by r_regionkey limit 9
+----
+0
+AFRICA
+lar deposits. blithely final packages cajole. regular waters are final
requests. regular accounts are according to
+1
+AMERICA
+hs use ironic, even requests. s
+2
+ASIA
+ges. thinly even pinto beans ca
+3
+EUROPE
+ly final courts cajole furiously final excuse
+4
+MIDDLE EAST
+uickly special accounts cajole carefully blithely close requests. carefully
final asymptotes haggle furiousl
+
+query ITIT nosort
+select * from nation order by n_nationkey limit 9
+----
+0
+ALGERIA
+0
+ haggle. carefully final deposits detect slyly agai
+1
+ARGENTINA
+1
+al foxes promise slyly according to the regular accounts. bold requests alon
+2
+BRAZIL
+1
+y alongside of the pending deposits. carefully special packages are about the
ironic forges. slyly special
+3
+CANADA
+1
+eas hang ironic, silent packages. slyly regular packages are furiously over
the tithes. fluffily bold
+4
+EGYPT
+4
+y above the carefully unusual theodolites. final dugouts are quickly across
the furiously regular d
+5
+ETHIOPIA
+0
+ven packages wake quickly. regu
+6
+FRANCE
+3
+refully final requests. regular, ironi
+7
+GERMANY
+3
+l platelets. regular accounts x-ray: unusual, regular acco
+8
+INDIA
+2
+ss excuses cajole slyly across the packages. deposits print aroun
+
+query ITTITRT nosort
+select * from supplier order by s_suppkey limit 9
+----
+1
+Supplier#000000001
+ N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ
+17
+27-918-335-1736
+5755.940
+each slyly above the careful
+2
+Supplier#000000002
+89eJ5ksX3ImxJQBvxObC,
+5
+15-679-861-2259
+4032.680
+ slyly bold instructions. idle dependen
+3
+Supplier#000000003
+q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3
+1
+11-383-516-1199
+4192.400
+blithely silent requests after the express dependencies are sl
+4
+Supplier#000000004
+Bk7ah4CK8SYQTepEmvMkkgMwg
+15
+25-843-787-7479
+4641.080
+riously even requests above the exp
+5
+Supplier#000000005
+Gcdm2rJRzl5qlTVzc
+11
+21-151-690-3663
+-283.840
+. slyly regular pinto bea
+6
+Supplier#000000006
+tQxuVm7s7CnK
+14
+24-696-997-4969
+1365.790
+final accounts. regular dolphins use against the furiously ironic decoys.
+7
+Supplier#000000007
+s,4TicNGB4uO6PaSqNBUq
+23
+33-990-965-2201
+6820.350
+s unwind silently furiously regular courts. final requests are deposits.
requests wake quietly blit
+8
+Supplier#000000008
+9Sq4bBH2FQEmaFOocY45sRTxo6yuoG
+17
+27-498-742-3860
+7627.850
+al pinto beans. asymptotes haggl
+9
+Supplier#000000009
+1KhUgZegwM3ua7dsYmekYBsK
+10
+20-403-398-8662
+5302.370
+s. unusual, even requests along the furiously regular pac
+
+query ITTITRTT nosort
+select * from customer order by c_custkey limit 9
+----
+1
+Customer#000000001
+IVhzIApeRb ot,c,E
+15
+25-989-741-2988
+711.560
+BUILDING
+to the even, regular platelets. regular, ironic epitaphs nag e
+2
+Customer#000000002
+XSTf4,NCwDVaWNe6tEgvwfmRchLXak
+13
+23-768-687-3665
+121.650
+AUTOMOBILE
+l accounts. blithely ironic theodolites integrate boldly: caref
+3
+Customer#000000003
+MG9kdTD2WBHm
+1
+11-719-748-3364
+7498.120
+AUTOMOBILE
+ deposits eat slyly ironic, even instructions. express foxes detect slyly.
blithely even accounts abov
+4
+Customer#000000004
+XxVSJsLAGtn
+4
+14-128-190-5944
+2866.830
+MACHINERY
+ requests. final, regular ideas sleep final accou
+5
+Customer#000000005
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
