Fix tpcds q44 (#14744)

6 files changed, 26 insertions, 4 deletions

diff --git a/ydb/library/benchmarks/queries/tpcds/pg/q44.sql b/ydb/library/benchmarks/queries/tpcds/pg/q44.sql
index f6ea8a4acf..1f31395472 100644
--- a/ydb/library/benchmarks/queries/tpcds/pg/q44.sql
+++ b/ydb/library/benchmarks/queries/tpcds/pg/q44.sql
@@ -30,7 +30,7 @@ from(select *
 where asceding.rnk = descending.rnk
   and i1.i_item_sk=asceding.item_sk
   and i2.i_item_sk=descending.item_sk
-order by asceding.rnk
+order by asceding.rnk, best_performing, worst_performing
 limit 100;
 
 -- end query 1 in stream 0 using template ../query_templates/query44.tpl
diff --git a/ydb/library/benchmarks/queries/tpcds/yql/q44.sql b/ydb/library/benchmarks/queries/tpcds/yql/q44.sql
index 74d6925111..5a1b0fd2c7 100644
--- a/ydb/library/benchmarks/queries/tpcds/yql/q44.sql
+++ b/ydb/library/benchmarks/queries/tpcds/yql/q44.sql
@@ -11,7 +11,7 @@ $avg_net_profit = (select avg(ss_net_profit) rank_col
 select  asceding.rnk, i1.i_product_name best_performing, i2.i_product_name worst_performing
 from(select *
      from (select item_sk,rank() over (order by rank_col asc) rnk
-           from (select ss_item_sk item_sk,$round(avg(ss_net_profit), -2) rank_col
+           from (select ss_item_sk item_sk, $round(avg(ss_net_profit), -2) rank_col
                  from {{store_sales}} ss1
                  where ss_store_sk = 4
                  group by ss_item_sk
@@ -20,7 +20,7 @@ from(select *
      cross join
     (select *
      from (select item_sk,rank() over (order by rank_col desc) rnk
-           from (select ss_item_sk item_sk,$round(avg(ss_net_profit), -2) rank_col
+           from (select ss_item_sk item_sk, $round(avg(ss_net_profit), -2) rank_col
                  from {{store_sales}} ss1
                  where ss_store_sk = 4
                  group by ss_item_sk
@@ -32,7 +32,7 @@ from(select *
 where asceding.rnk = descending.rnk
   and i1.i_item_sk=asceding.item_sk
   and i2.i_item_sk=descending.item_sk
-order by asceding.rnk
+order by asceding.rnk, best_performing, worst_performing
 limit 100;
 
 -- end query 1 in stream 0 using template query44.tpl
diff --git a/ydb/library/workload/tpcds/s100_canonical/q44.result b/ydb/library/workload/tpcds/s100_canonical/q44.result
new file mode 100644
index 0000000000..67ea2ca669
--- /dev/null
+++ b/ydb/library/workload/tpcds/s100_canonical/q44.result
@@ -0,0 +1,11 @@
+asceding.rnk,best_performing,worst_performing
+1,"ablen stationesepri","pricallyantiation"
+1,"barableoughtcallyought","pricallyantiation"
+3,"ablecallyeingbarn stought","esen stbarablen st"
+3,"oughtationationcallyoughtought","esen stbarablen st"
+5,"n stantiationanti","barn steingableeseought"
+6,"ationantibarantieingought","barationantieingation"
+6,"eingn stationn stable","barationantieingation"
+8,"antiprieingantically","eseoughtpriationpri"
+8,"ationantioughteseanti","eseoughtpriationpri"
+8,"oughtn stationeseought","eseoughtpriationpri"
diff --git a/ydb/library/workload/tpcds/s100_canonical/q44.result.gz b/ydb/library/workload/tpcds/s100_canonical/q44.result.gz
deleted file mode 100644
index 6a5b3ab64d..0000000000
--- a/ydb/library/workload/tpcds/s100_canonical/q44.result.gz
+++ /dev/null
diff --git a/ydb/library/workload/tpcds/s10_canonical/q44.result b/ydb/library/workload/tpcds/s10_canonical/q44.result
new file mode 100644
index 0000000000..0665033493
--- /dev/null
+++ b/ydb/library/workload/tpcds/s10_canonical/q44.result
@@ -0,0 +1,11 @@
+asceding.rnk,best_performing,worst_performing
+1,"prieingantibarese","ableationcallyese"
+2,"ationcallyn steseanti","eingcallyn stantianti"
+3,"oughtantiesecallyn st","priableeingbaranti"
+3,"oughtoughtableoughtpri","priableeingbaranti"
+5,"antibarationbarought","oughtbarn stcallyese"
+6,"ationn stablecallyese","callyablen stantieing"
+6,"n stationoughtcallyation","callyablen stantieing"
+8,"ableationationcallycally","ablecallypriantieing"
+8,"oughtn stbaroughtn st","ablecallypriantieing"
+10,"oughtcallyprioughteing","eingableoughtoughtese"
diff --git a/ydb/library/workload/tpcds/s10_canonical/q44.result.gz b/ydb/library/workload/tpcds/s10_canonical/q44.result.gz
deleted file mode 100644
index 06931053ae..0000000000
--- a/ydb/library/workload/tpcds/s10_canonical/q44.result.gz
+++ /dev/null