Changeset: ea5d058d21e6 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ea5d058d21e6 Modified Files: sql/benchmarks/tpch/14.sql Branch: Oct2014 Log Message:
TPCH, Q14: restoring query formatting as before changeset 8acd025b3ee1 this query formatting, or at least the "select" on a line of its own, is required by the plan.SQL.py & explain.SQL.py scripts to correctly run the *-plan & *-explain tests. diffs (20 lines): diff --git a/sql/benchmarks/tpch/14.sql b/sql/benchmarks/tpch/14.sql --- a/sql/benchmarks/tpch/14.sql +++ b/sql/benchmarks/tpch/14.sql @@ -1,3 +1,15 @@ -select 100.00 * sum(case when p_type like 'PROMO%' then l_extendedprice * (1 - l_discount) else 0 end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue from lineitem, part where l_partkey = p_partkey and l_shipdate >= date '1995-09-01' and l_shipdate < date '1995-09-01' + interval '1' month; +select + 100.00 * sum(case + when p_type like 'PROMO%' + then l_extendedprice * (1 - l_discount) + else 0 + end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue +from + lineitem, + part +where + l_partkey = p_partkey + and l_shipdate >= date '1995-09-01' + and l_shipdate < date '1995-09-01' + interval '1' month; select * from optimizer_stats() stats; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
