YDB Import 628

commit_hash:bf81b3c601f0de11356bb3a1b285812bfb6d6d36

11 files changed, 30 insertions, 15 deletions

diff --git a/yql/essentials/tests/sql/sql2yql/canondata/result.json b/yql/essentials/tests/sql/sql2yql/canondata/result.json
index 238bb5a5bb..dac11c7bd3 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/result.json
+++ b/yql/essentials/tests/sql/sql2yql/canondata/result.json
@@ -8408,16 +8408,16 @@
     ],
     "test_sql2yql.test[join-cbo_4tables]": [
         {
-            "checksum": "1259880de97a6753985e841e2e0fca8e",
-            "size": 3360,
-            "uri": "https://{canondata_backend}/1937429/434276f26b2857be3c5ad3fdbbf877d2bf775ac5/resource.tar.gz#test_sql2yql.test_join-cbo_4tables_/sql.yql"
+            "checksum": "771362b9b84ed4085eedf439d2119a49",
+            "size": 3444,
+            "uri": "https://{canondata_backend}/1889210/7632dbbbf855933dd5095f5532a6f69c1a41db51/resource.tar.gz#test_sql2yql.test_join-cbo_4tables_/sql.yql"
         }
     ],
     "test_sql2yql.test[join-cbo_4tables_only_sorted_merge]": [
         {
-            "checksum": "3d6c4b81801d581fd7df5db4ed71e607",
-            "size": 3452,
-            "uri": "https://{canondata_backend}/1937429/434276f26b2857be3c5ad3fdbbf877d2bf775ac5/resource.tar.gz#test_sql2yql.test_join-cbo_4tables_only_sorted_merge_/sql.yql"
+            "checksum": "ae8361131478281c24b9fa00327e44a8",
+            "size": 3536,
+            "uri": "https://{canondata_backend}/1889210/7632dbbbf855933dd5095f5532a6f69c1a41db51/resource.tar.gz#test_sql2yql.test_join-cbo_4tables_only_sorted_merge_/sql.yql"
         }
     ],
     "test_sql2yql.test[join-commonjoin_unused_keys]": [
@@ -8716,9 +8716,9 @@
     ],
     "test_sql2yql.test[join-join_cbo_3_tables]": [
         {
-            "checksum": "ade505b64c963c1a666fadfa8b67ae84",
-            "size": 2714,
-            "uri": "https://{canondata_backend}/1937429/434276f26b2857be3c5ad3fdbbf877d2bf775ac5/resource.tar.gz#test_sql2yql.test_join-join_cbo_3_tables_/sql.yql"
+            "checksum": "26b51441dc8e31032014fde77d6c8cb8",
+            "size": 2798,
+            "uri": "https://{canondata_backend}/1889210/7632dbbbf855933dd5095f5532a6f69c1a41db51/resource.tar.gz#test_sql2yql.test_join-join_cbo_3_tables_/sql.yql"
         }
     ],
     "test_sql2yql.test[join-join_comp_common_table]": [
@@ -8751,9 +8751,9 @@
     ],
     "test_sql2yql.test[join-join_left_cbo]": [
         {
-            "checksum": "4bfc0f9649300fa6c4d2daab376e06de",
-            "size": 1793,
-            "uri": "https://{canondata_backend}/1937429/434276f26b2857be3c5ad3fdbbf877d2bf775ac5/resource.tar.gz#test_sql2yql.test_join-join_left_cbo_/sql.yql"
+            "checksum": "46674f0a5c0ae2dd31bc0986956dded9",
+            "size": 1877,
+            "uri": "https://{canondata_backend}/1889210/7632dbbbf855933dd5095f5532a6f69c1a41db51/resource.tar.gz#test_sql2yql.test_join-join_left_cbo_/sql.yql"
         }
     ],
     "test_sql2yql.test[join-join_no_correlation_in_order_by]": [
@@ -8765,9 +8765,9 @@
     ],
     "test_sql2yql.test[join-join_right_cbo]": [
         {
-            "checksum": "d69c6e50ec981ad24ac25c121958aee7",
-            "size": 1794,
-            "uri": "https://{canondata_backend}/1937429/434276f26b2857be3c5ad3fdbbf877d2bf775ac5/resource.tar.gz#test_sql2yql.test_join-join_right_cbo_/sql.yql"
+            "checksum": "1638f6fcf0c3682c44618aeaa8b450b1",
+            "size": 1878,
+            "uri": "https://{canondata_backend}/1889210/7632dbbbf855933dd5095f5532a6f69c1a41db51/resource.tar.gz#test_sql2yql.test_join-join_right_cbo_/sql.yql"
         }
     ],
     "test_sql2yql.test[join-join_semi_correlation_in_order_by]": [
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-cbo_4tables_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-cbo_4tables_/formatted.sql
index f2f556c10f..06ace3d634 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-cbo_4tables_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-cbo_4tables_/formatted.sql
@@ -1,4 +1,6 @@
 USE plato;
+PRAGMA warning("disable", "8001");
+-- CBO_MISSING_TABLE_STATS
 PRAGMA CostBasedOptimizer = "native";
 PRAGMA yt.MapJoinLimit = "1000";
 PRAGMA yt.LookupJoinLimit = "1000";
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-cbo_4tables_only_sorted_merge_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-cbo_4tables_only_sorted_merge_/formatted.sql
index 3516171d8a..f462aa3aa2 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-cbo_4tables_only_sorted_merge_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-cbo_4tables_only_sorted_merge_/formatted.sql
@@ -1,4 +1,6 @@
 USE plato;
+PRAGMA warning("disable", "8001");
+-- CBO_MISSING_TABLE_STATS
 PRAGMA CostBasedOptimizer = "native";
 PRAGMA yt.MapJoinLimit = "1000";
 PRAGMA yt.LookupJoinLimit = "1000";
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_cbo_3_tables_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_cbo_3_tables_/formatted.sql
index e6abbb842a..d451d47c47 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_cbo_3_tables_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_cbo_3_tables_/formatted.sql
@@ -1,4 +1,6 @@
 USE plato;
+PRAGMA warning("disable", "8001");
+-- CBO_MISSING_TABLE_STATS
 PRAGMA CostBasedOptimizer = "pg";
 
 SELECT
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_left_cbo_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_left_cbo_/formatted.sql
index 76772934e6..8c0bb071ed 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_left_cbo_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_left_cbo_/formatted.sql
@@ -1,4 +1,6 @@
 USE plato;
+PRAGMA warning("disable", "8001");
+-- CBO_MISSING_TABLE_STATS
 PRAGMA CostBasedOptimizer = "PG";
 
 SELECT
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_right_cbo_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_right_cbo_/formatted.sql
index 73bd429575..16db2ad1ca 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_right_cbo_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-join_right_cbo_/formatted.sql
@@ -1,4 +1,6 @@
 USE plato;
+PRAGMA warning("disable", "8001");
+-- CBO_MISSING_TABLE_STATS
 PRAGMA CostBasedOptimizer = "PG";
 
 SELECT
diff --git a/yql/essentials/tests/sql/suites/join/cbo_4tables.sql b/yql/essentials/tests/sql/suites/join/cbo_4tables.sql
index b96f5c3a79..256301bf5d 100644
--- a/yql/essentials/tests/sql/suites/join/cbo_4tables.sql
+++ b/yql/essentials/tests/sql/suites/join/cbo_4tables.sql
@@ -1,4 +1,5 @@
 USE plato;
+pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
 
 pragma CostBasedOptimizer="native";
 pragma yt.MapJoinLimit="1000";
diff --git a/yql/essentials/tests/sql/suites/join/cbo_4tables_only_sorted_merge.sql b/yql/essentials/tests/sql/suites/join/cbo_4tables_only_sorted_merge.sql
index 1dce1a70fa..e6712be68b 100644
--- a/yql/essentials/tests/sql/suites/join/cbo_4tables_only_sorted_merge.sql
+++ b/yql/essentials/tests/sql/suites/join/cbo_4tables_only_sorted_merge.sql
@@ -1,4 +1,5 @@
 USE plato;
+pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
 
 pragma CostBasedOptimizer="native";
 pragma yt.MapJoinLimit="1000";
diff --git a/yql/essentials/tests/sql/suites/join/join_cbo_3_tables.sql b/yql/essentials/tests/sql/suites/join/join_cbo_3_tables.sql
index 12d53dd38f..b848360746 100644
--- a/yql/essentials/tests/sql/suites/join/join_cbo_3_tables.sql
+++ b/yql/essentials/tests/sql/suites/join/join_cbo_3_tables.sql
@@ -1,4 +1,5 @@
 use plato;
+pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
 
 pragma CostBasedOptimizer="pg";
 
diff --git a/yql/essentials/tests/sql/suites/join/join_left_cbo.sql b/yql/essentials/tests/sql/suites/join/join_left_cbo.sql
index 81b974bdce..d3f698da2c 100644
--- a/yql/essentials/tests/sql/suites/join/join_left_cbo.sql
+++ b/yql/essentials/tests/sql/suites/join/join_left_cbo.sql
@@ -1,4 +1,5 @@
 use plato;
+pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
 
 pragma CostBasedOptimizer="PG";
 
diff --git a/yql/essentials/tests/sql/suites/join/join_right_cbo.sql b/yql/essentials/tests/sql/suites/join/join_right_cbo.sql
index 7b9378a9ec..99ed74da72 100644
--- a/yql/essentials/tests/sql/suites/join/join_right_cbo.sql
+++ b/yql/essentials/tests/sql/suites/join/join_right_cbo.sql
@@ -1,4 +1,5 @@
 use plato;
+pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
 
 pragma CostBasedOptimizer="PG";