diff options
| author | aozeritsky <aozeritsky@ydb.tech> | 2023-10-11 12:38:23 +0300 |
|---|---|---|
| committer | aozeritsky <aozeritsky@ydb.tech> | 2023-10-11 13:15:32 +0300 |
| commit | 62e430b2b3432e4cc638478a9adc56bf739ed1b7 (patch) | |
| tree | 3bec18a2e2072691be17401648e8220a1c76654b | |
| parent | 09839d439eb4e55a50ef8fc41db6e2bc22efd721 (diff) | |
| download | ydb-62e430b2b3432e4cc638478a9adc56bf739ed1b7.tar.gz | |
Adjust l_discount range
| -rw-r--r-- | ydb/library/benchmarks/queries/tpch/pg/q6.sql | 2 | ||||
| -rw-r--r-- | ydb/library/benchmarks/queries/tpch/yql/q6.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/ydb/library/benchmarks/queries/tpch/pg/q6.sql b/ydb/library/benchmarks/queries/tpch/pg/q6.sql index 3d1fea8a129..a55ea1d4ff4 100644 --- a/ydb/library/benchmarks/queries/tpch/pg/q6.sql +++ b/ydb/library/benchmarks/queries/tpch/pg/q6.sql @@ -12,5 +12,5 @@ from where l_shipdate >= date '1995-01-01' and l_shipdate < date '1995-01-01' + interval '1' year - and l_discount between 0.07::numeric - 0.01::numeric and 0.07::numeric + 0.01::numeric + and l_discount between 0.07::numeric - 0.0100001::numeric and 0.07::numeric + 0.0100001::numeric and l_quantity < 25::numeric; diff --git a/ydb/library/benchmarks/queries/tpch/yql/q6.sql b/ydb/library/benchmarks/queries/tpch/yql/q6.sql index 38a07b7124f..0b8ee807ca0 100644 --- a/ydb/library/benchmarks/queries/tpch/yql/q6.sql +++ b/ydb/library/benchmarks/queries/tpch/yql/q6.sql @@ -13,5 +13,5 @@ from where CAST(l_shipdate AS Timestamp) >= $border and cast(l_shipdate as Timestamp) < ($border + Interval("P365D")) - and l_discount between 0.07 - 0.01 and 0.07 + 0.01 + and l_discount between 0.07 - 0.0100001 and 0.07 + 0.0100001 and l_quantity < 25; |