Changeset: 18adbf538be1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/18adbf538be1
Modified Files:
sql/benchmarks/tpch/Tests/q13a.test
Branch: Mar2025
Log Message:
Split three queries into three separate pieces.
diffs (38 lines):
diff --git a/sql/benchmarks/tpch/Tests/q13a.test
b/sql/benchmarks/tpch/Tests/q13a.test
--- a/sql/benchmarks/tpch/Tests/q13a.test
+++ b/sql/benchmarks/tpch/Tests/q13a.test
@@ -1,5 +1,5 @@
#Q13a
-query II rowsort
+statement ok
create view orders_per_cust0 (custkey, ordercount) as
select
c_custkey,
@@ -9,7 +9,9 @@ create view orders_per_cust0 (custkey, o
c_custkey = o_custkey
and o_comment not like '%special%requests%'
group by
- c_custkey;
+ c_custkey
+
+query II rowsort
select
ordercount,
count(*) as custdist
@@ -19,8 +21,7 @@ group by
ordercount
order by
custdist desc,
- ordercount desc;
-drop view orders_per_cust0
+ ordercount desc
----
0
500
@@ -89,3 +90,6 @@ 61
9
62
+statement ok
+drop view orders_per_cust0
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
