Support of nulls first/last (#2365)

46 files changed, 994 insertions, 812 deletions

diff --git a/ydb/library/yql/core/common_opt/yql_co_pgselect.cpp b/ydb/library/yql/core/common_opt/yql_co_pgselect.cpp
index a4dc45a695e..9ca107d5123 100644
--- a/ydb/library/yql/core/common_opt/yql_co_pgselect.cpp
+++ b/ydb/library/yql/core/common_opt/yql_co_pgselect.cpp
@@ -2262,66 +2262,57 @@ std::tuple<TExprNode::TPtr, TExprNode::TPtr> BuildFrame(TPositionHandle pos, con
 
 TExprNode::TPtr BuildSortTraits(TPositionHandle pos, const TExprNode& sortColumns, const TExprNode::TPtr& list,
     const TAggregationMap* aggId, TExprContext& ctx, TOptimizeContext& optCtx) {
-    if (sortColumns.ChildrenSize() == 1) {
-        auto lambda = sortColumns.Head().ChildPtr(1);
-        if (aggId) {
-            RewriteAggs(lambda, *aggId, ctx, optCtx, false);
-        }
-
-        return ctx.Builder(pos)
-            .Callable("SortTraits")
-                .Callable(0, "TypeOf")
-                    .Add(0, list)
-                .Seal()
-                .Callable(1, "Bool")
-                    .Atom(0, sortColumns.Head().Tail().Content() == "asc" ? "true" : "false")
-                .Seal()
-                .Lambda(2)
-                    .Param("row")
-                    .Apply(lambda)
-                        .With(0, "row")
-                    .Seal()
-                .Seal()
+    return ctx.Builder(pos)
+        .Callable("SortTraits")
+            .Callable(0, "TypeOf")
+                .Add(0, list)
             .Seal()
-            .Build();
-    } else {
-        return ctx.Builder(pos)
-            .Callable("SortTraits")
-                .Callable(0, "TypeOf")
-                    .Add(0, list)
-                .Seal()
-                .List(1)
+            .List(1)
+                .Do([&](TExprNodeBuilder& parent) -> TExprNodeBuilder& {
+                    for (ui32 i = 0; i < sortColumns.ChildrenSize(); ++i) {
+                        parent.Callable(i, "Bool")
+                            .Atom(0, sortColumns.Child(i)->Child(2)->Content() == "asc" ? "true" : "false")
+                            .Seal();
+                    }
+                    return parent;
+                })
+            .Seal()
+            .Lambda(2)
+                .Param("row")
+                .List()
                     .Do([&](TExprNodeBuilder& parent) -> TExprNodeBuilder& {
                         for (ui32 i = 0; i < sortColumns.ChildrenSize(); ++i) {
-                            parent.Callable(i, "Bool")
-                                .Atom(0, sortColumns.Child(i)->Tail().Content() == "asc" ? "true" : "false")
-                                .Seal();
-                        }
-                        return parent;
-                    })
-                .Seal()
-                .Lambda(2)
-                    .Param("row")
-                    .List()
-                        .Do([&](TExprNodeBuilder& parent) -> TExprNodeBuilder& {
-                            for (ui32 i = 0; i < sortColumns.ChildrenSize(); ++i) {
-                                auto lambda = sortColumns.Child(i)->ChildPtr(1);
-                                if (aggId) {
-                                    RewriteAggs(lambda, *aggId, ctx, optCtx, false);
-                                }
+                            auto lambda = sortColumns.Child(i)->ChildPtr(1);
+                            if (aggId) {
+                                RewriteAggs(lambda, *aggId, ctx, optCtx, false);
+                            }
 
+                            if (sortColumns.Child(i)->ChildPtr(3)->Content() == "last") {
+                                parent.List(i)
+                                    .Callable(0, "Not")
+                                        .Callable(0, "Exists")
+                                            .Apply(0, lambda)
+                                                .With(0, "row")
+                                            .Seal()
+                                        .Seal()
+                                    .Seal()
+                                    .Apply(1, lambda)
+                                        .With(0, "row")
+                                    .Seal()
+                                .Seal();
+                            } else {
                                 parent.Apply(i, lambda)
                                     .With(0, "row")
                                     .Seal();
                             }
+                        }
 
-                            return parent;
-                        })
-                    .Seal()
+                        return parent;
+                    })
                 .Seal()
             .Seal()
-            .Build();
-    }
+        .Seal()
+        .Build();
 }
 
 TExprNode::TPtr BuildWindows(TPositionHandle pos, const TExprNode::TPtr& list, const TExprNode::TPtr& window, const TWindowsCtx& winCtx,
@@ -2603,7 +2594,21 @@ TExprNode::TPtr BuildSortLambda(TPositionHandle pos, const TExprNode::TPtr& sort
     const auto& keys = sort->Tail();
     for (const auto& key : keys.Children()) {
         auto keyLambda = key->ChildPtr(1);
-        rootItems.push_back(ctx.ReplaceNode(keyLambda->TailPtr(), keyLambda->Head().Head(), argNode));
+        auto value = ctx.ReplaceNode(keyLambda->TailPtr(), keyLambda->Head().Head(), argNode);
+        if (key->Child(3)->Content() == "last") {
+            rootItems.push_back(ctx.Builder(pos)
+                .List()
+                    .Callable(0, "Not")
+                        .Callable(0, "Exists")
+                            .Add(0, value)
+                        .Seal()
+                    .Seal()
+                    .Add(1, value)
+                .Seal()
+                .Build());
+        } else {
+            rootItems.push_back(value);
+        }
     }
 
     auto root = ctx.NewList(pos, std::move(rootItems));
@@ -2619,7 +2624,7 @@ TExprNode::TPtr BuildSort(TPositionHandle pos, const TExprNode::TPtr& sort, cons
     for (const auto& key : keys.Children()) {
         dirItems.push_back(ctx.Builder(pos)
             .Callable("Bool")
-                .Atom(0, key->Tail().Content() == "asc" ? "true" : "false")
+                .Atom(0, key->Child(2)->Content() == "asc" ? "true" : "false")
             .Seal()
             .Build());
     }
diff --git a/ydb/library/yql/core/type_ann/type_ann_pg.cpp b/ydb/library/yql/core/type_ann/type_ann_pg.cpp
index 46a5c47385e..ddd8c2ca6ef 100644
--- a/ydb/library/yql/core/type_ann/type_ann_pg.cpp
+++ b/ydb/library/yql/core/type_ann/type_ann_pg.cpp
@@ -994,7 +994,7 @@ IGraphTransformer::TStatus PgWhereWrapper(const TExprNode::TPtr& input, TExprNod
 
 IGraphTransformer::TStatus PgSortWrapper(const TExprNode::TPtr& input, TExprNode::TPtr& output, TContext& ctx) {
     Y_UNUSED(output);
-    if (!EnsureArgsCount(*input, 3, ctx.Expr)) {
+    if (!EnsureArgsCount(*input, 4, ctx.Expr)) {
         return IGraphTransformer::TStatus::Error;
     }
 
@@ -1008,6 +1008,16 @@ IGraphTransformer::TStatus PgSortWrapper(const TExprNode::TPtr& input, TExprNode
         return IGraphTransformer::TStatus::Error;
     }
 
+    if (!EnsureAtom(*input->Child(3), ctx.Expr)) {
+        return IGraphTransformer::TStatus::Error;
+    }
+
+    if (input->Child(3)->Content() != "first" && input->Child(3)->Content() != "last") {
+        ctx.Expr.AddError(TIssue(ctx.Expr.GetPosition(input->Child(3)->Pos()),
+            TStringBuilder() << "Unsupported nulls ordering: " << input->Child(3)->Content()));
+        return IGraphTransformer::TStatus::Error;
+    }
+
     bool hasType = false;
     if (!input->Child(0)->IsCallable("Void")) {
         hasType = true;
diff --git a/ydb/library/yql/sql/pg/pg_sql.cpp b/ydb/library/yql/sql/pg/pg_sql.cpp
index 0396074ae11..084e4f8bf7b 100644
--- a/ydb/library/yql/sql/pg/pg_sql.cpp
+++ b/ydb/library/yql/sql/pg/pg_sql.cpp
@@ -4009,10 +4009,13 @@ public:
     TAstNode* ParseSortBy(const PG_SortBy* value, bool allowAggregates, bool useProjectionRefs) {
         AT_LOCATION(value);
         bool asc = true;
+        bool nullsFirst = true;
         switch (value->sortby_dir) {
         case SORTBY_DEFAULT:
-            break;
         case SORTBY_ASC:
+            if (Settings.PgSortNulls) {
+                nullsFirst = false;
+            }
             break;
         case SORTBY_DESC:
             asc = false;
@@ -4022,8 +4025,17 @@ public:
             return nullptr;
         }
 
-        if (value->sortby_nulls != SORTBY_NULLS_DEFAULT) {
-            AddError(TStringBuilder() << "sortby_nulls unsupported value: " << (int)value->sortby_nulls);
+        switch (value->sortby_nulls) {
+        case SORTBY_NULLS_DEFAULT:
+            break;
+        case SORTBY_NULLS_FIRST:
+            nullsFirst = true;
+            break;
+        case SORTBY_NULLS_LAST:
+            nullsFirst = false;
+            break;
+        default:
+            AddError(TStringBuilder() << "sortby_dir unsupported value: " << (int)value->sortby_dir);
             return nullptr;
         }
 
@@ -4049,7 +4061,7 @@ public:
         }
 
         auto lambda = L(A("lambda"), QL(), expr);
-        return L(A("PgSort"), L(A("Void")), lambda, QA(asc ? "asc" : "desc"));
+        return L(A("PgSort"), L(A("Void")), lambda, QA(asc ? "asc" : "desc"), QA(nullsFirst ? "first" : "last"));
     }
 
     TAstNode* ParseColumnRef(const ColumnRef* value, const TExprSettings& settings) {
diff --git a/ydb/library/yql/sql/settings/translation_settings.h b/ydb/library/yql/sql/settings/translation_settings.h
index dbacdf1ac21..17b802b7aca 100644
--- a/ydb/library/yql/sql/settings/translation_settings.h
+++ b/ydb/library/yql/sql/settings/translation_settings.h
@@ -117,6 +117,7 @@ namespace NSQLTranslation {
         bool UnicodeLiterals = false;
 
         TMaybe<TString> ApplicationName;
+        bool PgSortNulls = false;
     };
 
     bool ParseTranslationSettings(const TString& query, NSQLTranslation::TTranslationSettings& settings, NYql::TIssues& issues);
diff --git a/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
index 80c7e701577..316fca2b514 100644
--- a/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
@@ -2138,9 +2138,9 @@
     ],
     "test.test[pg-pg_types_window2-default.txt-Debug]": [
         {
-            "checksum": "fdb6570b7f0e2e9f698f34e611afdd83",
-            "size": 1138,
-            "uri": "https://{canondata_backend}/1924537/c2e51d9e2e0a5d416aad46b25a797e584ed51fa2/resource.tar.gz#test.test_pg-pg_types_window2-default.txt-Debug_/opt.yql_patched"
+            "checksum": "bc5b35c42c427a5c7e1d0115198b7288",
+            "size": 1184,
+            "uri": "https://{canondata_backend}/1937027/751768eb2f05a82d5c0ae53923fca610307cec52/resource.tar.gz#test.test_pg-pg_types_window2-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-pg_types_window2-default.txt-Plan]": [
@@ -2314,9 +2314,9 @@
     ],
     "test.test[pg-select_win_partition_sort-default.txt-Debug]": [
         {
-            "checksum": "2aeb060d1f8ab384fc0fc6b2498e9109",
-            "size": 1408,
-            "uri": "https://{canondata_backend}/1924537/c2e51d9e2e0a5d416aad46b25a797e584ed51fa2/resource.tar.gz#test.test_pg-select_win_partition_sort-default.txt-Debug_/opt.yql_patched"
+            "checksum": "d65a3d3d9e2d71503114935166a0fc7e",
+            "size": 1453,
+            "uri": "https://{canondata_backend}/1937027/751768eb2f05a82d5c0ae53923fca610307cec52/resource.tar.gz#test.test_pg-select_win_partition_sort-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_partition_sort-default.txt-Plan]": [
@@ -2336,9 +2336,9 @@
     ],
     "test.test[pg-select_win_sum_null-default.txt-Debug]": [
         {
-            "checksum": "fe1b96ce1e0eb7909825980ae27cb0c9",
-            "size": 1731,
-            "uri": "https://{canondata_backend}/1924537/c2e51d9e2e0a5d416aad46b25a797e584ed51fa2/resource.tar.gz#test.test_pg-select_win_sum_null-default.txt-Debug_/opt.yql_patched"
+            "checksum": "4e02da8b8382807b54779ed396e7abf3",
+            "size": 1737,
+            "uri": "https://{canondata_backend}/1937027/751768eb2f05a82d5c0ae53923fca610307cec52/resource.tar.gz#test.test_pg-select_win_sum_null-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_sum_null-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part1/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part1/canondata/result.json
index c8ac667b4d2..6eec21da133 100644
--- a/ydb/library/yql/tests/sql/dq_file/part1/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part1/canondata/result.json
@@ -2227,9 +2227,9 @@
     ],
     "test.test[pg-tpcds-q86-default.txt-Debug]": [
         {
-            "checksum": "378c7b17aeef13ff3a4632a977d1af05",
-            "size": 2958,
-            "uri": "https://{canondata_backend}/995452/b482ddbdc16c2fe4b316d7b636dcbf8ccbf48261/resource.tar.gz#test.test_pg-tpcds-q86-default.txt-Debug_/opt.yql_patched"
+            "checksum": "22c5b02c719f59d9c2fc97b69660d998",
+            "size": 2964,
+            "uri": "https://{canondata_backend}/1936842/e5a3802e20877f63849313081c934fc8a817ce8f/resource.tar.gz#test.test_pg-tpcds-q86-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q86-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part10/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part10/canondata/result.json
index 4ab0bc2bb32..f05da57529a 100644
--- a/ydb/library/yql/tests/sql/dq_file/part10/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part10/canondata/result.json
@@ -1948,9 +1948,9 @@
     ],
     "test.test[pg-select_win_min-default.txt-Debug]": [
         {
-            "checksum": "d23f98d8421d7074f2d023ec3ca232a4",
-            "size": 1601,
-            "uri": "https://{canondata_backend}/1600758/c778849b827ee6b7243d05d28b4a3f467d62ba71/resource.tar.gz#test.test_pg-select_win_min-default.txt-Debug_/opt.yql_patched"
+            "checksum": "af0d6edf18a3dbd8b9041fa0d2773fd6",
+            "size": 1607,
+            "uri": "https://{canondata_backend}/937458/ef7f65979cf6294805dba5c60647105228b6ef3a/resource.tar.gz#test.test_pg-select_win_min-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_min-default.txt-Plan]": [
@@ -2080,9 +2080,9 @@
     ],
     "test.test[pg-tpcds-q49-default.txt-Debug]": [
         {
-            "checksum": "bf85732f3991115d970f254c9c1b9757",
-            "size": 6348,
-            "uri": "https://{canondata_backend}/1600758/32cfdeb8c6377a2e7e62c6c4adbb95f25af7669b/resource.tar.gz#test.test_pg-tpcds-q49-default.txt-Debug_/opt.yql_patched"
+            "checksum": "b91fb9cd38d6021040be399c5e8d91ae",
+            "size": 6385,
+            "uri": "https://{canondata_backend}/1936842/aecf4970df1ec06496312636476de0e7b19c3ebc/resource.tar.gz#test.test_pg-tpcds-q49-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q49-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part11/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part11/canondata/result.json
index a44c50ed12b..083df5c3e63 100644
--- a/ydb/library/yql/tests/sql/dq_file/part11/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part11/canondata/result.json
@@ -1869,9 +1869,9 @@
     ],
     "test.test[pg-select_win_column_order_by-default.txt-Debug]": [
         {
-            "checksum": "5071ebf7d4425b2a67fb877f1e5c1047",
-            "size": 933,
-            "uri": "https://{canondata_backend}/1936947/a99026e839b7e22714c2a9a81971a3b5e3ed1eb4/resource.tar.gz#test.test_pg-select_win_column_order_by-default.txt-Debug_/opt.yql_patched"
+            "checksum": "9c48cc7a72c2ba37bf6c318b0064fe3b",
+            "size": 939,
+            "uri": "https://{canondata_backend}/1031349/dcbc10f65e2e4437cc3d26e1817d701c654e06da/resource.tar.gz#test.test_pg-select_win_column_order_by-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_column_order_by-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
index 6725ec3dc93..b7b80ebc73d 100644
--- a/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
@@ -2317,9 +2317,9 @@
     ],
     "test.test[pg-select_win_first_last_value-default.txt-Debug]": [
         {
-            "checksum": "f5557a98fa0aa487964adc592cab8cc0",
-            "size": 1335,
-            "uri": "https://{canondata_backend}/1871002/e9746e2cfbb706bb72321a7abf9a224f0ef61b45/resource.tar.gz#test.test_pg-select_win_first_last_value-default.txt-Debug_/opt.yql_patched"
+            "checksum": "effe35a51776e4d89dea0a81611a11c9",
+            "size": 1380,
+            "uri": "https://{canondata_backend}/1889210/86d0f0a9f5fd231dca8140f5809c568e15366735/resource.tar.gz#test.test_pg-select_win_first_last_value-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_first_last_value-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part13/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part13/canondata/result.json
index 529b19c314e..a44272ce79d 100644
--- a/ydb/library/yql/tests/sql/dq_file/part13/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part13/canondata/result.json
@@ -1831,9 +1831,9 @@
     ],
     "test.test[pg-select_win_expr_order-default.txt-Debug]": [
         {
-            "checksum": "3fc3d13886e9e2b996d3fb603b380cde",
-            "size": 2004,
-            "uri": "https://{canondata_backend}/1936997/93899b3de50fae3f9677baacc98094a7a629590a/resource.tar.gz#test.test_pg-select_win_expr_order-default.txt-Debug_/opt.yql_patched"
+            "checksum": "55224d81e45d2fc2eca42a9b8cf95b93",
+            "size": 2010,
+            "uri": "https://{canondata_backend}/1937027/5c72195b4220737ff2c85cc87e9305d1d3749b17/resource.tar.gz#test.test_pg-select_win_expr_order-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_expr_order-default.txt-Plan]": [
@@ -1853,9 +1853,9 @@
     ],
     "test.test[pg-select_win_max_null-default.txt-Debug]": [
         {
-            "checksum": "d04b83176d3a040b46ae648b74f91da9",
-            "size": 1629,
-            "uri": "https://{canondata_backend}/1942525/32a558f2f82aa94ed548a77eaea0657193500581/resource.tar.gz#test.test_pg-select_win_max_null-default.txt-Debug_/opt.yql_patched"
+            "checksum": "dc123729afee48f41507652765608fa0",
+            "size": 1635,
+            "uri": "https://{canondata_backend}/1937027/5c72195b4220737ff2c85cc87e9305d1d3749b17/resource.tar.gz#test.test_pg-select_win_max_null-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_max_null-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
index b7012b135ec..706753420b0 100644
--- a/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
@@ -2003,6 +2003,28 @@
         }
     ],
     "test.test[pg-select_subquery_scalar2_qstar-default.txt-Results]": [],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Analyze]": [
+        {
+            "checksum": "a3b64a2cf9903b3868a2dd88a18fc46e",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1942525/e7939b4cfb5e85a7bd57688517d44a82bd824253/resource.tar.gz#test.test_pg-sort_nulls_priority_window-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Debug]": [
+        {
+            "checksum": "93d1d2e5578d3026fd2e34be5361ff1b",
+            "size": 1988,
+            "uri": "https://{canondata_backend}/1942525/e7939b4cfb5e85a7bd57688517d44a82bd824253/resource.tar.gz#test.test_pg-sort_nulls_priority_window-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Plan]": [
+        {
+            "checksum": "a3b64a2cf9903b3868a2dd88a18fc46e",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1942525/e7939b4cfb5e85a7bd57688517d44a82bd824253/resource.tar.gz#test.test_pg-sort_nulls_priority_window-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Results]": [],
     "test.test[pg-sublink_having_any-default.txt-Analyze]": [
         {
             "checksum": "b2a2eb5d6b0a138ee924c128fc7738ef",
diff --git a/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
index b5031de7233..daa46202ed0 100644
--- a/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
@@ -2165,9 +2165,9 @@
     ],
     "test.test[pg-select_win_frame-default.txt-Debug]": [
         {
-            "checksum": "8563c7f570535ef53d0538095f9a109c",
-            "size": 2686,
-            "uri": "https://{canondata_backend}/1599023/9fb10775fd57dc9adafaafe2a658f6533a20dc46/resource.tar.gz#test.test_pg-select_win_frame-default.txt-Debug_/opt.yql_patched"
+            "checksum": "3bb545a80110f39f739f4d84b64e7fa3",
+            "size": 2692,
+            "uri": "https://{canondata_backend}/1600758/e9eadf474d1ea4792d4f1f66ebb38dfa020bf01f/resource.tar.gz#test.test_pg-select_win_frame-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_frame-default.txt-Plan]": [
@@ -2187,9 +2187,9 @@
     ],
     "test.test[pg-select_win_min_null-default.txt-Debug]": [
         {
-            "checksum": "090e103452552909d6bdcf65e7c33440",
-            "size": 1630,
-            "uri": "https://{canondata_backend}/1937027/90a6ebec3ebdfe556d7145dc39b71ce1ef80b871/resource.tar.gz#test.test_pg-select_win_min_null-default.txt-Debug_/opt.yql_patched"
+            "checksum": "dfe0afedbb212671f62d17586a669645",
+            "size": 1636,
+            "uri": "https://{canondata_backend}/1600758/e9eadf474d1ea4792d4f1f66ebb38dfa020bf01f/resource.tar.gz#test.test_pg-select_win_min_null-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_min_null-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part2/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part2/canondata/result.json
index 21d3dfd2c28..9ecb8bc47f3 100644
--- a/ydb/library/yql/tests/sql/dq_file/part2/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part2/canondata/result.json
@@ -1966,9 +1966,9 @@
     ],
     "test.test[pg-select_win_rank_order-default.txt-Debug]": [
         {
-            "checksum": "9e3bf889ad48a519614dded4395c5003",
-            "size": 1180,
-            "uri": "https://{canondata_backend}/1924537/bdd623f6bf35175946f1cc01358daf53d53a4755/resource.tar.gz#test.test_pg-select_win_rank_order-default.txt-Debug_/opt.yql_patched"
+            "checksum": "bdc84f4ec0b4878a2d5429312e37370d",
+            "size": 1186,
+            "uri": "https://{canondata_backend}/1937429/4d6d40c3a4ce04d771c904f20d857351312e3e4b/resource.tar.gz#test.test_pg-select_win_rank_order-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_rank_order-default.txt-Plan]": [
@@ -2054,9 +2054,9 @@
     ],
     "test.test[pg-tpcds-q67-default.txt-Debug]": [
         {
-            "checksum": "48b08b53870cb9f505eef9e6a85d2c01",
-            "size": 3793,
-            "uri": "https://{canondata_backend}/1942671/6d2caf417069cf56304b9a87bee6e46557c6040d/resource.tar.gz#test.test_pg-tpcds-q67-default.txt-Debug_/opt.yql_patched"
+            "checksum": "24ad36b9144234343f4041f8499b0732",
+            "size": 3799,
+            "uri": "https://{canondata_backend}/1936842/baf80494bd9561ab5e7825bd062823ca1bfa64ba/resource.tar.gz#test.test_pg-tpcds-q67-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q67-default.txt-Plan]": [
@@ -2076,9 +2076,9 @@
     ],
     "test.test[pg-tpcds-q70-default.txt-Debug]": [
         {
-            "checksum": "8c8a6cf483e2db41183a163b83c24b83",
-            "size": 2953,
-            "uri": "https://{canondata_backend}/1942173/61b2e01110faecf0f5c4f213e07ca9a795ac4758/resource.tar.gz#test.test_pg-tpcds-q70-default.txt-Debug_/opt.yql_patched"
+            "checksum": "9340fd0eb2214a38e6284845c6be6fd5",
+            "size": 2959,
+            "uri": "https://{canondata_backend}/1936842/baf80494bd9561ab5e7825bd062823ca1bfa64ba/resource.tar.gz#test.test_pg-tpcds-q70-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q70-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part3/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part3/canondata/result.json
index b1eae848447..fb9f34c41d5 100644
--- a/ydb/library/yql/tests/sql/dq_file/part3/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part3/canondata/result.json
@@ -1751,9 +1751,9 @@
     ],
     "test.test[pg-select_win_expr_agg_order-default.txt-Debug]": [
         {
-            "checksum": "9c6ac7cb7e4449a5174b37db625e4532",
-            "size": 2840,
-            "uri": "https://{canondata_backend}/1942173/0d526d46d1478c9bf61f47a8f54b7ed647806690/resource.tar.gz#test.test_pg-select_win_expr_agg_order-default.txt-Debug_/opt.yql_patched"
+            "checksum": "a809941ea5f2a636bb11346b29ab4917",
+            "size": 2846,
+            "uri": "https://{canondata_backend}/1871002/e8a9c42fdfa0ffa60fa48ba3fd710becacba305a/resource.tar.gz#test.test_pg-select_win_expr_agg_order-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_expr_agg_order-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part5/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part5/canondata/result.json
index 612ad9641ad..8ad12b63be8 100644
--- a/ydb/library/yql/tests/sql/dq_file/part5/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part5/canondata/result.json
@@ -2194,9 +2194,9 @@
     ],
     "test.test[pg-select_win_count-default.txt-Debug]": [
         {
-            "checksum": "665b09db2b40f3868f308c49ec102fac",
-            "size": 1898,
-            "uri": "https://{canondata_backend}/1600758/bba12fda8a5a68a3753c70d51907e240b2e6a66b/resource.tar.gz#test.test_pg-select_win_count-default.txt-Debug_/opt.yql_patched"
+            "checksum": "02c5501936532e0b203e0968168a25c5",
+            "size": 1904,
+            "uri": "https://{canondata_backend}/1781765/04cf83e1f7b380ab11aab7a0a3f6a992f4c5ffda/resource.tar.gz#test.test_pg-select_win_count-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_count-default.txt-Plan]": [
@@ -2436,9 +2436,9 @@
     ],
     "test.test[pg-tpcds-q51-default.txt-Debug]": [
         {
-            "checksum": "02b770d8a16bf55fcfe3826d13cf2547",
-            "size": 6141,
-            "uri": "https://{canondata_backend}/1924537/de922a973d80db7430ccc36b4b196b0fe3a08ff2/resource.tar.gz#test.test_pg-tpcds-q51-default.txt-Debug_/opt.yql_patched"
+            "checksum": "8f06006198f32787896cffdd6247833f",
+            "size": 6167,
+            "uri": "https://{canondata_backend}/1924537/8515a8b3787c5105aaf393c0e112ddb75d305ccf/resource.tar.gz#test.test_pg-tpcds-q51-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q51-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part7/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part7/canondata/result.json
index 61931e40db5..c7b4bd46c82 100644
--- a/ydb/library/yql/tests/sql/dq_file/part7/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part7/canondata/result.json
@@ -1985,9 +1985,9 @@
     ],
     "test.test[pg-pg_types_window1-default.txt-Debug]": [
         {
-            "checksum": "96febceea1411395fda7ab461903f4e5",
-            "size": 1426,
-            "uri": "https://{canondata_backend}/1880306/724a9f1d613fdf242ccbc95fac0d24bcd5b05c46/resource.tar.gz#test.test_pg-pg_types_window1-default.txt-Debug_/opt.yql_patched"
+            "checksum": "c53563543bff15986b52fe7f3c006e9f",
+            "size": 1432,
+            "uri": "https://{canondata_backend}/1784826/10e350a94dce68db6577b228f7e65934ac1fc85e/resource.tar.gz#test.test_pg-pg_types_window1-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-pg_types_window1-default.txt-Plan]": [
@@ -2073,9 +2073,9 @@
     ],
     "test.test[pg-select_win_sum-default.txt-Debug]": [
         {
-            "checksum": "0c6fd99772549997f5a7927167ccabe0",
-            "size": 1702,
-            "uri": "https://{canondata_backend}/1880306/724a9f1d613fdf242ccbc95fac0d24bcd5b05c46/resource.tar.gz#test.test_pg-select_win_sum-default.txt-Debug_/opt.yql_patched"
+            "checksum": "b9041b1e730cd391fbfb211f403f9e39",
+            "size": 1708,
+            "uri": "https://{canondata_backend}/1784826/10e350a94dce68db6577b228f7e65934ac1fc85e/resource.tar.gz#test.test_pg-select_win_sum-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_sum-default.txt-Plan]": [
@@ -2086,6 +2086,28 @@
         }
     ],
     "test.test[pg-select_win_sum-default.txt-Results]": [],
+    "test.test[pg-sort_nulls_priority-default.txt-Analyze]": [
+        {
+            "checksum": "a3b64a2cf9903b3868a2dd88a18fc46e",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1784826/10e350a94dce68db6577b228f7e65934ac1fc85e/resource.tar.gz#test.test_pg-sort_nulls_priority-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority-default.txt-Debug]": [
+        {
+            "checksum": "7d2168d047e4190270e56607bdeff71f",
+            "size": 793,
+            "uri": "https://{canondata_backend}/1784826/10e350a94dce68db6577b228f7e65934ac1fc85e/resource.tar.gz#test.test_pg-sort_nulls_priority-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority-default.txt-Plan]": [
+        {
+            "checksum": "a3b64a2cf9903b3868a2dd88a18fc46e",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1784826/10e350a94dce68db6577b228f7e65934ac1fc85e/resource.tar.gz#test.test_pg-sort_nulls_priority-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority-default.txt-Results]": [],
     "test.test[pg-sublink_projection_any_corr-default.txt-Analyze]": [
         {
             "checksum": "b4dd508a329723c74293d80f0278c705",
diff --git a/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
index 37e8f6e964b..7ebe7498c8a 100644
--- a/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
@@ -2392,9 +2392,9 @@
     ],
     "test.test[pg-select_win_max-default.txt-Debug]": [
         {
-            "checksum": "3cec6f8cb29da6d3fa46296cd4b080a9",
-            "size": 1600,
-            "uri": "https://{canondata_backend}/1937027/dd423a99ed05fbce79d0677e5519d444df503e33/resource.tar.gz#test.test_pg-select_win_max-default.txt-Debug_/opt.yql_patched"
+            "checksum": "a9a9126474747b743ca8eb7212fa7ec4",
+            "size": 1606,
+            "uri": "https://{canondata_backend}/1889210/efe4e2f2d55be8660c9313813d66a8fb62e04dc5/resource.tar.gz#test.test_pg-select_win_max-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_max-default.txt-Plan]": [
@@ -2458,9 +2458,9 @@
     ],
     "test.test[pg-tpcds-q36-default.txt-Debug]": [
         {
-            "checksum": "20c3c47e7d6e4947f99c7b37a7dd5de9",
-            "size": 3754,
-            "uri": "https://{canondata_backend}/1925821/1d295f9b4197e0ee9040dbe96e131629e0b40339/resource.tar.gz#test.test_pg-tpcds-q36-default.txt-Debug_/opt.yql_patched"
+            "checksum": "37006a12c9b61a46ecbed82c19e07ff3",
+            "size": 3760,
+            "uri": "https://{canondata_backend}/1775059/f83c564439c6bfc4100724c4089f557d22989d2f/resource.tar.gz#test.test_pg-tpcds-q36-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q36-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/dq_file/part9/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part9/canondata/result.json
index 97755a149e7..33cc59bbff4 100644
--- a/ydb/library/yql/tests/sql/dq_file/part9/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part9/canondata/result.json
@@ -1868,9 +1868,9 @@
     ],
     "test.test[pg-select_win_count_all-default.txt-Debug]": [
         {
-            "checksum": "4e5298a8cb161db246107189ba31c985",
-            "size": 1788,
-            "uri": "https://{canondata_backend}/1777230/91a147d17132375579c4f4ec545f8c73b8b69ee1/resource.tar.gz#test.test_pg-select_win_count_all-default.txt-Debug_/opt.yql_patched"
+            "checksum": "bec03ada15eb4738066a2bdf5063877a",
+            "size": 1794,
+            "uri": "https://{canondata_backend}/1880306/279c7aba2c44599afb6ffd3e15e09f8e37a8e4ce/resource.tar.gz#test.test_pg-select_win_count_all-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_count_all-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part0/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part0/canondata/result.json
index 2a97a4be6fc..f5eeabecc80 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part0/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part0/canondata/result.json
@@ -1877,9 +1877,9 @@
     ],
     "test.test[pg-select_win_min_null-default.txt-Debug]": [
         {
-            "checksum": "73c11a7bbfd5ef66bcec38e766827f14",
-            "size": 1629,
-            "uri": "https://{canondata_backend}/1600758/acf43cdc6344357508eb4fb692b6408060f2de43/resource.tar.gz#test.test_pg-select_win_min_null-default.txt-Debug_/opt.yql_patched"
+            "checksum": "95e64a496d8722db94790f31e0126998",
+            "size": 1635,
+            "uri": "https://{canondata_backend}/1784826/c5a70dea28dd575aebb59ff32ea2b9ed022ac20c/resource.tar.gz#test.test_pg-select_win_min_null-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_min_null-default.txt-Plan]": [
@@ -2031,9 +2031,9 @@
     ],
     "test.test[pg-tpcds-q51-default.txt-Debug]": [
         {
-            "checksum": "876a5f75d510a52315921554f99147a3",
-            "size": 6140,
-            "uri": "https://{canondata_backend}/1936947/581aa6d896ffe57e25bdb8006459e912860e61fa/resource.tar.gz#test.test_pg-tpcds-q51-default.txt-Debug_/opt.yql_patched"
+            "checksum": "e89d0c047b63a2710594fad72c5b2d16",
+            "size": 6166,
+            "uri": "https://{canondata_backend}/1924537/b112d187ebf731abc2b04c974853f91beb3dd74d/resource.tar.gz#test.test_pg-tpcds-q51-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q51-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part1/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part1/canondata/result.json
index 84017d7814b..498725065ca 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part1/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part1/canondata/result.json
@@ -1737,9 +1737,9 @@
     ],
     "test.test[pg-select_win_first_last_value-default.txt-Debug]": [
         {
-            "checksum": "173a521b1f0a98f02660275073e01aef",
-            "size": 1334,
-            "uri": "https://{canondata_backend}/1942100/d5a28a8ea44450226f92d6356b74035c1a65f1fb/resource.tar.gz#test.test_pg-select_win_first_last_value-default.txt-Debug_/opt.yql_patched"
+            "checksum": "d79e19a54e197363fb005be49d4507e7",
+            "size": 1379,
+            "uri": "https://{canondata_backend}/1784826/ded8e4bd34c1c30373c7726abce38eca90ec35ab/resource.tar.gz#test.test_pg-select_win_first_last_value-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_first_last_value-default.txt-Plan]": [
@@ -1751,9 +1751,9 @@
     ],
     "test.test[pg-select_win_partition_sort-default.txt-Debug]": [
         {
-            "checksum": "acd250d69c99509167b9e41774dc4a97",
-            "size": 1407,
-            "uri": "https://{canondata_backend}/1942100/d5a28a8ea44450226f92d6356b74035c1a65f1fb/resource.tar.gz#test.test_pg-select_win_partition_sort-default.txt-Debug_/opt.yql_patched"
+            "checksum": "d17b1b76ba519cca2387474cbfb6b4e5",
+            "size": 1452,
+            "uri": "https://{canondata_backend}/1784826/ded8e4bd34c1c30373c7726abce38eca90ec35ab/resource.tar.gz#test.test_pg-select_win_partition_sort-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_partition_sort-default.txt-Plan]": [
@@ -1877,9 +1877,9 @@
     ],
     "test.test[pg-tpcds-q67-default.txt-Debug]": [
         {
-            "checksum": "c85bc4d588443fe7aa32a60e5c4bd1f1",
-            "size": 3792,
-            "uri": "https://{canondata_backend}/1936273/85968a675c17dd0728c8d7ba5fd43bd0b237dc65/resource.tar.gz#test.test_pg-tpcds-q67-default.txt-Debug_/opt.yql_patched"
+            "checksum": "3bff932498b1275a1828927498f97ce5",
+            "size": 3798,
+            "uri": "https://{canondata_backend}/1784826/27f8cd2f641de7f2ee55266beaca6dda7fb6d4cc/resource.tar.gz#test.test_pg-tpcds-q67-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q67-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part10/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part10/canondata/result.json
index c5d0f24c5eb..106dbf810d2 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part10/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part10/canondata/result.json
@@ -1989,9 +1989,9 @@
     ],
     "test.test[pg-select_win_column_order_by-default.txt-Debug]": [
         {
-            "checksum": "6c5738df65164b7e7e3ac922317c0caa",
-            "size": 932,
-            "uri": "https://{canondata_backend}/1775319/3515b86fb929979a6751f93bd43a0291eaa01262/resource.tar.gz#test.test_pg-select_win_column_order_by-default.txt-Debug_/opt.yql_patched"
+            "checksum": "7810527bc9e5d9d6946fb47f8b82e177",
+            "size": 938,
+            "uri": "https://{canondata_backend}/1871002/01b60ff3bfc2c8aa5cff8ebbe693bdbbfe6a1c1c/resource.tar.gz#test.test_pg-select_win_column_order_by-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_column_order_by-default.txt-Plan]": [
@@ -2001,6 +2001,20 @@
             "uri": "https://{canondata_backend}/1775319/3515b86fb929979a6751f93bd43a0291eaa01262/resource.tar.gz#test.test_pg-select_win_column_order_by-default.txt-Plan_/plan.txt"
         }
     ],
+    "test.test[pg-sort_nulls_priority-default.txt-Debug]": [
+        {
+            "checksum": "7b8c69f4bfdfbd872c6bf2251254b117",
+            "size": 792,
+            "uri": "https://{canondata_backend}/1871002/01b60ff3bfc2c8aa5cff8ebbe693bdbbfe6a1c1c/resource.tar.gz#test.test_pg-sort_nulls_priority-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority-default.txt-Plan]": [
+        {
+            "checksum": "a3b64a2cf9903b3868a2dd88a18fc46e",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1871002/01b60ff3bfc2c8aa5cff8ebbe693bdbbfe6a1c1c/resource.tar.gz#test.test_pg-sort_nulls_priority-default.txt-Plan_/plan.txt"
+        }
+    ],
     "test.test[pg-sublink_having_all-default.txt-Debug]": [
         {
             "checksum": "6ef3fb8409c3e7d380872aa29a2254a9",
@@ -2101,9 +2115,9 @@
     ],
     "test.test[pg-tpcds-q49-default.txt-Debug]": [
         {
-            "checksum": "bf2d184419429c5f947495d5a7b4f0b4",
-            "size": 6347,
-            "uri": "https://{canondata_backend}/1775319/3515b86fb929979a6751f93bd43a0291eaa01262/resource.tar.gz#test.test_pg-tpcds-q49-default.txt-Debug_/opt.yql_patched"
+            "checksum": "68d3e6009cd841df5e313373275e97d8",
+            "size": 6384,
+            "uri": "https://{canondata_backend}/1936842/848a979971caeba2efc272b5418157aab954923a/resource.tar.gz#test.test_pg-tpcds-q49-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q49-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part2/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part2/canondata/result.json
index efd5bd508df..b5f260c9897 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part2/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part2/canondata/result.json
@@ -1821,9 +1821,9 @@
     ],
     "test.test[pg-pg_types_window2-default.txt-Debug]": [
         {
-            "checksum": "a9b0239f72450a316bb699422d9b7e90",
-            "size": 1137,
-            "uri": "https://{canondata_backend}/1903885/2084963a606d92a86d0b46a109618174dca0d324/resource.tar.gz#test.test_pg-pg_types_window2-default.txt-Debug_/opt.yql_patched"
+            "checksum": "3bb27c20bd031659020515655d619d0c",
+            "size": 1183,
+            "uri": "https://{canondata_backend}/212715/8451679d3cbfa9fad3a627b44d818cc98dbabb46/resource.tar.gz#test.test_pg-pg_types_window2-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-pg_types_window2-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part3/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part3/canondata/result.json
index c3a400b01f0..78b2c7a0162 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part3/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part3/canondata/result.json
@@ -1905,9 +1905,9 @@
     ],
     "test.test[pg-pg_types_window1-default.txt-Debug]": [
         {
-            "checksum": "5f2ad48664ea468bae691ea4ad655c9f",
-            "size": 1425,
-            "uri": "https://{canondata_backend}/1871182/3ca7d9f793310690733c1f09756d621fb525e562/resource.tar.gz#test.test_pg-pg_types_window1-default.txt-Debug_/opt.yql_patched"
+            "checksum": "49054099e0442c8e0e079eb2db22f624",
+            "size": 1431,
+            "uri": "https://{canondata_backend}/1942100/9da380c43b5de6ff69f9fc402c31f0485dedddb1/resource.tar.gz#test.test_pg-pg_types_window1-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-pg_types_window1-default.txt-Plan]": [
@@ -2141,6 +2141,20 @@
             "uri": "https://{canondata_backend}/1936842/11d23d4a39031af80d6dc470ce99f9427771e7d4/resource.tar.gz#test.test_pg-select_proj_ref_group_by_star-default.txt-Plan_/plan.txt"
         }
     ],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Debug]": [
+        {
+            "checksum": "599fe2f9d2e82b61edb68d8fbbab1b2c",
+            "size": 1987,
+            "uri": "https://{canondata_backend}/1942100/9da380c43b5de6ff69f9fc402c31f0485dedddb1/resource.tar.gz#test.test_pg-sort_nulls_priority_window-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Plan]": [
+        {
+            "checksum": "a3b64a2cf9903b3868a2dd88a18fc46e",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1942100/9da380c43b5de6ff69f9fc402c31f0485dedddb1/resource.tar.gz#test.test_pg-sort_nulls_priority_window-default.txt-Plan_/plan.txt"
+        }
+    ],
     "test.test[pg-sublink_projection_uncorrelated-default.txt-Debug]": [
         {
             "checksum": "c3b7ec172f6bb3e4c7817b0d405d7973",
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part4/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part4/canondata/result.json
index eb55a2975d4..95cfff8edc3 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part4/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part4/canondata/result.json
@@ -2059,9 +2059,9 @@
     ],
     "test.test[pg-select_win_count-default.txt-Debug]": [
         {
-            "checksum": "32d4e9ee332b60309fae543044bcc63f",
-            "size": 1897,
-            "uri": "https://{canondata_backend}/1600758/20bb0998dc12a8e0bd202fe7a254431e3192f87d/resource.tar.gz#test.test_pg-select_win_count-default.txt-Debug_/opt.yql_patched"
+            "checksum": "7f8170f5dd3da504a1f7cd689de3ae34",
+            "size": 1903,
+            "uri": "https://{canondata_backend}/1937492/26fc762c0fda002877a8be5aae203e7aa4858d52/resource.tar.gz#test.test_pg-select_win_count-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_count-default.txt-Plan]": [
@@ -2101,9 +2101,9 @@
     ],
     "test.test[pg-select_win_max_null-default.txt-Debug]": [
         {
-            "checksum": "8ec85fe459f4e35b21a048c0125f793e",
-            "size": 1628,
-            "uri": "https://{canondata_backend}/1600758/20bb0998dc12a8e0bd202fe7a254431e3192f87d/resource.tar.gz#test.test_pg-select_win_max_null-default.txt-Debug_/opt.yql_patched"
+            "checksum": "a67146e6175828c8eb14e9fed1f14031",
+            "size": 1634,
+            "uri": "https://{canondata_backend}/1937492/26fc762c0fda002877a8be5aae203e7aa4858d52/resource.tar.gz#test.test_pg-select_win_max_null-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_max_null-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part5/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part5/canondata/result.json
index e8b8a7a3574..4dba903d5d1 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part5/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part5/canondata/result.json
@@ -1751,9 +1751,9 @@
     ],
     "test.test[pg-select_win_expr_agg_order-default.txt-Debug]": [
         {
-            "checksum": "b9db1ae726afbb4e71041a91c2fc6315",
-            "size": 2839,
-            "uri": "https://{canondata_backend}/1936947/a5f83e5d38179c14126d53519dc062cef98113ec/resource.tar.gz#test.test_pg-select_win_expr_agg_order-default.txt-Debug_/opt.yql_patched"
+            "checksum": "590c4cc76bdb7b1bd19943b13b0aa947",
+            "size": 2845,
+            "uri": "https://{canondata_backend}/1777230/489c8a5329cb3d4f502a65fea2e5cc4f67ff9698/resource.tar.gz#test.test_pg-select_win_expr_agg_order-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_expr_agg_order-default.txt-Plan]": [
@@ -1765,9 +1765,9 @@
     ],
     "test.test[pg-select_win_rank_order-default.txt-Debug]": [
         {
-            "checksum": "523b4e3b9b3ef9bdfa091a5e5fd22202",
-            "size": 1179,
-            "uri": "https://{canondata_backend}/1936842/b40c1dd3d855ec4640a765f55ba1c1a6797f65ee/resource.tar.gz#test.test_pg-select_win_rank_order-default.txt-Debug_/opt.yql_patched"
+            "checksum": "b1ad9060113f0882442b783706ee3150",
+            "size": 1185,
+            "uri": "https://{canondata_backend}/1777230/489c8a5329cb3d4f502a65fea2e5cc4f67ff9698/resource.tar.gz#test.test_pg-select_win_rank_order-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_rank_order-default.txt-Plan]": [
@@ -1779,9 +1779,9 @@
     ],
     "test.test[pg-select_win_sum-default.txt-Debug]": [
         {
-            "checksum": "a618388e4ab92a6f3b0a7c8333344b56",
-            "size": 1701,
-            "uri": "https://{canondata_backend}/1936842/b40c1dd3d855ec4640a765f55ba1c1a6797f65ee/resource.tar.gz#test.test_pg-select_win_sum-default.txt-Debug_/opt.yql_patched"
+            "checksum": "24a55919181d482161ee28a9ee8bc8a5",
+            "size": 1707,
+            "uri": "https://{canondata_backend}/1777230/489c8a5329cb3d4f502a65fea2e5cc4f67ff9698/resource.tar.gz#test.test_pg-select_win_sum-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_sum-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part6/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part6/canondata/result.json
index 5e17ce9462a..9eecc3f966e 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part6/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part6/canondata/result.json
@@ -1905,9 +1905,9 @@
     ],
     "test.test[pg-select_win_count_all-default.txt-Debug]": [
         {
-            "checksum": "e534c1e50b2958fb47b4ae4c557798f5",
-            "size": 1787,
-            "uri": "https://{canondata_backend}/1937027/ada6abcf938e1f8d16f0582e4d91ef5e675daa49/resource.tar.gz#test.test_pg-select_win_count_all-default.txt-Debug_/opt.yql_patched"
+            "checksum": "f42643da0632c0a4361857b47ec8ac09",
+            "size": 1793,
+            "uri": "https://{canondata_backend}/1871182/c1b1f4292928931b25dbbf2079b4b20fc3a40c26/resource.tar.gz#test.test_pg-select_win_count_all-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_count_all-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part7/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part7/canondata/result.json
index 9a1a192d337..d8d5280b2f6 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part7/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part7/canondata/result.json
@@ -1737,9 +1737,9 @@
     ],
     "test.test[pg-select_win_expr_order-default.txt-Debug]": [
         {
-            "checksum": "fa0fe2b50c12900f435c1aae4f6623f0",
-            "size": 2003,
-            "uri": "https://{canondata_backend}/1781765/028f42f897160b53900546b39900217bb2eb9fb1/resource.tar.gz#test.test_pg-select_win_expr_order-default.txt-Debug_/opt.yql_patched"
+            "checksum": "bed7c5906500e8f839bcc95709bc196b",
+            "size": 2009,
+            "uri": "https://{canondata_backend}/1880306/13de9ec0707368d65e32e235bef7ca062d7beb86/resource.tar.gz#test.test_pg-select_win_expr_order-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_expr_order-default.txt-Plan]": [
@@ -1751,9 +1751,9 @@
     ],
     "test.test[pg-select_win_sum_null-default.txt-Debug]": [
         {
-            "checksum": "371af915f09b534f5cc25c5e21481e35",
-            "size": 1730,
-            "uri": "https://{canondata_backend}/1600758/2bae720d354fef176d7a7ae70957b1a227ff538a/resource.tar.gz#test.test_pg-select_win_sum_null-default.txt-Debug_/opt.yql_patched"
+            "checksum": "baecd56234918595be7dbcb66ed91332",
+            "size": 1736,
+            "uri": "https://{canondata_backend}/1880306/13de9ec0707368d65e32e235bef7ca062d7beb86/resource.tar.gz#test.test_pg-select_win_sum_null-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_sum_null-default.txt-Plan]": [
@@ -1989,9 +1989,9 @@
     ],
     "test.test[pg-tpcds-q70-default.txt-Debug]": [
         {
-            "checksum": "aa687f2a3cab1d209b68eb24b3089c51",
-            "size": 2952,
-            "uri": "https://{canondata_backend}/1781765/028f42f897160b53900546b39900217bb2eb9fb1/resource.tar.gz#test.test_pg-tpcds-q70-default.txt-Debug_/opt.yql_patched"
+            "checksum": "523f1377ef65c5ecd256c635abe877bd",
+            "size": 2958,
+            "uri": "https://{canondata_backend}/1924537/35de62398408ece8ef70d2aa7893fb15acb62608/resource.tar.gz#test.test_pg-tpcds-q70-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q70-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part8/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part8/canondata/result.json
index e5c7d7858bf..667e0852035 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part8/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part8/canondata/result.json
@@ -2353,9 +2353,9 @@
     ],
     "test.test[pg-tpcds-q86-default.txt-Debug]": [
         {
-            "checksum": "2612ccd67e71f3569a8faf926666ecff",
-            "size": 2957,
-            "uri": "https://{canondata_backend}/1923547/94f377eaa1d93890e1345ac4940cc6fa07bddd4f/resource.tar.gz#test.test_pg-tpcds-q86-default.txt-Debug_/opt.yql_patched"
+            "checksum": "21c17a1952ea101cdc2d398d17723c0d",
+            "size": 2963,
+            "uri": "https://{canondata_backend}/1923547/ac46e4e6eaf4527076b3ffccf13b5794047d9f9a/resource.tar.gz#test.test_pg-tpcds-q86-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q86-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/hybrid_file/part9/canondata/result.json b/ydb/library/yql/tests/sql/hybrid_file/part9/canondata/result.json
index 0208954fdb6..ce0812ea9bb 100644
--- a/ydb/library/yql/tests/sql/hybrid_file/part9/canondata/result.json
+++ b/ydb/library/yql/tests/sql/hybrid_file/part9/canondata/result.json
@@ -1905,9 +1905,9 @@
     ],
     "test.test[pg-select_win_frame-default.txt-Debug]": [
         {
-            "checksum": "ca9aed6257ce701fb4ce535ed712c292",
-            "size": 2685,
-            "uri": "https://{canondata_backend}/1889210/796baf28896eb5aaad8828a0b6000e7d17563447/resource.tar.gz#test.test_pg-select_win_frame-default.txt-Debug_/opt.yql_patched"
+            "checksum": "0bde3cf79a1a3bcdc4f38ab31800f4be",
+            "size": 2691,
+            "uri": "https://{canondata_backend}/1871182/8f870ad5c0ca303981ae3a0f838a9a434b44fafb/resource.tar.gz#test.test_pg-select_win_frame-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_frame-default.txt-Plan]": [
@@ -1919,9 +1919,9 @@
     ],
     "test.test[pg-select_win_max-default.txt-Debug]": [
         {
-            "checksum": "632e75de54e1b94dbb8f15565eab7fb8",
-            "size": 1599,
-            "uri": "https://{canondata_backend}/1600758/945d8bd5a89c655f23736d13a6248011860cd506/resource.tar.gz#test.test_pg-select_win_max-default.txt-Debug_/opt.yql_patched"
+            "checksum": "2d3130ce15fc6fb2a0c1e90c60ae26f0",
+            "size": 1605,
+            "uri": "https://{canondata_backend}/1871182/8f870ad5c0ca303981ae3a0f838a9a434b44fafb/resource.tar.gz#test.test_pg-select_win_max-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_max-default.txt-Plan]": [
@@ -1933,9 +1933,9 @@
     ],
     "test.test[pg-select_win_min-default.txt-Debug]": [
         {
-            "checksum": "e5a5f9196f8706a1e4ee583719273746",
-            "size": 1600,
-            "uri": "https://{canondata_backend}/1600758/945d8bd5a89c655f23736d13a6248011860cd506/resource.tar.gz#test.test_pg-select_win_min-default.txt-Debug_/opt.yql_patched"
+            "checksum": "f95a62a36673aab239d08b9aefb205ae",
+            "size": 1606,
+            "uri": "https://{canondata_backend}/1871182/8f870ad5c0ca303981ae3a0f838a9a434b44fafb/resource.tar.gz#test.test_pg-select_win_min-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-select_win_min-default.txt-Plan]": [
@@ -2031,9 +2031,9 @@
     ],
     "test.test[pg-tpcds-q36-default.txt-Debug]": [
         {
-            "checksum": "d1aca78885f1c42d17045b6cbbe56422",
-            "size": 3753,
-            "uri": "https://{canondata_backend}/1889210/796baf28896eb5aaad8828a0b6000e7d17563447/resource.tar.gz#test.test_pg-tpcds-q36-default.txt-Debug_/opt.yql_patched"
+            "checksum": "f91a9ed55f061430d63413c11a278a04",
+            "size": 3759,
+            "uri": "https://{canondata_backend}/1924537/c66f8e2410a063d66cdbcfdf289de2112ba61f12/resource.tar.gz#test.test_pg-tpcds-q36-default.txt-Debug_/opt.yql_patched"
         }
     ],
     "test.test[pg-tpcds-q36-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/sql2yql/canondata/result.json b/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
index f595f497da1..cfe00339060 100644
--- a/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
+++ b/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
@@ -10991,9 +10991,9 @@
     ],
     "test_sql2yql.test[pg-distinct_on_multi_projection]": [
         {
-            "checksum": "9e6b9386ad9668388298b5b3e6f53b9d",
-            "size": 1299,
-            "uri": "https://{canondata_backend}/1925842/d62b5f5680f5595a57320ac8dac15190bfb0862a/resource.tar.gz#test_sql2yql.test_pg-distinct_on_multi_projection_/sql.yql"
+            "checksum": "02e3e5a227bead3cfbd9892d82549c8f",
+            "size": 1313,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-distinct_on_multi_projection_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-distinct_on_single_projection_no_order]": [
@@ -11005,16 +11005,16 @@
     ],
     "test_sql2yql.test[pg-distinct_on_single_projection_order]": [
         {
-            "checksum": "9675038dfe175095b1804dbb774987a4",
-            "size": 1073,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-distinct_on_single_projection_order_/sql.yql"
+            "checksum": "81528880698273409586f6246d74815d",
+            "size": 1087,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-distinct_on_single_projection_order_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-distinct_on_single_projection_order_expr]": [
         {
-            "checksum": "77b59eb0377807d62513e561d1a61612",
-            "size": 1153,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-distinct_on_single_projection_order_expr_/sql.yql"
+            "checksum": "20659740dbc4652d92253c8ee2c8755c",
+            "size": 1167,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-distinct_on_single_projection_order_expr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-drop_table]": [
@@ -11068,9 +11068,9 @@
     ],
     "test_sql2yql.test[pg-name]": [
         {
-            "checksum": "efa257c9b602a1bd385c047fee6e1a88",
-            "size": 779,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-name_/sql.yql"
+            "checksum": "24ae7cd25c7083f247457f686eb1ee60",
+            "size": 786,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-name_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-nothing]": [
@@ -11082,100 +11082,100 @@
     ],
     "test_sql2yql.test[pg-order_by_agg_extra_for_keys]": [
         {
-            "checksum": "d072ce6f5a07fca8c55e578151f3398d",
-            "size": 945,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_extra_for_keys_/sql.yql"
+            "checksum": "e5d2f7b4f76fafc7565d1b2c620f3f31",
+            "size": 959,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_extra_for_keys_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_agg_input_columns_aggr]": [
         {
-            "checksum": "0e1b1bcee772191562e33eba3f51ad1b",
-            "size": 915,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_aggr_/sql.yql"
+            "checksum": "f45d9c95ca276f2f75ae5c105ec8d4d7",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_aggr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_agg_input_columns_full]": [
         {
-            "checksum": "c13581bcd1185008183d0e1cc833e3db",
-            "size": 856,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_full_/sql.yql"
+            "checksum": "e95ed18f060ae5757b533a30da1256ee",
+            "size": 863,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_full_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_agg_input_columns_keys]": [
         {
-            "checksum": "028aaaa2fb3db9978b4276cf3814384a",
-            "size": 913,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_keys_/sql.yql"
+            "checksum": "2128a7846521340876ed1702a4180ff3",
+            "size": 920,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_keys_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_agg_input_columns_prj_and_aggr]": [
         {
-            "checksum": "76ec779b7b2f023561b8a62e51c355c4",
-            "size": 1006,
-            "uri": "https://{canondata_backend}/1942173/abecf46358d847c78f2117cec17ad429699ca53c/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_prj_and_aggr_/sql.yql"
+            "checksum": "323c51e4a4c3e091dca6ab6e9871ca0c",
+            "size": 1013,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_prj_and_aggr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_agg_input_columns_prj_and_keys_and_aggr]": [
         {
-            "checksum": "4a54c9777ccfde975fd898b4f28b9112",
-            "size": 1059,
-            "uri": "https://{canondata_backend}/1942173/abecf46358d847c78f2117cec17ad429699ca53c/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_prj_and_keys_and_aggr_/sql.yql"
+            "checksum": "93c94c2e4ba6dc01f1eae8115d7dff17",
+            "size": 1073,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_input_columns_prj_and_keys_and_aggr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_agg_no_extra_for_aggs]": [
         {
-            "checksum": "737a30b260d808fbe1ff5da1b76ce528",
-            "size": 713,
-            "uri": "https://{canondata_backend}/1871002/a5ffe5219921c8daea4d9e5fcde3aae3fa42d29c/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_no_extra_for_aggs_/sql.yql"
+            "checksum": "c511438fe21249c367342d53050a614c",
+            "size": 720,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_agg_no_extra_for_aggs_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_distinct_same_expr]": [
         {
-            "checksum": "90ff11d3ea24565554ca875062effe44",
-            "size": 977,
-            "uri": "https://{canondata_backend}/1871182/be7e0db544f9cfa977e36aa7ea0951073e129335/resource.tar.gz#test_sql2yql.test_pg-order_by_distinct_same_expr_/sql.yql"
+            "checksum": "d4ccde5eaf2ecf5ee4615a577c8660ba",
+            "size": 991,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_distinct_same_expr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_distinct_same_expr_agg]": [
         {
-            "checksum": "d9fa181c807070e8f4b1e98f2a046170",
-            "size": 1546,
-            "uri": "https://{canondata_backend}/1871182/be7e0db544f9cfa977e36aa7ea0951073e129335/resource.tar.gz#test_sql2yql.test_pg-order_by_distinct_same_expr_agg_/sql.yql"
+            "checksum": "34e8d0ac857faa03e7a51e64a276be8b",
+            "size": 1567,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_distinct_same_expr_agg_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_distinct_same_expr_agg_sublink]": [
         {
-            "checksum": "fb935ca78b8c8fc5446676ecf11414c4",
-            "size": 1593,
-            "uri": "https://{canondata_backend}/1923547/a5628d49e504286f75a25bfc2053145eaa2cfec1/resource.tar.gz#test_sql2yql.test_pg-order_by_distinct_same_expr_agg_sublink_/sql.yql"
+            "checksum": "fc868b99e8be4b2d8f7532ec5ef68a0e",
+            "size": 1600,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_distinct_same_expr_agg_sublink_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_input_columns]": [
         {
-            "checksum": "3704d16abf0dcaab370628415ac6b165",
-            "size": 834,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-order_by_input_columns_/sql.yql"
+            "checksum": "e03614b342daa093a6cd2a0e70f61c3d",
+            "size": 841,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_input_columns_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_input_columns_qual]": [
         {
-            "checksum": "0548a897d61766c9110f2174bf5f5208",
-            "size": 839,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-order_by_input_columns_qual_/sql.yql"
+            "checksum": "19496a6ba78d81adabcb6af9f50520b8",
+            "size": 846,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_input_columns_qual_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_shadow_input_columns]": [
         {
-            "checksum": "cccd6e55d8e206f84b7b6a942da42280",
-            "size": 846,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-order_by_shadow_input_columns_/sql.yql"
+            "checksum": "134c336825b33d0603e5a122e8ba8609",
+            "size": 853,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_shadow_input_columns_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-order_by_shadow_input_columns_qual]": [
         {
-            "checksum": "3e459e6341cd8e694a874b4ae7830e3c",
-            "size": 851,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-order_by_shadow_input_columns_qual_/sql.yql"
+            "checksum": "766ae8ebebfe2d69eb4c2795516924f4",
+            "size": 858,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-order_by_shadow_input_columns_qual_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-palloc_big_string]": [
@@ -11299,23 +11299,23 @@
     ],
     "test_sql2yql.test[pg-pg_types_orderby]": [
         {
-            "checksum": "158e2077831cc3559abb3cde7babcb8d",
-            "size": 4915,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-pg_types_orderby_/sql.yql"
+            "checksum": "4803584c62a61fa012c601d9009ada1c",
+            "size": 4971,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-pg_types_orderby_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-pg_types_window1]": [
         {
-            "checksum": "45b1afc88b70d9dfb033eb82bf79a699",
-            "size": 866,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-pg_types_window1_/sql.yql"
+            "checksum": "36b2c8a67790b7d54db0c58076e7ed39",
+            "size": 873,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-pg_types_window1_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-pg_types_window2]": [
         {
-            "checksum": "f7c74c16cf3147d1bc7897e161537074",
-            "size": 1056,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-pg_types_window2_/sql.yql"
+            "checksum": "510e98e4703ebd0abd649982462abb29",
+            "size": 1063,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-pg_types_window2_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-pg_view]": [
@@ -11327,9 +11327,9 @@
     ],
     "test_sql2yql.test[pg-point]": [
         {
-            "checksum": "89d3dfc81c1c79ffd96c756add33ef75",
-            "size": 793,
-            "uri": "https://{canondata_backend}/1773845/1c437537f43a677aede89e51a045cd1fa88f8f55/resource.tar.gz#test_sql2yql.test_pg-point_/sql.yql"
+            "checksum": "b95436ea1b85a84eff63cb5273938380",
+            "size": 800,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-point_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-range_function_multi]": [
@@ -11383,9 +11383,9 @@
     ],
     "test_sql2yql.test[pg-select_agg_expr_order]": [
         {
-            "checksum": "4727c04817c0be13e504f0e9bb227b4e",
-            "size": 864,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_agg_expr_order_/sql.yql"
+            "checksum": "956ab09a609f65cdd73fac2a0392c8c1",
+            "size": 871,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_agg_expr_order_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_agg_expr_projection]": [
@@ -11411,30 +11411,30 @@
     ],
     "test_sql2yql.test[pg-select_agg_gs_cube]": [
         {
-            "checksum": "ce812682e3edf66ac130cfae18647e27",
-            "size": 1113,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_agg_gs_cube_/sql.yql"
+            "checksum": "d89fe01af16297f8f7a88adfe872ba2b",
+            "size": 1127,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_agg_gs_cube_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_agg_gs_grouping]": [
         {
-            "checksum": "25e646fe1b8f1cfd834c07a834ae4016",
-            "size": 1366,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_agg_gs_grouping_/sql.yql"
+            "checksum": "c8ae2b90bf95f0af77ab776e03b1eeb3",
+            "size": 1380,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_agg_gs_grouping_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_agg_gs_rollup]": [
         {
-            "checksum": "e2428b872b57c6aea047416426c087ae",
-            "size": 1115,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_agg_gs_rollup_/sql.yql"
+            "checksum": "11833cd716c7f548650a661610567415",
+            "size": 1129,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_agg_gs_rollup_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_agg_gs_sets]": [
         {
-            "checksum": "bb485e04e771c2f7b570208e6fb7fb30",
-            "size": 1120,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_agg_gs_sets_/sql.yql"
+            "checksum": "580e8ebc97cdf66f97525e97a997ec0a",
+            "size": 1134,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_agg_gs_sets_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_agg_one_row]": [
@@ -11516,9 +11516,9 @@
     ],
     "test_sql2yql.test[pg-select_common_type_exceptall]": [
         {
-            "checksum": "5ac3061c0cc63513780b2ef34e9bf6bf",
-            "size": 722,
-            "uri": "https://{canondata_backend}/1942173/ffb77843091f03e2b382ff14da1c2da73f8b4493/resource.tar.gz#test_sql2yql.test_pg-select_common_type_exceptall_/sql.yql"
+            "checksum": "886ee129a8cdad0203695a72d5b4fcf2",
+            "size": 729,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_common_type_exceptall_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_common_type_intersect]": [
@@ -11537,16 +11537,16 @@
     ],
     "test_sql2yql.test[pg-select_common_type_union]": [
         {
-            "checksum": "38a98294ecefaa5a2536b22408ef4b60",
-            "size": 811,
-            "uri": "https://{canondata_backend}/1942173/ffb77843091f03e2b382ff14da1c2da73f8b4493/resource.tar.gz#test_sql2yql.test_pg-select_common_type_union_/sql.yql"
+            "checksum": "5d108e689ec0ce2515c52e1cea15e336",
+            "size": 818,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_common_type_union_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_common_type_unionall]": [
         {
-            "checksum": "9341adc3de0cbae696fb129a7edc7663",
-            "size": 2995,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_common_type_unionall_/sql.yql"
+            "checksum": "44911ad79465a6cc9755c2a2840e0607",
+            "size": 3016,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_common_type_unionall_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_except]": [
@@ -11936,30 +11936,30 @@
     ],
     "test_sql2yql.test[pg-select_proj_ref_order_by_expr]": [
         {
-            "checksum": "6141eecbae2506e01746855a129fee09",
-            "size": 814,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_proj_ref_order_by_expr_/sql.yql"
+            "checksum": "ff0a05b15b1b23fa1d61e3962dfe765b",
+            "size": 821,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_proj_ref_order_by_expr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_proj_ref_order_by_qstar]": [
         {
-            "checksum": "a965e3e1f91e2aa5a3001a20fcfd9ab1",
-            "size": 771,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_proj_ref_order_by_qstar_/sql.yql"
+            "checksum": "e3d14404f087d72e47274794dc92fce1",
+            "size": 778,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_proj_ref_order_by_qstar_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_proj_ref_order_by_star]": [
         {
-            "checksum": "0801b859bd2e9efc4229de0203354a02",
-            "size": 757,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_proj_ref_order_by_star_/sql.yql"
+            "checksum": "763eec03e3f4f641af0f36b24fe6cd01",
+            "size": 764,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_proj_ref_order_by_star_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_proj_ref_order_by_union_all_expr]": [
         {
-            "checksum": "459b7fa82e1f4beb032970a04dfbf247",
-            "size": 1288,
-            "uri": "https://{canondata_backend}/1925842/d62b5f5680f5595a57320ac8dac15190bfb0862a/resource.tar.gz#test_sql2yql.test_pg-select_proj_ref_order_by_union_all_expr_/sql.yql"
+            "checksum": "a775b0fd8b7d26b3965dd60b67d76771",
+            "size": 1295,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_proj_ref_order_by_union_all_expr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_qstarref1]": [
@@ -11978,37 +11978,37 @@
     ],
     "test_sql2yql.test[pg-select_sort_project_expr]": [
         {
-            "checksum": "298b88c050f9caac9022bd4a2e4757c8",
-            "size": 728,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_expr_/sql.yql"
+            "checksum": "cc775831b32e7d619263564120711c69",
+            "size": 735,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_expr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_sort_project_new]": [
         {
-            "checksum": "01771d8e67f87ed4d56e72a75734c141",
-            "size": 716,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_new_/sql.yql"
+            "checksum": "a8fd3450da63ff5ed8bd501d5e10d22e",
+            "size": 723,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_new_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_sort_project_same]": [
         {
-            "checksum": "6aa568063d6d7f18c0888db3fd4b1664",
-            "size": 716,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_same_/sql.yql"
+            "checksum": "dbd92bcea8c9fe6da441e96ec553bb92",
+            "size": 723,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_same_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_sort_project_same_asc]": [
         {
-            "checksum": "6aa568063d6d7f18c0888db3fd4b1664",
-            "size": 716,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_same_asc_/sql.yql"
+            "checksum": "dbd92bcea8c9fe6da441e96ec553bb92",
+            "size": 723,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_same_asc_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_sort_project_same_desc]": [
         {
-            "checksum": "1338653464a746beeec1a916577c7f4a",
-            "size": 717,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_same_desc_/sql.yql"
+            "checksum": "1541b693712e5152f78f2cfb03d98141",
+            "size": 724,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_sort_project_same_desc_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_starref1]": [
@@ -12125,9 +12125,9 @@
     ],
     "test_sql2yql.test[pg-select_win_column_order_by]": [
         {
-            "checksum": "7d669d28202b27ab956341715e36d067",
-            "size": 869,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_win_column_order_by_/sql.yql"
+            "checksum": "e7b228b86cf5242ee249064aa016ff5e",
+            "size": 876,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_column_order_by_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_column_partition_by]": [
@@ -12139,65 +12139,65 @@
     ],
     "test_sql2yql.test[pg-select_win_count]": [
         {
-            "checksum": "cbe87b5b8bc054045ffd06122d0b9543",
-            "size": 2060,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_count_/sql.yql"
+            "checksum": "4257b20faca53822904d515967c21672",
+            "size": 2067,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_count_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_count_all]": [
         {
-            "checksum": "f0fb7498cc20ecc4b2c2cc674bae5399",
-            "size": 1958,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_count_all_/sql.yql"
+            "checksum": "b0bf3657111b93285675f0cf6ac810dd",
+            "size": 1965,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_count_all_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_expr_agg]": [
         {
-            "checksum": "c3aa19dd6681f66d8c949f11be73c7ca",
-            "size": 1168,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_agg_/sql.yql"
+            "checksum": "beebb48592e9ac82ba746de439cff34d",
+            "size": 1175,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_agg_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_expr_agg_order]": [
         {
-            "checksum": "719bf094f56e4cc740de2c911971bde9",
-            "size": 1310,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_agg_order_/sql.yql"
+            "checksum": "df99692e21ede96d236bd8e3f2d93f17",
+            "size": 1324,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_agg_order_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_expr_lead]": [
         {
-            "checksum": "016e2a8be43c177590f7a07c01a3816c",
-            "size": 1166,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_lead_/sql.yql"
+            "checksum": "8e7adf1a0cd236b5633852539ce038e2",
+            "size": 1173,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_lead_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_expr_order]": [
         {
-            "checksum": "83236168bdebd14ae70c4c9c83031024",
-            "size": 1205,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_order_/sql.yql"
+            "checksum": "3f4a7d63dc800923388bdb988118f129",
+            "size": 1219,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_order_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_expr_partition]": [
         {
-            "checksum": "fbefe31aee94d9161f15369e92f92caa",
-            "size": 1201,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_partition_/sql.yql"
+            "checksum": "fde4a5b98c5ad38fa54c6ad21f733ac5",
+            "size": 1208,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_expr_partition_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_first_last_value]": [
         {
-            "checksum": "c6da940d977c3b0a987402c29ff5e961",
-            "size": 1078,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_first_last_value_/sql.yql"
+            "checksum": "44098561d0328f209bd11fd50eb083ca",
+            "size": 1092,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_first_last_value_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_frame]": [
         {
-            "checksum": "6685ca65d4b1c33ebe2df4ec59bcdba1",
-            "size": 4143,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-select_win_frame_/sql.yql"
+            "checksum": "4d2eff72072ba305448c0a15f3980f7c",
+            "size": 4234,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_frame_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_lead_lag]": [
@@ -12209,37 +12209,37 @@
     ],
     "test_sql2yql.test[pg-select_win_max]": [
         {
-            "checksum": "99d94eb01e7a1d781180e2b8c23ada28",
-            "size": 1988,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_max_/sql.yql"
+            "checksum": "5de1fd0d447586c23cfc455f35e1e259",
+            "size": 1995,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_max_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_max_null]": [
         {
-            "checksum": "7e50f9c43276b651df06f21111487133",
-            "size": 2052,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_max_null_/sql.yql"
+            "checksum": "4f66d49b29e7ddbb191fddf1e96ca8bb",
+            "size": 2059,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_max_null_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_min]": [
         {
-            "checksum": "ffc8ee42245e867f8569d5e06df387cb",
-            "size": 1988,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_min_/sql.yql"
+            "checksum": "27118ba16e0e105140d3353b11d92d1f",
+            "size": 1995,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_min_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_min_null]": [
         {
-            "checksum": "f0e5484b7bf38936c1b660a0cfa111cc",
-            "size": 2052,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_min_null_/sql.yql"
+            "checksum": "c4b029cd26b7e78eb9f3718d4927422b",
+            "size": 2059,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_min_null_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_partition_sort]": [
         {
-            "checksum": "29e820aa0ac73c8a62da653030c6c14d",
-            "size": 1347,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_partition_sort_/sql.yql"
+            "checksum": "ab234aba28920fb9a46f1e71f2f5485c",
+            "size": 1368,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_partition_sort_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_rank]": [
@@ -12251,9 +12251,9 @@
     ],
     "test_sql2yql.test[pg-select_win_rank_order]": [
         {
-            "checksum": "b6b83a07320c91f182d917a7bce00d65",
-            "size": 961,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_rank_order_/sql.yql"
+            "checksum": "6cce4b22d03ee172f01ccebc85b333e2",
+            "size": 968,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_rank_order_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_row_number]": [
@@ -12265,23 +12265,23 @@
     ],
     "test_sql2yql.test[pg-select_win_sum]": [
         {
-            "checksum": "f471e79dc3850ff28726ca96dafb4e7c",
-            "size": 1988,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_sum_/sql.yql"
+            "checksum": "8251677ba632fd936ac9753e8c4992e4",
+            "size": 1995,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_sum_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_win_sum_null]": [
         {
-            "checksum": "f3160efdacda4a13fbd0b1e34ff19347",
-            "size": 2052,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-select_win_sum_null_/sql.yql"
+            "checksum": "edc60171a35691da2c1618230c8b6485",
+            "size": 2059,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-select_win_sum_null_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-select_yql_type]": [
         {
-            "checksum": "7447752d11b2fc790e27004b7112fe31",
-            "size": 1975,
-            "uri": "https://{canondata_backend}/1937367/379ba745ff59ebd29c817a5b281c005a67df3be4/resource.tar.gz#test_sql2yql.test_pg-select_yql_type_/sql.yql"
+            "checksum": "73f34c23ea7c3db4c9283db989293f0b",
+            "size": 1996,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-select_yql_type_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-set_of_as_records]": [
@@ -12319,6 +12319,20 @@
             "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-single_input_filter_over_join_/sql.yql"
         }
     ],
+    "test_sql2yql.test[pg-sort_nulls_priority]": [
+        {
+            "checksum": "e100f3dd34b69e02967feae25c390220",
+            "size": 1417,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-sort_nulls_priority_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[pg-sort_nulls_priority_window]": [
+        {
+            "checksum": "bf444fc4d08a8381ccff8e93e1fd3f35",
+            "size": 1886,
+            "uri": "https://{canondata_backend}/1942671/daea59b4a7742f086d6115667ab409a67fea1727/resource.tar.gz#test_sql2yql.test_pg-sort_nulls_priority_window_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[pg-str_lookup_pg]": [
         {
             "checksum": "15ae2647f3110534a4e0e10d89a19e35",
@@ -12335,16 +12349,16 @@
     ],
     "test_sql2yql.test[pg-sublink_columns_in_test_expr_columns]": [
         {
-            "checksum": "cf6a3c51ec2a874f00dd8bb248364c84",
-            "size": 2907,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-sublink_columns_in_test_expr_columns_/sql.yql"
+            "checksum": "99fc64efbc3e23411701b885c637bf3d",
+            "size": 2914,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-sublink_columns_in_test_expr_columns_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-sublink_columns_in_test_expr_columns_corr]": [
         {
-            "checksum": "15c73a50e9b5dd23ec1ac1f0adf80a20",
-            "size": 2862,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-sublink_columns_in_test_expr_columns_corr_/sql.yql"
+            "checksum": "841ef60a1fd27365bfcb4c0fc36eb2dc",
+            "size": 2869,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-sublink_columns_in_test_expr_columns_corr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-sublink_having_all]": [
@@ -12384,37 +12398,37 @@
     ],
     "test_sql2yql.test[pg-sublink_order_all_corr]": [
         {
-            "checksum": "77434dd71dc6d5a8add39c26a60c4bc1",
-            "size": 1175,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-sublink_order_all_corr_/sql.yql"
+            "checksum": "b44b6ac410795ff8fbee2047d3380cf0",
+            "size": 1189,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-sublink_order_all_corr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-sublink_order_any_corr]": [
         {
-            "checksum": "a938420b68d688d55b2910cb327859aa",
-            "size": 1175,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-sublink_order_any_corr_/sql.yql"
+            "checksum": "9768f9a5967460a51a51895285f82267",
+            "size": 1189,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-sublink_order_any_corr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-sublink_order_exists_corr]": [
         {
-            "checksum": "15049dd4f7e0216b4e337ee76a578f1a",
-            "size": 1384,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-sublink_order_exists_corr_/sql.yql"
+            "checksum": "f41ed4ce5db7806e331e4ca54519bd69",
+            "size": 1398,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-sublink_order_exists_corr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-sublink_order_expr_corr]": [
         {
-            "checksum": "50a79839b91b078688f0d21be23a0707",
-            "size": 1018,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-sublink_order_expr_corr_/sql.yql"
+            "checksum": "a48a21660b1dcce31ec1b62982b4ae76",
+            "size": 1025,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-sublink_order_expr_corr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-sublink_order_in_corr]": [
         {
-            "checksum": "00280f5d18f9bb89b5db4c75825ae724",
-            "size": 1182,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-sublink_order_in_corr_/sql.yql"
+            "checksum": "58d1fc533d4d5899c261cd336832f13f",
+            "size": 1196,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-sublink_order_in_corr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-sublink_projection_all_corr]": [
@@ -12440,9 +12454,9 @@
     ],
     "test_sql2yql.test[pg-sublink_projection_array_corr]": [
         {
-            "checksum": "7b5b52d304637fd42c41b06bf4306444",
-            "size": 2516,
-            "uri": "https://{canondata_backend}/1936947/fba4a8aeb243783f27d57f7d9d3fa25582d6472b/resource.tar.gz#test_sql2yql.test_pg-sublink_projection_array_corr_/sql.yql"
+            "checksum": "e9fc4bd20d0627ec95409388787d69a1",
+            "size": 2530,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-sublink_projection_array_corr_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-sublink_projection_exists_corr]": [
@@ -12545,58 +12559,58 @@
     ],
     "test_sql2yql.test[pg-tpcds-q01]": [
         {
-            "checksum": "da5754adddfc6e78b4dd9cb3bff0813a",
-            "size": 3595,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q01_/sql.yql"
+            "checksum": "ed17ddd8d0333e6167741f14d10051e3",
+            "size": 3602,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q01_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q02]": [
         {
-            "checksum": "fac90c76fc8b9d220fc56d0bed58ed18",
-            "size": 11111,
-            "uri": "https://{canondata_backend}/1777230/0c388884f13a4e27fa979282c1cb1b2af98b6a1e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q02_/sql.yql"
+            "checksum": "27333b11683a4eef35a5184860b98d1f",
+            "size": 11118,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q02_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q03]": [
         {
-            "checksum": "0284b14e01b416001b7248de71ac35ef",
-            "size": 2058,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q03_/sql.yql"
+            "checksum": "79f27eb4aaf70cefe21310a2eeaf69db",
+            "size": 2079,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q03_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q04]": [
         {
-            "checksum": "6b90610897e83b3fea8fc9fb9266a7cf",
-            "size": 42350,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q04_/sql.yql"
+            "checksum": "c142c24f62698d04e88b6b0bcacc5257",
+            "size": 42378,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q04_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q05]": [
         {
-            "checksum": "4ea77fa397cbdfdca2a1a951d7f81b5e",
-            "size": 14006,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q05_/sql.yql"
+            "checksum": "891591ac3f26b23b69677cc70f270ac6",
+            "size": 14020,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q05_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q06]": [
         {
-            "checksum": "fcff16ab31be112ab83bf88439e3d16b",
-            "size": 3402,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q06_/sql.yql"
+            "checksum": "f640cc565e5c05e5d900c52290583a33",
+            "size": 3416,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q06_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q07]": [
         {
-            "checksum": "15cbda77593dd990c0bde9a9157719e9",
-            "size": 2732,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q07_/sql.yql"
+            "checksum": "318b01e746664a880c3c75e5ce54859c",
+            "size": 2739,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q07_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q08]": [
         {
-            "checksum": "45dfc09eef76c47879cac931b5a7639f",
-            "size": 18685,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q08_/sql.yql"
+            "checksum": "1f18d72ecf7480123117759602fb62dc",
+            "size": 18692,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q08_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q09]": [
@@ -12608,23 +12622,23 @@
     ],
     "test_sql2yql.test[pg-tpcds-q10]": [
         {
-            "checksum": "57f33b260e73218d397bc03bf95d07ec",
-            "size": 6577,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q10_/sql.yql"
+            "checksum": "83acacf599c3951eaed27bddcaf6e9ac",
+            "size": 6633,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q10_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q11]": [
         {
-            "checksum": "9a233f52aaceb56df183a851c29e561b",
-            "size": 19005,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q11_/sql.yql"
+            "checksum": "1de5cb1449c0f7b5282ea19d53dc36d9",
+            "size": 19033,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q11_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q12]": [
         {
-            "checksum": "ed1e288ea3cf5bd919c91bb431937142",
-            "size": 3147,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q12_/sql.yql"
+            "checksum": "02c32fe3f82f62df31ea415d37515a50",
+            "size": 3182,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q12_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q13]": [
@@ -12636,100 +12650,100 @@
     ],
     "test_sql2yql.test[pg-tpcds-q14]": [
         {
-            "checksum": "e6d76176759aa147f0cec9d416139dec",
-            "size": 46516,
-            "uri": "https://{canondata_backend}/1777230/0c388884f13a4e27fa979282c1cb1b2af98b6a1e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q14_/sql.yql"
+            "checksum": "7eea0ed33b3f7229bcd5eef44ea6f56c",
+            "size": 46572,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q14_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q15]": [
         {
-            "checksum": "d45399497ae98ae0e2ec6b463c958d9e",
-            "size": 2578,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q15_/sql.yql"
+            "checksum": "11cf722d7dbf3c31c89660e727ebc5a7",
+            "size": 2585,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q15_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q16]": [
         {
-            "checksum": "5b3847528daf3865e98a9d4c08519e1b",
-            "size": 3745,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q16_/sql.yql"
+            "checksum": "63d60d081cdce0add9b2b5650f060c66",
+            "size": 3752,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q16_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q17]": [
         {
-            "checksum": "65ac5ad86a25ecda4766f307045a436a",
-            "size": 5286,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q17_/sql.yql"
+            "checksum": "7b897f1c6b088fbd1aef45cd6ae8baf8",
+            "size": 5307,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q17_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q18]": [
         {
-            "checksum": "2dec4fcf03c96d7c0513ed1bb7b373b6",
-            "size": 5292,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q18_/sql.yql"
+            "checksum": "5b36404e40014cc109ad4665cec4d8e6",
+            "size": 5320,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q18_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q19]": [
         {
-            "checksum": "bfa151419cf5b27740c0a85fd9fe782f",
-            "size": 3298,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q19_/sql.yql"
+            "checksum": "abf23cdb1bc7b218df3262f7a43dafca",
+            "size": 3333,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q19_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q20]": [
         {
-            "checksum": "0ff8799f0504cd5001e8edcc170d31df",
-            "size": 3155,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q20_/sql.yql"
+            "checksum": "107236e161aa4a3db9d32d0decd41dfd",
+            "size": 3190,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q20_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q21]": [
         {
-            "checksum": "e974b921f3ef1a97cfe9a60c6dfaf141",
-            "size": 3789,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q21_/sql.yql"
+            "checksum": "c7c3cf8cecb9d08f756ffddc49815b8d",
+            "size": 3803,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q21_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q22]": [
         {
-            "checksum": "4f08b3a62095a8efafe5ea9a834c3fd0",
-            "size": 2160,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q22_/sql.yql"
+            "checksum": "42cf9571fc5bd8a00e897f9902f8a9d0",
+            "size": 2195,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q22_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q23]": [
         {
-            "checksum": "a679e5b94075640eab61777d3c2fb310",
-            "size": 26179,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q23_/sql.yql"
+            "checksum": "68e5c08fec790de41e86a114b5955fa7",
+            "size": 26200,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q23_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q24]": [
         {
-            "checksum": "18bba2ee8348166d803cf6d3fa65c8cf",
-            "size": 15103,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q24_/sql.yql"
+            "checksum": "d5f41b1043fd90ab1dbdb4de2637af81",
+            "size": 15145,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q24_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q25]": [
         {
-            "checksum": "48373b11f11a4d4fc3ddd20d95933821",
-            "size": 4291,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q25_/sql.yql"
+            "checksum": "721097a12f6de1b0bc88a4c7be8477e9",
+            "size": 4319,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q25_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q26]": [
         {
-            "checksum": "94ca5e7036440d89cb05ed556430f517",
-            "size": 2741,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q26_/sql.yql"
+            "checksum": "299e5493a2df2ccc69136ec3628de70a",
+            "size": 2748,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q26_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q27]": [
         {
-            "checksum": "098d5a0a48b00c187d2d7ca327d1489a",
-            "size": 3072,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q27_/sql.yql"
+            "checksum": "8e3ba637056c25bb307f8a3bed127d84",
+            "size": 3086,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q27_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q28]": [
@@ -12741,23 +12755,23 @@
     ],
     "test_sql2yql.test[pg-tpcds-q29]": [
         {
-            "checksum": "c159fdebb2e903ec2233170373bbe19f",
-            "size": 4381,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q29_/sql.yql"
+            "checksum": "fdb7c0f5b3774da200a377a4d0a0c258",
+            "size": 4409,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q29_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q30]": [
         {
-            "checksum": "b53be39cd05d098bb26f579df2744a3c",
-            "size": 5845,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q30_/sql.yql"
+            "checksum": "4b6635dcd32fc0b05d85415fc1e4aef9",
+            "size": 5936,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q30_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q31]": [
         {
-            "checksum": "e791a41535bfe2dcc6f8d41e28628c42",
-            "size": 10237,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q31_/sql.yql"
+            "checksum": "d3e13d851e7ea8b018c699f405db8a15",
+            "size": 10244,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q31_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q32]": [
@@ -12769,37 +12783,37 @@
     ],
     "test_sql2yql.test[pg-tpcds-q33]": [
         {
-            "checksum": "55e1854a0068ce8148198798eaa72d31",
-            "size": 7847,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q33_/sql.yql"
+            "checksum": "2a4244dffa7547c50202dc5cc1b27eef",
+            "size": 7854,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q33_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q34]": [
         {
-            "checksum": "fd1fd8a2a6f2a85b5f99b6971ec1fb3f",
-            "size": 4904,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q34_/sql.yql"
+            "checksum": "15429242460923884c5acac9893b0d14",
+            "size": 4939,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q34_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q35]": [
         {
-            "checksum": "2535640df6a2e171c6be38bee3b0dc1e",
-            "size": 6259,
-            "uri": "https://{canondata_backend}/1777230/0c388884f13a4e27fa979282c1cb1b2af98b6a1e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q35_/sql.yql"
+            "checksum": "5982da15956848ebdf838d1d13c14019",
+            "size": 6301,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q35_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q36]": [
         {
-            "checksum": "8fc2c4c2f05608391ffba3f3b6d50541",
-            "size": 3263,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q36_/sql.yql"
+            "checksum": "353bb05746475c2dfbead5781b7f1377",
+            "size": 3291,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q36_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q37]": [
         {
-            "checksum": "b1b351d6e876ab6e34c3d67b6b6390e1",
-            "size": 2728,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q37_/sql.yql"
+            "checksum": "46c0df0108cb0653a2e637774072bef5",
+            "size": 2735,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q37_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q38]": [
@@ -12811,65 +12825,65 @@
     ],
     "test_sql2yql.test[pg-tpcds-q39]": [
         {
-            "checksum": "c7266bd0b90a7b546f031b37e81810b6",
-            "size": 15813,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q39_/sql.yql"
+            "checksum": "592340a6e8ae164c54ae1be09b267351",
+            "size": 15925,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q39_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q40]": [
         {
-            "checksum": "6702ed3d419be2c101c34bdfb1630212",
-            "size": 3742,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q40_/sql.yql"
+            "checksum": "0313992a3a50314341f84cf2b89f6ed0",
+            "size": 3756,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q40_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q41]": [
         {
-            "checksum": "b12230fb3f01ce3f8bfec5efb5dbbff6",
-            "size": 6175,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q41_/sql.yql"
+            "checksum": "0a022624984213c019cf484b4b61593c",
+            "size": 6182,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q41_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q42]": [
         {
-            "checksum": "0b2b65ee1230da8ce135498c524c3153",
-            "size": 2267,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q42_/sql.yql"
+            "checksum": "c124578514229100bf53560067a894a8",
+            "size": 2295,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q42_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q43]": [
         {
-            "checksum": "6013f87593e5fc3d42194c9a0c1f7fe5",
-            "size": 4132,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q43_/sql.yql"
+            "checksum": "5008a82d1c9aa3a4d6359980e6fd5b62",
+            "size": 4195,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q43_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q44]": [
         {
-            "checksum": "1bc2ca81bf26721ec6248418113658f7",
-            "size": 5719,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q44_/sql.yql"
+            "checksum": "61f12510ec476a21918a6de5d5405caa",
+            "size": 5740,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q44_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q45]": [
         {
-            "checksum": "5d3b776134f32c752efc5d489016888c",
-            "size": 3560,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q45_/sql.yql"
+            "checksum": "bcbf69786e44874ae50fba513f7cd569",
+            "size": 3574,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q45_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q46]": [
         {
-            "checksum": "99ec83341d7cec8cee421886f85976a8",
-            "size": 4932,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q46_/sql.yql"
+            "checksum": "8dbcfc4d29823e3d80d353b46195a8bd",
+            "size": 4967,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q46_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q47]": [
         {
-            "checksum": "797df4f73146716b7999bb43476513ac",
-            "size": 12141,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q47_/sql.yql"
+            "checksum": "345233231d0169330aab41ae946bde96",
+            "size": 12197,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q47_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q48]": [
@@ -12881,268 +12895,268 @@
     ],
     "test_sql2yql.test[pg-tpcds-q49]": [
         {
-            "checksum": "59346c3b36408ca61df623c4762f52e6",
-            "size": 13938,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q49_/sql.yql"
+            "checksum": "c59a879961ca88aa3642876d959fb103",
+            "size": 14008,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q49_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q50]": [
         {
-            "checksum": "ddac19924b8c975b988e07761e4d6114",
-            "size": 5796,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q50_/sql.yql"
+            "checksum": "802eb4f6b1236a471bb5bbf8859fd661",
+            "size": 5866,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q50_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q51]": [
         {
-            "checksum": "700148370fb110fbda25682bf5045206",
-            "size": 5474,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q51_/sql.yql"
+            "checksum": "7b47a3813171e09e64d6bf7c27f011c8",
+            "size": 5516,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q51_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q52]": [
         {
-            "checksum": "7b1c6cf4d685ad430875a94179b94a0c",
-            "size": 2140,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q52_/sql.yql"
+            "checksum": "b9a5ad713b092971fbb2641eef073792",
+            "size": 2161,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q52_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q53]": [
         {
-            "checksum": "2ba1b1228926482450f92fcdd8d8fbd7",
-            "size": 4899,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q53_/sql.yql"
+            "checksum": "42a6d4eacb2d79003b6c0ac39d4781f3",
+            "size": 4920,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q53_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q54]": [
         {
-            "checksum": "6b6a2c95e86852e6bac64bc1772bf6e4",
-            "size": 6531,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q54_/sql.yql"
+            "checksum": "464c3c8b8c0006bbe4e800eb8a22cba0",
+            "size": 6545,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q54_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q55]": [
         {
-            "checksum": "99d0f981cbd25ff2682114c732b1c853",
-            "size": 1854,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q55_/sql.yql"
+            "checksum": "e61a1205bdedcdff597f2e7133792a21",
+            "size": 1868,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q55_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q56]": [
         {
-            "checksum": "4a84f13ecec75664adb4bb9b27883530",
-            "size": 8043,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q56_/sql.yql"
+            "checksum": "9fa277ee42a6e9dc7f2c8921f5baa164",
+            "size": 8057,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q56_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q57]": [
         {
-            "checksum": "f1fab1b8c5d56d23dec4db73e8110d15",
-            "size": 11020,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q57_/sql.yql"
+            "checksum": "6ffb0e534306f0db1e19f4cdcd66aa15",
+            "size": 11076,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q57_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q58]": [
         {
-            "checksum": "9af2f2342b98857f035d3241bc1f2ff7",
-            "size": 10339,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q58_/sql.yql"
+            "checksum": "7cd419cd7dd75565b6cef8f97b075376",
+            "size": 10353,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q58_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q59]": [
         {
-            "checksum": "aacf9c2f3751b48e89665357a0fa812a",
-            "size": 10480,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q59_/sql.yql"
+            "checksum": "2a8f8a97d1192155bae772ff4ccfbf04",
+            "size": 10501,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q59_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q60]": [
         {
-            "checksum": "62c32a20c3dcae42881ba00de87b2c83",
-            "size": 7833,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q60_/sql.yql"
+            "checksum": "90f46187bc6dc9e0c1795764c85a3ace",
+            "size": 7847,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q60_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q61]": [
         {
-            "checksum": "941bea95f696fbeed87d2297d2762e27",
-            "size": 5960,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q61_/sql.yql"
+            "checksum": "d7cd7a4f04cb5b83a92ab065e05e78c1",
+            "size": 5974,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q61_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q62]": [
         {
-            "checksum": "00bd06d888acaf409309ab94fae93f5c",
-            "size": 4432,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q62_/sql.yql"
+            "checksum": "462b51943dae68d31bb7cc1cf1bc882c",
+            "size": 4453,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q62_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q63]": [
         {
-            "checksum": "003b374c55898b57ac6dc055ef3a2507",
-            "size": 4884,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q63_/sql.yql"
+            "checksum": "327414f62c967164668df0eb643a06fb",
+            "size": 4905,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q63_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q64]": [
         {
-            "checksum": "dcb6ac74c6b6dbf175a5436c35014f9e",
-            "size": 19165,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q64_/sql.yql"
+            "checksum": "e696213f978b1746caeafeeb8eae2238",
+            "size": 19200,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q64_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q65]": [
         {
-            "checksum": "fb9879a89a258189413ae3475b87a530",
-            "size": 4407,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q65_/sql.yql"
+            "checksum": "9e3a512138cea851e56eee499518ba2c",
+            "size": 4421,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q65_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q66]": [
         {
-            "checksum": "a6c6660d4a9c9022141624735929d225",
-            "size": 27592,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q66_/sql.yql"
+            "checksum": "7ef9a4e9bd2df3de578fa35de14cebfa",
+            "size": 27599,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q66_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q67]": [
         {
-            "checksum": "04a55201ad49135cafccc168eee8907e",
-            "size": 4522,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q67_/sql.yql"
+            "checksum": "da4b304eea15277c0bfe2a512a508cdb",
+            "size": 4599,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q67_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q68]": [
         {
-            "checksum": "bec3f8e9a1b5c4cb474d7e4597dd3a68",
-            "size": 4857,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q68_/sql.yql"
+            "checksum": "2e5c63f02938ac2886e64ff06b7597d0",
+            "size": 4871,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q68_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q69]": [
         {
-            "checksum": "c4c530c34ce6d623d8d63d0592eabcda",
-            "size": 5590,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q69_/sql.yql"
+            "checksum": "51043c29d7484dc888ba20083655ee3c",
+            "size": 5625,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q69_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q70]": [
         {
-            "checksum": "3ae618a6e334cba37132308fce3aeaa4",
-            "size": 4417,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q70_/sql.yql"
+            "checksum": "7bcc3151cde6e761991862e4c44b4441",
+            "size": 4452,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q70_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q71]": [
         {
-            "checksum": "22341e68636e177a8931b82f86cb0d21",
-            "size": 5014,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q71_/sql.yql"
+            "checksum": "f3e372b40ee3afb158f4aa3a0849d9a6",
+            "size": 5028,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q71_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q72]": [
         {
-            "checksum": "ea20a5d31151918968ca5ce8c5976531",
-            "size": 5286,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q72_/sql.yql"
+            "checksum": "a46dd3f455e0b116e2a03a76fe416ed5",
+            "size": 5314,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q72_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q73]": [
         {
-            "checksum": "9e8d1453d827fee32fedcd420a3dde87",
-            "size": 4319,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q73_/sql.yql"
+            "checksum": "b9a8ec7572d93d1e3ff37460bc94c60f",
+            "size": 4333,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q73_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q74]": [
         {
-            "checksum": "a64e0f5c6193caf3e41a4fc75097c075",
-            "size": 14490,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q74_/sql.yql"
+            "checksum": "5765967a8bccb8dc277acdca0e2c4fa7",
+            "size": 14511,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q74_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q75]": [
         {
-            "checksum": "a21845d1c227ec53a475c15db6214ab4",
-            "size": 15482,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q75_/sql.yql"
+            "checksum": "efc9cf3b4b26ac8fb82eaab2d39c4d2e",
+            "size": 15496,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q75_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q76]": [
         {
-            "checksum": "3723ace9e6e0dab64dfad16b16297611",
-            "size": 5563,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q76_/sql.yql"
+            "checksum": "8d6ed6fbac9cc4f05178f211d666d69b",
+            "size": 5598,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q76_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q77]": [
         {
-            "checksum": "48d341a94ad7ac3df26ac4e1be57f229",
-            "size": 11910,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q77_/sql.yql"
+            "checksum": "fd1420c9c98adb4db639017adaf7a98d",
+            "size": 11924,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q77_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q78]": [
         {
-            "checksum": "d4bfc2306fe9b1c3a330743c5da77079",
-            "size": 8893,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q78_/sql.yql"
+            "checksum": "892ca2af5ffc1de2ed5f53815bda8f6c",
+            "size": 8963,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q78_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q79]": [
         {
-            "checksum": "75fc1ac75c09dd1c69611fc99cda1acf",
-            "size": 4109,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q79_/sql.yql"
+            "checksum": "cae604fffa8b247a64883755b7b0afc3",
+            "size": 4137,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q79_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q80]": [
         {
-            "checksum": "77c34b6c88ee1d883e46f539e65ea6ee",
-            "size": 11235,
-            "uri": "https://{canondata_backend}/1924537/241614a38cd19f5ec51eff46c5a2901cec4d291e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q80_/sql.yql"
+            "checksum": "d68281a46601a89ee17c60beb22f304e",
+            "size": 11249,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q80_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q81]": [
         {
-            "checksum": "94ef955929a4865d4daeecf3b42b3d18",
-            "size": 6248,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q81_/sql.yql"
+            "checksum": "d3cfb74d2daec03e5af29ea8d5a4a7cc",
+            "size": 6360,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q81_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q82]": [
         {
-            "checksum": "56adbf7f1c2305cfc869f2a61afa631d",
-            "size": 2724,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q82_/sql.yql"
+            "checksum": "0b3320b03b25b20353255dfb2688c5c2",
+            "size": 2731,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q82_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q83]": [
         {
-            "checksum": "e71d739b199efeabeb767b61047e4671",
-            "size": 9536,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q83_/sql.yql"
+            "checksum": "5e4c4107e13f75c423cb9bec3bef7474",
+            "size": 9550,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q83_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q84]": [
         {
-            "checksum": "a26b2dabfaed8a6f5a7519c9d05f7772",
-            "size": 2681,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q84_/sql.yql"
+            "checksum": "4f00e56f4af0c328c84193c69d040670",
+            "size": 2688,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q84_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q85]": [
         {
-            "checksum": "1779d365c81e51e30dc655fe150deb3b",
-            "size": 6529,
-            "uri": "https://{canondata_backend}/1777230/0c388884f13a4e27fa979282c1cb1b2af98b6a1e/resource.tar.gz#test_sql2yql.test_pg-tpcds-q85_/sql.yql"
+            "checksum": "d131416a84257bd5bafcf5997b9177a7",
+            "size": 6557,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q85_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q86]": [
         {
-            "checksum": "78f2f7e53b48b91146562ed047ba6493",
-            "size": 2638,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q86_/sql.yql"
+            "checksum": "5fe836915b8bee4e9edb21d0db8fd2b7",
+            "size": 2666,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q86_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q87]": [
@@ -13161,58 +13175,58 @@
     ],
     "test_sql2yql.test[pg-tpcds-q89]": [
         {
-            "checksum": "653ce189f7a1c29143f8474c78f8208f",
-            "size": 4259,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q89_/sql.yql"
+            "checksum": "bef9aeb0f7241a7b53adf73a6cfcbf92",
+            "size": 4273,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q89_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q90]": [
         {
-            "checksum": "1ec6eea3390864247bca59f3d3739498",
-            "size": 4110,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q90_/sql.yql"
+            "checksum": "dad612744accbf7fa29e0ed0db381348",
+            "size": 4117,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q90_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q91]": [
         {
-            "checksum": "c102c501bf607a256342f0332132c164",
-            "size": 3688,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q91_/sql.yql"
+            "checksum": "527334c37f3fa2945d1695c1e8ad6af5",
+            "size": 3695,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q91_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q92]": [
         {
-            "checksum": "61bcf0f57db59f658a21efe8269a31ea",
-            "size": 3039,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q92_/sql.yql"
+            "checksum": "6608764843e06d64578ab9d04493824f",
+            "size": 3046,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q92_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q93]": [
         {
-            "checksum": "9d609567e89023fa1ef09cb9d3ad0582",
-            "size": 2513,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q93_/sql.yql"
+            "checksum": "e083059af38a73f095e5ce3c2dcd41bc",
+            "size": 2527,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q93_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q94]": [
         {
-            "checksum": "1a1687fe95c8e929ea663a9075140c19",
-            "size": 3511,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q94_/sql.yql"
+            "checksum": "48d4ed3839bf2e67288d8bc9526d89c6",
+            "size": 3518,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q94_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q95]": [
         {
-            "checksum": "b5ac91d47c34fa470069563cb3f75f93",
-            "size": 4951,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q95_/sql.yql"
+            "checksum": "6c833062920d31923e852c4c503a1a4c",
+            "size": 4958,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q95_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q96]": [
         {
-            "checksum": "bd4607ef11feb9d0862294b913cac449",
-            "size": 1931,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q96_/sql.yql"
+            "checksum": "0d07712a730582caffcfc4e19376d013",
+            "size": 1938,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q96_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q97]": [
@@ -13224,51 +13238,51 @@
     ],
     "test_sql2yql.test[pg-tpcds-q98]": [
         {
-            "checksum": "c8d8068e2a932d27b7f19bb737882b0e",
-            "size": 3111,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpcds-q98_/sql.yql"
+            "checksum": "14f2bde849b879ff3155561bd0cbb26f",
+            "size": 3146,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q98_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpcds-q99]": [
         {
-            "checksum": "94430501355317b1fc78cdc64b7c0686",
-            "size": 4451,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpcds-q99_/sql.yql"
+            "checksum": "bcc1de8a6a2938c361d14e9bcf9e410c",
+            "size": 4472,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpcds-q99_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q01]": [
         {
-            "checksum": "f006acdf82f1eaeb7f41bb58953a71ba",
-            "size": 2380,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q01_/sql.yql"
+            "checksum": "83deea7072a1347c8f1838b1680b58bc",
+            "size": 2394,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q01_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q02]": [
         {
-            "checksum": "17fb0f6cdb0a8599211b9dc8281f422c",
-            "size": 4028,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpch-q02_/sql.yql"
+            "checksum": "44c0fde427b6750858cdbdc9b4f06137",
+            "size": 4056,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q02_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q03]": [
         {
-            "checksum": "5634c003ac23128971759c401c9aa4f6",
-            "size": 2209,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q03_/sql.yql"
+            "checksum": "2253ca69b1068115b7a64d4e3d64de7d",
+            "size": 2223,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q03_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q04]": [
         {
-            "checksum": "df0951d9b6d2737b5bedb9139ab3dd82",
-            "size": 1861,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q04_/sql.yql"
+            "checksum": "c48344956db2c84c7ee5fbe8f2dba91b",
+            "size": 1868,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q04_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q05]": [
         {
-            "checksum": "4caffcaa784d218293c50412393dffa0",
-            "size": 2749,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q05_/sql.yql"
+            "checksum": "cb7da5de192b9fb9d47a6128900c905c",
+            "size": 2756,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q05_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q06]": [
@@ -13280,51 +13294,51 @@
     ],
     "test_sql2yql.test[pg-tpch-q07]": [
         {
-            "checksum": "84bf9ebbf3aa773f323c1695790105ad",
-            "size": 3642,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q07_/sql.yql"
+            "checksum": "c4c3a6c186e75a13137ec33c210c32dc",
+            "size": 3663,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q07_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q08]": [
         {
-            "checksum": "501211e17612a01139aa7d7fcc55846a",
-            "size": 3769,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q08_/sql.yql"
+            "checksum": "00757a8c5c3ce1cbb989b12bdc52fb98",
+            "size": 3776,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q08_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q09]": [
         {
-            "checksum": "5b03ab85f3afa66b81484b5c29c29a51",
-            "size": 3023,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q09_/sql.yql"
+            "checksum": "bf3342222bce2d9e4b392bf6f6bbd267",
+            "size": 3037,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q09_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q10]": [
         {
-            "checksum": "f55d016a013cd64e5442b1c2832a025a",
-            "size": 3010,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q10_/sql.yql"
+            "checksum": "a82509be63a59e59cb9602d127e70bb1",
+            "size": 3017,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q10_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q11]": [
         {
-            "checksum": "1291a1b7abeccfdc98f5866f329cec7b",
-            "size": 2879,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q11_/sql.yql"
+            "checksum": "ff13b703c946a0283baa345b3d75a138",
+            "size": 2886,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q11_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q12]": [
         {
-            "checksum": "0a497d952726d2aba2c3aec7875879d6",
-            "size": 2413,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q12_/sql.yql"
+            "checksum": "6dd5eb59ffe65263fca4b998e4fd592c",
+            "size": 2420,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q12_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q13]": [
         {
-            "checksum": "39cb4702fa033a6acaaba14ea82fad65",
-            "size": 1662,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpch-q13_/sql.yql"
+            "checksum": "e0b7e0722008be9c2689acab32693751",
+            "size": 1676,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q13_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q14]": [
@@ -13336,16 +13350,16 @@
     ],
     "test_sql2yql.test[pg-tpch-q15]": [
         {
-            "checksum": "c3314b91acdecc7b754f7381ac544657",
-            "size": 3495,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpch-q15_/sql.yql"
+            "checksum": "3851c53e80da8f3e5b49029b0f9c9761",
+            "size": 3502,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q15_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q16]": [
         {
-            "checksum": "baf8121e7d73f70a6eabdf25cfc52626",
-            "size": 2640,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q16_/sql.yql"
+            "checksum": "982100233ede69c3eaa367e9ae0899b0",
+            "size": 2668,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q16_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q17]": [
@@ -13357,9 +13371,9 @@
     ],
     "test_sql2yql.test[pg-tpch-q18]": [
         {
-            "checksum": "c38d31f8ec427671e119aa72732d5e60",
-            "size": 2724,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpch-q18_/sql.yql"
+            "checksum": "1e8fccdd06b144e36b6132303690f293",
+            "size": 2738,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q18_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q19]": [
@@ -13371,23 +13385,23 @@
     ],
     "test_sql2yql.test[pg-tpch-q20]": [
         {
-            "checksum": "0d1a6056fe30d8f90f1ba7677b823584",
-            "size": 3332,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q20_/sql.yql"
+            "checksum": "97c17fec3d00a6e913af4defd38135dc",
+            "size": 3339,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q20_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q21]": [
         {
-            "checksum": "d91b6a649ea27bf284214c48f1f93052",
-            "size": 3229,
-            "uri": "https://{canondata_backend}/1599023/af9c2f81df0601cf266a0926b5ce73b6101b9115/resource.tar.gz#test_sql2yql.test_pg-tpch-q21_/sql.yql"
+            "checksum": "0699bb969713c032d4a263c5d60ef054",
+            "size": 3243,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q21_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-tpch-q22]": [
         {
-            "checksum": "5bb4120887028f70742848720622d75c",
-            "size": 3173,
-            "uri": "https://{canondata_backend}/1871002/aa5733774deffaee951006652c15a43754548f46/resource.tar.gz#test_sql2yql.test_pg-tpch-q22_/sql.yql"
+            "checksum": "6de276e575e7766212f29a7103c9bbd3",
+            "size": 3180,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg-tpch-q22_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg-type_aliases]": [
@@ -13441,16 +13455,16 @@
     ],
     "test_sql2yql.test[pg_catalog-lambda]": [
         {
-            "checksum": "3a762deb072c530794191fdc864e9ce8",
-            "size": 1194,
-            "uri": "https://{canondata_backend}/1900335/425722d0f3dcb06655105a52bbf5ce0ea67fb6d5/resource.tar.gz#test_sql2yql.test_pg_catalog-lambda_/sql.yql"
+            "checksum": "b1fac1597e843ed44218fe79fae0c69c",
+            "size": 1201,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-lambda_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-pg_am_pg_syntax]": [
         {
-            "checksum": "f4768e2d8eb80d2972b6056b48ecc576",
-            "size": 688,
-            "uri": "https://{canondata_backend}/1871002/9140ba5c900f07690dd3e7f43001e6ff24bdb036/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_am_pg_syntax_/sql.yql"
+            "checksum": "a1f91002a26299a466fe4696db9b3daf",
+            "size": 695,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_am_pg_syntax_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-pg_auth_members]": [
@@ -13469,9 +13483,9 @@
     ],
     "test_sql2yql.test[pg_catalog-pg_database]": [
         {
-            "checksum": "5016020047c31d0a12c29d7b6fdd4b1a",
-            "size": 1319,
-            "uri": "https://{canondata_backend}/1936842/abd9f49421ab39ca2bf1b40d9a65f1c24f457928/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_database_/sql.yql"
+            "checksum": "ab7b325779909503063e924a087649eb",
+            "size": 1326,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_database_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-pg_description_pg_syntax]": [
@@ -13504,16 +13518,16 @@
     ],
     "test_sql2yql.test[pg_catalog-pg_namespace_pg_syntax]": [
         {
-            "checksum": "9e4c757133b4a0784952c6c967d504bb",
-            "size": 846,
-            "uri": "https://{canondata_backend}/1600758/c8681bdb1ea76420d75d8e7d6d355f3e5abf1d95/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_namespace_pg_syntax_/sql.yql"
+            "checksum": "563119294e49c7ba316004a191afff17",
+            "size": 853,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_namespace_pg_syntax_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-pg_roles]": [
         {
-            "checksum": "132648e5428703bb0329f35ed030555c",
-            "size": 1561,
-            "uri": "https://{canondata_backend}/1942671/97ffbf971de6e6c2db7e871e5dfde6d17befe266/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_roles_/sql.yql"
+            "checksum": "0357b10ceb2400459c6169518af5ec0a",
+            "size": 1568,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_roles_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-pg_set_config]": [
@@ -13532,9 +13546,9 @@
     ],
     "test_sql2yql.test[pg_catalog-pg_shdescription]": [
         {
-            "checksum": "3c2389e9a1d831db2944939e11919590",
-            "size": 871,
-            "uri": "https://{canondata_backend}/1937424/e8964bf325e3789f68bbeb40e42daa75bf189e76/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_shdescription_/sql.yql"
+            "checksum": "26492b94b2bb633c3fd57b30b68f1323",
+            "size": 878,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_shdescription_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-pg_stat_activity]": [
@@ -13546,9 +13560,9 @@
     ],
     "test_sql2yql.test[pg_catalog-pg_stat_database]": [
         {
-            "checksum": "76a9374e0363e44c5cffffc9d23b8f51",
-            "size": 1346,
-            "uri": "https://{canondata_backend}/1936842/55a7040ab1de9722f14ba790e6f8065314d91717/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_stat_database_/sql.yql"
+            "checksum": "b3dfc88a1e93ef00c5e18e29646b9025",
+            "size": 1353,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_stat_database_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-pg_stat_gssapi]": [
@@ -13567,9 +13581,9 @@
     ],
     "test_sql2yql.test[pg_catalog-pg_tablespace]": [
         {
-            "checksum": "755687f11614cdbe84381134ddba275c",
-            "size": 775,
-            "uri": "https://{canondata_backend}/1777230/5b7a099a288bb49a0012caf8ab53daf90cc81178/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_tablespace_/sql.yql"
+            "checksum": "11e655d7da9210c5aeaaaf01e418a96e",
+            "size": 782,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_tablespace_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-pg_timezone_abbrevs]": [
@@ -13616,9 +13630,9 @@
     ],
     "test_sql2yql.test[pg_catalog-table_constraints]": [
         {
-            "checksum": "e840ee7a11c3651288535d22aac9332f",
-            "size": 988,
-            "uri": "https://{canondata_backend}/1924537/72a6aff3b150d35ecfbb758aef00fdcd0984547b/resource.tar.gz#test_sql2yql.test_pg_catalog-table_constraints_/sql.yql"
+            "checksum": "036fce68a853ccc7236f6ce01754eaf8",
+            "size": 1002,
+            "uri": "https://{canondata_backend}/1781765/838f2ea2c0326d84b118c1ad739c96cc6935c327/resource.tar.gz#test_sql2yql.test_pg_catalog-table_constraints_/sql.yql"
         }
     ],
     "test_sql2yql.test[pg_catalog-tables]": [
diff --git a/ydb/library/yql/tests/sql/suites/pg/sort_nulls_priority.sql b/ydb/library/yql/tests/sql/suites/pg/sort_nulls_priority.sql
new file mode 100644
index 00000000000..f6b31a0cb2d
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg/sort_nulls_priority.sql
@@ -0,0 +1,13 @@
+--!syntax_pg
+SELECT
+*
+FROM
+(VALUES (null),(3),(1),(2)) as a(x)
+ORDER BY x nulls last;
+
+SELECT
+*
+FROM
+(VALUES (null),(3),(1),(2)) as a(x)
+ORDER BY x nulls first;
+
diff --git a/ydb/library/yql/tests/sql/suites/pg/sort_nulls_priority_window.sql b/ydb/library/yql/tests/sql/suites/pg/sort_nulls_priority_window.sql
new file mode 100644
index 00000000000..7659657828e
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg/sort_nulls_priority_window.sql
@@ -0,0 +1,13 @@
+--!syntax_pg
+SELECT
+x,array_agg(x) over (order by x nulls first)
+FROM
+(VALUES (null),(3),(1),(2)) a(x)
+ORDER BY x nulls first;
+
+SELECT
+x,array_agg(x) over (order by x nulls last)
+FROM
+(VALUES (null),(3),(1),(2)) a(x)
+ORDER BY x nulls last;
+
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
index 046853412e7..f4a2f32f23f 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
@@ -1870,9 +1870,9 @@
     ],
     "test.test[pg-pg_types_window2-default.txt-Debug]": [
         {
-            "checksum": "6f99762b830df5a8a5229a3f26a6acdb",
-            "size": 1078,
-            "uri": "https://{canondata_backend}/1777230/c0dea024de3606b855f19dd635aff5599b1de4ae/resource.tar.gz#test.test_pg-pg_types_window2-default.txt-Debug_/opt.yql"
+            "checksum": "a9c22b03f39469b3e1fc42f31f69da9b",
+            "size": 1124,
+            "uri": "https://{canondata_backend}/1937367/7ae40517becfc07ca4e0690912faa5a9833a3e89/resource.tar.gz#test.test_pg-pg_types_window2-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-pg_types_window2-default.txt-Plan]": [
@@ -2038,9 +2038,9 @@
     ],
     "test.test[pg-select_win_partition_sort-default.txt-Debug]": [
         {
-            "checksum": "015ed693faea9a14a8e92af176bd534c",
-            "size": 1344,
-            "uri": "https://{canondata_backend}/1777230/c0dea024de3606b855f19dd635aff5599b1de4ae/resource.tar.gz#test.test_pg-select_win_partition_sort-default.txt-Debug_/opt.yql"
+            "checksum": "b4043860729db15d0959ec3235a2b521",
+            "size": 1391,
+            "uri": "https://{canondata_backend}/1937367/7ae40517becfc07ca4e0690912faa5a9833a3e89/resource.tar.gz#test.test_pg-select_win_partition_sort-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_partition_sort-default.txt-Plan]": [
@@ -2059,9 +2059,9 @@
     ],
     "test.test[pg-select_win_sum_null-default.txt-Debug]": [
         {
-            "checksum": "ff287375109eb0858d0dc0fea6b85b28",
-            "size": 1670,
-            "uri": "https://{canondata_backend}/1777230/c0dea024de3606b855f19dd635aff5599b1de4ae/resource.tar.gz#test.test_pg-select_win_sum_null-default.txt-Debug_/opt.yql"
+            "checksum": "269a071b974037decba089b814a0bd4b",
+            "size": 1676,
+            "uri": "https://{canondata_backend}/1937367/7ae40517becfc07ca4e0690912faa5a9833a3e89/resource.tar.gz#test.test_pg-select_win_sum_null-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_sum_null-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part1/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part1/canondata/result.json
index 2530ce5c45f..8d0ea1c6a3f 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part1/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part1/canondata/result.json
@@ -2036,9 +2036,9 @@
     ],
     "test.test[pg-tpcds-q86-default.txt-Debug]": [
         {
-            "checksum": "3c3f2c6f53123f78411347ef51190ee5",
-            "size": 2896,
-            "uri": "https://{canondata_backend}/1925821/1e926635895bdf9ee5f829b9e493b85de73ba646/resource.tar.gz#test.test_pg-tpcds-q86-default.txt-Debug_/opt.yql"
+            "checksum": "fe32c6285178606312bfe74e2f8d89dc",
+            "size": 2902,
+            "uri": "https://{canondata_backend}/1784826/e906e9cfecf66fb66909331a665780d0320df0a5/resource.tar.gz#test.test_pg-tpcds-q86-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-tpcds-q86-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part10/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part10/canondata/result.json
index 6ae580a3f65..ec138a3e58f 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part10/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part10/canondata/result.json
@@ -1842,9 +1842,9 @@
     ],
     "test.test[pg-select_win_min-default.txt-Debug]": [
         {
-            "checksum": "75891185c1b273a4ed279391416dc548",
-            "size": 1540,
-            "uri": "https://{canondata_backend}/1924537/852bcba5756c333f9484e9976048bf4b9c984664/resource.tar.gz#test.test_pg-select_win_min-default.txt-Debug_/opt.yql"
+            "checksum": "e88fdc20d2cae2cf4d8fb6fe82f385f6",
+            "size": 1546,
+            "uri": "https://{canondata_backend}/1784826/80e3043af13420791521ed8b19e94a346c0b2f47/resource.tar.gz#test.test_pg-select_win_min-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_min-default.txt-Plan]": [
@@ -1968,9 +1968,9 @@
     ],
     "test.test[pg-tpcds-q49-default.txt-Debug]": [
         {
-            "checksum": "4b3bca5dd7bbf85096768d69f831ba13",
-            "size": 6277,
-            "uri": "https://{canondata_backend}/1924537/6033fa62c3628f7f8f85fe0b254eb896d2d9c2ce/resource.tar.gz#test.test_pg-tpcds-q49-default.txt-Debug_/opt.yql"
+            "checksum": "fc53d6e8a980e4279eda9d64f6cb76e0",
+            "size": 6317,
+            "uri": "https://{canondata_backend}/1924537/1805a74cfd2b36577866361e41330de6c2774f6a/resource.tar.gz#test.test_pg-tpcds-q49-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-tpcds-q49-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part11/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part11/canondata/result.json
index ac9f69d8455..5ccfc18efee 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part11/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part11/canondata/result.json
@@ -1653,9 +1653,9 @@
     ],
     "test.test[pg-select_win_column_order_by-default.txt-Debug]": [
         {
-            "checksum": "8624b88b8cf3805877bb6a86dcf88edd",
-            "size": 873,
-            "uri": "https://{canondata_backend}/1937027/642fd2ff53bdb0fed32ca89598d70c9c5848ac20/resource.tar.gz#test.test_pg-select_win_column_order_by-default.txt-Debug_/opt.yql"
+            "checksum": "88ba8e7c0217944affcc3a2c04993d9f",
+            "size": 879,
+            "uri": "https://{canondata_backend}/1784826/423768e553686c05753c4315370fa73fb7009697/resource.tar.gz#test.test_pg-select_win_column_order_by-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_column_order_by-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
index 0dfcb502ac7..d0c90e368a0 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
@@ -2159,9 +2159,9 @@
     ],
     "test.test[pg-select_win_first_last_value-default.txt-Debug]": [
         {
-            "checksum": "817d58b56dd6b5ec2ae532a157dc6efa",
-            "size": 1273,
-            "uri": "https://{canondata_backend}/1937492/811d887b0056119465b01f35349d6b6baaa383a7/resource.tar.gz#test.test_pg-select_win_first_last_value-default.txt-Debug_/opt.yql"
+            "checksum": "5b1a9a86fe94da38643419a3062f072f",
+            "size": 1319,
+            "uri": "https://{canondata_backend}/1937367/1a4f50f71a0d23fe536e908b9f8b0b7bb8a59dc7/resource.tar.gz#test.test_pg-select_win_first_last_value-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_first_last_value-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part13/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part13/canondata/result.json
index 537b79ad915..42b9f8e23b9 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part13/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part13/canondata/result.json
@@ -1802,9 +1802,9 @@
     ],
     "test.test[pg-select_win_expr_order-default.txt-Debug]": [
         {
-            "checksum": "946666039a4e2b8ef6d476b5329962de",
-            "size": 1942,
-            "uri": "https://{canondata_backend}/212715/e1bc1d6e31fa656365a738e65224a7c3f774bae6/resource.tar.gz#test.test_pg-select_win_expr_order-default.txt-Debug_/opt.yql"
+            "checksum": "b644ac35fcdbf386cc3b67ad13f75470",
+            "size": 1948,
+            "uri": "https://{canondata_backend}/1784826/835601ff0580cce01293c0a000590a8c4be25729/resource.tar.gz#test.test_pg-select_win_expr_order-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_expr_order-default.txt-Plan]": [
@@ -1823,9 +1823,9 @@
     ],
     "test.test[pg-select_win_max_null-default.txt-Debug]": [
         {
-            "checksum": "f1af264d40f615faaf36eafff6cd06c9",
-            "size": 1568,
-            "uri": "https://{canondata_backend}/1942525/ac46fec4341e8dbe9297ea09bff7c34708fa9891/resource.tar.gz#test.test_pg-select_win_max_null-default.txt-Debug_/opt.yql"
+            "checksum": "05b57239f2668f6d31273098c70dfc2e",
+            "size": 1574,
+            "uri": "https://{canondata_backend}/1784826/835601ff0580cce01293c0a000590a8c4be25729/resource.tar.gz#test.test_pg-select_win_max_null-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_max_null-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
index 1321cb67aa0..3ae29cd6008 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
@@ -1695,6 +1695,27 @@
             "uri": "https://{canondata_backend}/1923547/68f2fa8e051f31489bd496c183d28c4abddf9f68/resource.tar.gz#test.test_pg-set_of_as_records--Results_/results.txt"
         }
     ],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Debug]": [
+        {
+            "checksum": "48ba1a73b1c5913a409ca88cfcd9ddd1",
+            "size": 1925,
+            "uri": "https://{canondata_backend}/1814674/7cf44abddac9825f392f78aedde2aca2415a02cb/resource.tar.gz#test.test_pg-sort_nulls_priority_window-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Plan]": [
+        {
+            "checksum": "a3b64a2cf9903b3868a2dd88a18fc46e",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1814674/7cf44abddac9825f392f78aedde2aca2415a02cb/resource.tar.gz#test.test_pg-sort_nulls_priority_window-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority_window-default.txt-Results]": [
+        {
+            "checksum": "30fa282395de9c43b254454ef87d98c0",
+            "size": 2559,
+            "uri": "https://{canondata_backend}/1814674/7cf44abddac9825f392f78aedde2aca2415a02cb/resource.tar.gz#test.test_pg-sort_nulls_priority_window-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[pg-sublink_having_any-default.txt-Debug]": [
         {
             "checksum": "dae3b14e5e10477ef7f8027d7e04dfcb",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
index 32bab3b1c35..35c88e9abee 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
@@ -1917,9 +1917,9 @@
     ],
     "test.test[pg-select_win_frame-default.txt-Debug]": [
         {
-            "checksum": "7c908cf064c2375240f8d44ac4007a45",
-            "size": 2622,
-            "uri": "https://{canondata_backend}/1937027/16b7289b1b8f5fdff728155d836fa2b238949b2d/resource.tar.gz#test.test_pg-select_win_frame-default.txt-Debug_/opt.yql"
+            "checksum": "0d324357f85e49129414d789f6d9bc90",
+            "size": 2628,
+            "uri": "https://{canondata_backend}/1937027/b8ed197e5b5301a9d229bb19ca99ffb4a4ed1d5c/resource.tar.gz#test.test_pg-select_win_frame-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_frame-default.txt-Plan]": [
@@ -1938,9 +1938,9 @@
     ],
     "test.test[pg-select_win_min_null-default.txt-Debug]": [
         {
-            "checksum": "816d0252365e15ec90ec4a952bdfe88e",
-            "size": 1569,
-            "uri": "https://{canondata_backend}/1937027/a77580b1e56ef398f92f72d6528a92e8854e4ff6/resource.tar.gz#test.test_pg-select_win_min_null-default.txt-Debug_/opt.yql"
+            "checksum": "c991ac74108a3e0a86c46c2f47c3820c",
+            "size": 1575,
+            "uri": "https://{canondata_backend}/1937027/b8ed197e5b5301a9d229bb19ca99ffb4a4ed1d5c/resource.tar.gz#test.test_pg-select_win_min_null-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_min_null-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part2/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part2/canondata/result.json
index db54921a59a..cc2215e43da 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part2/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part2/canondata/result.json
@@ -1745,9 +1745,9 @@
     ],
     "test.test[pg-select_win_rank_order-default.txt-Debug]": [
         {
-            "checksum": "9e135bd8522b25fc828118cbff02e0a2",
-            "size": 1119,
-            "uri": "https://{canondata_backend}/1600758/21be35ce187a60dcbca55534dac4ed79b0cd8def/resource.tar.gz#test.test_pg-select_win_rank_order-default.txt-Debug_/opt.yql"
+            "checksum": "268e7eca17f56c43b7be06b44294981a",
+            "size": 1125,
+            "uri": "https://{canondata_backend}/1936947/f65c3422eccd78c099fedf785b7154244ee1373c/resource.tar.gz#test.test_pg-select_win_rank_order-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_rank_order-default.txt-Plan]": [
@@ -1829,9 +1829,9 @@
     ],
     "test.test[pg-tpcds-q67-default.txt-Debug]": [
         {
-            "checksum": "aecace4861c86142d5808f1d956ec43b",
-            "size": 3731,
-            "uri": "https://{canondata_backend}/1937001/c8a9b14244c714920429ce37ad8473ca4440a2f5/resource.tar.gz#test.test_pg-tpcds-q67-default.txt-Debug_/opt.yql"
+            "checksum": "2c721aa2aca5864e03759f6f239c30f2",
+            "size": 3737,
+            "uri": "https://{canondata_backend}/1937367/b9cc69342f24a7dae37d7b3020da65e88801276f/resource.tar.gz#test.test_pg-tpcds-q67-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-tpcds-q67-default.txt-Plan]": [
@@ -1850,9 +1850,9 @@
     ],
     "test.test[pg-tpcds-q70-default.txt-Debug]": [
         {
-            "checksum": "936337cae3a05492cf7e01e9d41a4a34",
-            "size": 2891,
-            "uri": "https://{canondata_backend}/1784117/5a96dbf955c8d8f189d27825dd2eeb4445231611/resource.tar.gz#test.test_pg-tpcds-q70-default.txt-Debug_/opt.yql"
+            "checksum": "831fb336bce360b7231413ad7ef82b74",
+            "size": 2897,
+            "uri": "https://{canondata_backend}/1937367/b9cc69342f24a7dae37d7b3020da65e88801276f/resource.tar.gz#test.test_pg-tpcds-q70-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-tpcds-q70-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part3/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part3/canondata/result.json
index b5efe2a5f6a..045836cf04e 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part3/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part3/canondata/result.json
@@ -1447,9 +1447,9 @@
     ],
     "test.test[pg-select_win_expr_agg_order-default.txt-Debug]": [
         {
-            "checksum": "cc9bff3679f61e413086a255c7d4b961",
-            "size": 2778,
-            "uri": "https://{canondata_backend}/1937424/1df9e5779b19e0b7eba6e215901b4c280373b4c6/resource.tar.gz#test.test_pg-select_win_expr_agg_order-default.txt-Debug_/opt.yql"
+            "checksum": "bb2af2950a77e4e1c97766cd80044a00",
+            "size": 2784,
+            "uri": "https://{canondata_backend}/1937027/75317da0d421e00d3d48ce75204f7abb83c1c323/resource.tar.gz#test.test_pg-select_win_expr_agg_order-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_expr_agg_order-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part5/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part5/canondata/result.json
index 8121ce92c14..6cd5800c899 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part5/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part5/canondata/result.json
@@ -2051,9 +2051,9 @@
     ],
     "test.test[pg-select_win_count-default.txt-Debug]": [
         {
-            "checksum": "bf941f58435830d8046119c9d1dbdf0c",
-            "size": 1837,
-            "uri": "https://{canondata_backend}/1924537/a216c900c9110aa2e7a4c99e87da2ae19ca0813a/resource.tar.gz#test.test_pg-select_win_count-default.txt-Debug_/opt.yql"
+            "checksum": "afb8a637e8f5ea31847047a5b7eadab4",
+            "size": 1843,
+            "uri": "https://{canondata_backend}/1871182/a0957e2fd49093cdf6f460fc5ec5cfe092ce16ef/resource.tar.gz#test.test_pg-select_win_count-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_count-default.txt-Plan]": [
@@ -2282,9 +2282,9 @@
     ],
     "test.test[pg-tpcds-q51-default.txt-Debug]": [
         {
-            "checksum": "aa2c4e0c96cf6fdf40e9c40ba8503efa",
-            "size": 6077,
-            "uri": "https://{canondata_backend}/1775059/3eec83f05edefb1e01aecad353735b7ca430d358/resource.tar.gz#test.test_pg-tpcds-q51-default.txt-Debug_/opt.yql"
+            "checksum": "98f952de658f2223a9c980fc3172a46f",
+            "size": 6100,
+            "uri": "https://{canondata_backend}/1775059/d4fe768f5b9607a8e70ce1514202623110dae18f/resource.tar.gz#test.test_pg-tpcds-q51-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-tpcds-q51-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part7/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part7/canondata/result.json
index d3aedf256c0..2487c929365 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part7/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part7/canondata/result.json
@@ -1676,9 +1676,9 @@
     ],
     "test.test[pg-pg_types_window1-default.txt-Debug]": [
         {
-            "checksum": "010bb388cfb32ff686a3e645e908c15c",
-            "size": 1365,
-            "uri": "https://{canondata_backend}/1924537/79148d522525a21a1c9544ebd102102e4de7bfbb/resource.tar.gz#test.test_pg-pg_types_window1-default.txt-Debug_/opt.yql"
+            "checksum": "a2b3bc21bb34d2e0a65a2ca85609048b",
+            "size": 1371,
+            "uri": "https://{canondata_backend}/1777230/a4da58da5bd55d2b287aab0bd5bcea728d6998a9/resource.tar.gz#test.test_pg-pg_types_window1-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-pg_types_window1-default.txt-Plan]": [
@@ -1760,9 +1760,9 @@
     ],
     "test.test[pg-select_win_sum-default.txt-Debug]": [
         {
-            "checksum": "36dac9561f8e7b70d4a2c66d00353e1f",
-            "size": 1641,
-            "uri": "https://{canondata_backend}/1924537/79148d522525a21a1c9544ebd102102e4de7bfbb/resource.tar.gz#test.test_pg-select_win_sum-default.txt-Debug_/opt.yql"
+            "checksum": "fe8d0049d503d46d1d2a7746a5902a0d",
+            "size": 1647,
+            "uri": "https://{canondata_backend}/1777230/a4da58da5bd55d2b287aab0bd5bcea728d6998a9/resource.tar.gz#test.test_pg-select_win_sum-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_sum-default.txt-Plan]": [
@@ -1779,6 +1779,27 @@
             "uri": "https://{canondata_backend}/1924537/79148d522525a21a1c9544ebd102102e4de7bfbb/resource.tar.gz#test.test_pg-select_win_sum-default.txt-Results_/results.txt"
         }
     ],
+    "test.test[pg-sort_nulls_priority-default.txt-Debug]": [
+        {
+            "checksum": "4720a69cdfd610dde2faa54f97b25ea3",
+            "size": 732,
+            "uri": "https://{canondata_backend}/1777230/a4da58da5bd55d2b287aab0bd5bcea728d6998a9/resource.tar.gz#test.test_pg-sort_nulls_priority-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority-default.txt-Plan]": [
+        {
+            "checksum": "a3b64a2cf9903b3868a2dd88a18fc46e",
+            "size": 922,
+            "uri": "https://{canondata_backend}/1777230/a4da58da5bd55d2b287aab0bd5bcea728d6998a9/resource.tar.gz#test.test_pg-sort_nulls_priority-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg-sort_nulls_priority-default.txt-Results]": [
+        {
+            "checksum": "726d0d5e355d6523e8f8d506f80312e0",
+            "size": 1744,
+            "uri": "https://{canondata_backend}/1777230/a4da58da5bd55d2b287aab0bd5bcea728d6998a9/resource.tar.gz#test.test_pg-sort_nulls_priority-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[pg-sublink_projection_any_corr-default.txt-Debug]": [
         {
             "checksum": "5064ad209e12f1bdba25e496307d8f4e",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
index dbd45fd1ab3..0c2b0186da7 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
@@ -2116,9 +2116,9 @@
     ],
     "test.test[pg-select_win_max-default.txt-Debug]": [
         {
-            "checksum": "4daeb3d6ad93e32bb93685efd08dbbcd",
-            "size": 1539,
-            "uri": "https://{canondata_backend}/1924537/4cd02efa4cd240b911f4825da2cdb528d41b5f3e/resource.tar.gz#test.test_pg-select_win_max-default.txt-Debug_/opt.yql"
+            "checksum": "7a127be08a9e3e3a619060b19d3022d6",
+            "size": 1545,
+            "uri": "https://{canondata_backend}/1871182/43e885a448c89e76bc1114d49e72bba613714f49/resource.tar.gz#test.test_pg-select_win_max-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_max-default.txt-Plan]": [
@@ -2179,9 +2179,9 @@
     ],
     "test.test[pg-tpcds-q36-default.txt-Debug]": [
         {
-            "checksum": "b446817cd6652fa3c48171c0a8070301",
-            "size": 3690,
-            "uri": "https://{canondata_backend}/1942415/e46af66b22611aa4c5bc0d3456afdd2102a1c02c/resource.tar.gz#test.test_pg-tpcds-q36-default.txt-Debug_/opt.yql"
+            "checksum": "b7f611fb8a6a6f7b6caf477163ee02c3",
+            "size": 3696,
+            "uri": "https://{canondata_backend}/1937367/be940cc8a5d171c16f8288fa512b537dcf069677/resource.tar.gz#test.test_pg-tpcds-q36-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-tpcds-q36-default.txt-Plan]": [
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part9/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part9/canondata/result.json
index 64433e92aa5..12a0259c148 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part9/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part9/canondata/result.json
@@ -1792,9 +1792,9 @@
     ],
     "test.test[pg-select_win_count_all-default.txt-Debug]": [
         {
-            "checksum": "d069ca26d6b7abdb187ed24932ae5337",
-            "size": 1726,
-            "uri": "https://{canondata_backend}/1903885/d7489869939f5eed8aa352f8fd72d52a3c467e5a/resource.tar.gz#test.test_pg-select_win_count_all-default.txt-Debug_/opt.yql"
+            "checksum": "a3fda10b76432d22d9c56467f9e33d60",
+            "size": 1732,
+            "uri": "https://{canondata_backend}/1781765/4a84b34a2de34810d2c62caacad9e30069b8f6f5/resource.tar.gz#test.test_pg-select_win_count_all-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[pg-select_win_count_all-default.txt-Plan]": [