Changeset: 60d7fad87f3a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=60d7fad87f3a
Modified Files:
sql/benchmarks/tpch/14.sql
Branch: Apr2019
Log Message:
Adapt TPC-H query 14.sql in testweb to avoid error "!Too many digits (19 > 18)"
on architectures which do not support decimals with more than 18 digits
precision (such as MSVC Windows and --disable-int128 builts).
diffs (15 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,8 +1,10 @@
-- using default substitutions
+-- Adapted orignal query in testweb. Replaced 100.00 by 100.0 to avoid error
"!Too many digits (19 > 18)" on architectures
+-- which do not support decimals with more than 18 digits precision (such as
MSVC Windows and --disable-int128 builts).
select
- 100.00 * sum(case
+ 100.0 * sum(case
when p_type like 'PROMO%'
then l_extendedprice * (1 - l_discount)
else 0
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
