Fix tpch pg queries, make they as yql ones (#11782)

5 files changed, 6 insertions, 6 deletions

diff --git a/ydb/library/benchmarks/queries/tpch/pg/q15.sql b/ydb/library/benchmarks/queries/tpch/pg/q15.sql
index 3b78d4dcde..f0162ecd85 100644
--- a/ydb/library/benchmarks/queries/tpch/pg/q15.sql
+++ b/ydb/library/benchmarks/queries/tpch/pg/q15.sql
@@ -12,7 +12,7 @@ create view revenue0 (supplier_no, total_revenue) as
         {{lineitem}}
     where
         l_shipdate >= date '1996-01-01'
-        and l_shipdate < date '1995-01-01' + interval '3' month
+        and l_shipdate < date '1996-01-01' + interval '3' month
     group by
         l_suppkey;
 
diff --git a/ydb/library/benchmarks/queries/tpch/pg/q2.sql b/ydb/library/benchmarks/queries/tpch/pg/q2.sql
index 0c836cec0d..3242ab2ef0 100644
--- a/ydb/library/benchmarks/queries/tpch/pg/q2.sql
+++ b/ydb/library/benchmarks/queries/tpch/pg/q2.sql
@@ -22,7 +22,7 @@ from
 where
     p_partkey = ps_partkey
     and s_suppkey = ps_suppkey
-    and p_size = 10
+    and p_size = 15
     and p_type like '%BRASS'
     and s_nationkey = n_nationkey
     and n_regionkey = r_regionkey
diff --git a/ydb/library/benchmarks/queries/tpch/pg/q22.sql b/ydb/library/benchmarks/queries/tpch/pg/q22.sql
index 9d45bacd7b..e599fa3ebb 100644
--- a/ydb/library/benchmarks/queries/tpch/pg/q22.sql
+++ b/ydb/library/benchmarks/queries/tpch/pg/q22.sql
@@ -17,7 +17,7 @@ from
             {{customer}}
         where
             substring(c_phone from 1 for 2) in
-                ('13', '31', '23', '29', '30', '28', '17')
+                ('13', '31', '23', '29', '30', '18', '17')
             and c_acctbal > (
                 select
                     avg(c_acctbal)
@@ -26,7 +26,7 @@ from
                 where
                     c_acctbal > 0.00
                     and substring(c_phone from 1 for 2) in
-                        ('13', '31', '23', '29', '30', '28', '17')
+                        ('13', '31', '23', '29', '30', '18', '17')
             )
             and not exists (
                 select
diff --git a/ydb/library/benchmarks/queries/tpch/pg/q6.sql b/ydb/library/benchmarks/queries/tpch/pg/q6.sql
index 344019a6ef..4d80475be8 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 '1994-01-01'
     and l_shipdate < date '1994-01-01' + interval '1' year
-    and l_discount between 0.01 - 0.0100001 and 0.01 + 0.0100001
+    and l_discount between 0.06 - 0.0100001 and 0.06 + 0.0100001
     and l_quantity < 24;
diff --git a/ydb/library/benchmarks/queries/tpch/yql/q10.sql b/ydb/library/benchmarks/queries/tpch/yql/q10.sql
index 70ae181188..2dbfa23b0b 100644
--- a/ydb/library/benchmarks/queries/tpch/yql/q10.sql
+++ b/ydb/library/benchmarks/queries/tpch/yql/q10.sql
@@ -23,7 +23,7 @@ on
     c.c_custkey = o.o_custkey
 where
     o.o_orderdate >= $border
-    and o.o_orderdate < ($border + Interval("P90D"))
+    and o.o_orderdate < ($border + Interval("P92D"))
 );
 $join2 = (
 select