Changeset: 65cebb41a05b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/65cebb41a05b
Modified Files:
sql/benchmarks/tpch/Tests/q14.test
sql/benchmarks/tpch/Tests/q15.test
Branch: Mar2025
Log Message:
move view creation into q15
diffs (42 lines):
diff --git a/sql/benchmarks/tpch/Tests/q14.test
b/sql/benchmarks/tpch/Tests/q14.test
--- a/sql/benchmarks/tpch/Tests/q14.test
+++ b/sql/benchmarks/tpch/Tests/q14.test
@@ -15,17 +15,3 @@ where
and l_shipdate < date '1995-09-01' + interval '1' month
----
15.487
-
-statement ok
-create view revenue0 (supplier_no, total_revenue) as
- select
- l_suppkey,
- sum(l_extendedprice * (1 - l_discount))
- from
- lineitem
- where
- l_shipdate >= date '1996-01-01'
- and l_shipdate < date '1996-01-01' + interval '3' month
- group by
- l_suppkey
-
diff --git a/sql/benchmarks/tpch/Tests/q15.test
b/sql/benchmarks/tpch/Tests/q15.test
--- a/sql/benchmarks/tpch/Tests/q15.test
+++ b/sql/benchmarks/tpch/Tests/q15.test
@@ -1,4 +1,17 @@
#Q15
+statement ok
+create view revenue0 (supplier_no, total_revenue) as
+ select
+ l_suppkey,
+ sum(l_extendedprice * (1 - l_discount))
+ from
+ lineitem
+ where
+ l_shipdate >= date '1996-01-01'
+ and l_shipdate < date '1996-01-01' + interval '3' month
+ group by
+ l_suppkey
+
query ITTTR nosort
select
s_suppkey,
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
