Check custom error in xfail tests. Remove canonization from dq/hybrid tests

1. xfail тесты теперь должны содержать спец комментарий `custom error` с ожидаемым текстом ошибки 2. Все suites для xfail размечены спец. коментариями, некоторые тесты разбиты на несколько 3. Включены тесты с Python и Javascript udf для yt провайдера и переканонизированы (были отключены в github) 4. Для тяжелых xfail тестов аналогично убрана канонизация и включена проверка по спец. коментарию 5. Из dq_file/hybrid тестов убрана канонизация. Осталась только кросс-проверка результатов с yqlrun и блочным режимом 6. В dqrun теперь используется exception_policy вместо fail_policy (для корректной выдачи ошибок в тестах) commit_hash:a92b3835f86b0c01225e81e3f28bb6d11d8d67a3
author: udovichenko-r <udovichenko-r@yandex-team.com> 2024-11-23 22:29:07 +0300
committer: udovichenko-r <udovichenko-r@yandex-team.com> 2024-11-23 22:43:39 +0300
commit: 8b9f13e29dea8f76f11579aae5344ac571d5e604 (patch)
tree: 0449b096aa6444a36ba8cc5a3b3c64e0e7b94ed1
parent: 284518c9e820058795b9e7cc44ff26b25f3f455b (diff)
download: ydb-8b9f13e29dea8f76f11579aae5344ac571d5e604.tar.gz
151 files changed, 617 insertions, 646 deletions
diff --git a/build/platform/python/ldflags/ya.make b/build/platform/python/ldflags/ya.make
index 0115ed7256..b7a2d83a47 100644
--- a/build/platform/python/ldflags/ya.make
+++ b/build/platform/python/ldflags/ya.make
@@ -1,7 +1,5 @@
 RESOURCES_LIBRARY()
 
-SUBSCRIBER(g:contrib)
-
 IF (USE_SYSTEM_PYTHON)
     IF (OS_LINUX)
         LDFLAGS("-L$EXTERNAL_PYTHON_RESOURCE_GLOBAL/python/lib/x86_64-linux-gnu -lpython${PY_VERSION}")
diff --git a/library/python/type_info/ya.make b/library/python/type_info/ya.make
index 0f12c1b848..3688010d0e 100644
--- a/library/python/type_info/ya.make
+++ b/library/python/type_info/ya.make
@@ -1,9 +1,5 @@
 PY23_LIBRARY()
 
-SUBSCRIBER(
-    g:yt
-)
-
 PEERDIR(
     yt/python/yt/type_info
 )
diff --git a/yql/essentials/tests/common/test_framework/test_file_common.py b/yql/essentials/tests/common/test_framework/test_file_common.py
index b33076e561..3fc5cfe025 100644
--- a/yql/essentials/tests/common/test_framework/test_file_common.py
+++ b/yql/essentials/tests/common/test_framework/test_file_common.py
@@ -8,7 +8,7 @@ import yql.essentials.providers.common.proto.gateways_config_pb2 as gateways_con
 
 from google.protobuf import text_format
 from yql_utils import execute_sql, get_supported_providers, get_tables, get_files, get_http_files, \
-    get_pragmas, KSV_ATTR, is_xfail, get_param, YQLExecResult, yql_binary_path
+    get_pragmas, KSV_ATTR, is_xfail, get_param, YQLExecResult, yql_binary_path, do_custom_error_check
 from yqlrun import YQLRun
 
 from test_utils import get_parameters_json, DATA_PATH, replace_vars
@@ -70,7 +70,7 @@ def get_sql_query(provider, suite, case, config):
 
     pragmas.append(sql_query)
     sql_query = ';\n'.join(pragmas)
-    if 'Python' in sql_query or 'Javascript' in sql_query:
+    if provider != 'yt' and 'Javascript' in sql_query:
         pytest.skip('ScriptUdf')
 
     assert 'UseBlocks' not in sql_query, 'UseBlocks should not be used directly, only via ForceBlocks'
@@ -96,7 +96,7 @@ def run_file_no_cache(provider, suite, case, cfg, config, yql_http_file_server,
             content = table.content
         else:
             content = table.attr
-        if 'Python' in content or 'Javascript' in content:
+        if provider != 'yt' and 'Javascript' in content:
             pytest.skip('ScriptUdf')
 
     parameters = get_parameters_json(suite, config)
@@ -124,11 +124,8 @@ def run_file_no_cache(provider, suite, case, cfg, config, yql_http_file_server,
     fixed_stderr = res.std_err
     if xfail:
         assert res.execution_result.exit_code != 0
-        custom_error = re.search(r"/\* custom error:(.*)\*/", sql_query)
-        if custom_error:
-            err_string = custom_error.group(1)
-            assert res.std_err.find(err_string) != -1
-            fixed_stderr = None
+        do_custom_error_check(res, sql_query)
+        fixed_stderr = None
 
     fixed_result = YQLExecResult(res.std_out,
                                  fixed_stderr,
diff --git a/yql/essentials/tests/common/test_framework/udfs_deps/ya.make b/yql/essentials/tests/common/test_framework/udfs_deps/ya.make
index 7eddcac827..9f7135aa13 100644
--- a/yql/essentials/tests/common/test_framework/udfs_deps/ya.make
+++ b/yql/essentials/tests/common/test_framework/udfs_deps/ya.make
@@ -6,6 +6,7 @@ SET(
     yql/essentials/udfs/common/hyperloglog
     yql/essentials/udfs/common/pire
     yql/essentials/udfs/common/protobuf
+    yql/essentials/udfs/common/python/python3_small
     yql/essentials/udfs/common/re2
     yql/essentials/udfs/common/set
     yql/essentials/udfs/common/stat
diff --git a/yql/essentials/tests/common/test_framework/yql_utils.py b/yql/essentials/tests/common/test_framework/yql_utils.py
index 85970dab02..6e30af682c 100644
--- a/yql/essentials/tests/common/test_framework/yql_utils.py
+++ b/yql/essentials/tests/common/test_framework/yql_utils.py
@@ -50,6 +50,16 @@ def do_custom_query_check(res, sql_query):
     return True
 
 
+def do_custom_error_check(res, sql_query):
+    err_string = None
+    custom_error = re.search(r"/\* custom error:(.*)\*/", sql_query)
+    if custom_error:
+        err_string = custom_error.group(1).strip()
+    assert err_string, 'Expected custom error check in test.\nTest error: %s' % res.std_err
+    log('Custom error: ' + err_string)
+    assert err_string in res.std_err
+
+
 def get_gateway_cfg_suffix():
     default_suffix = None
     return get_param('gateway_config_suffix', default_suffix) or ''
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/result.json b/yql/essentials/tests/sql/sql2yql/canondata/result.json
index c178530713..ae251f716b 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/result.json
+++ b/yql/essentials/tests/sql/sql2yql/canondata/result.json
@@ -7923,6 +7923,13 @@
             "uri": "https://{canondata_backend}/1784117/d56ae82ad9d30397a41490647be1bd2124718f98/resource.tar.gz#test_sql2yql.test_insert-append_missing_null_/sql.yql"
         }
     ],
+    "test_sql2yql.test[insert-append_proto_fail]": [
+        {
+            "checksum": "6e02426ad7ddd42f68264f2e7361061e",
+            "size": 1106,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_insert-append_proto_fail_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[insert-append_sorted]": [
         {
             "checksum": "10865e639dee26d8703b2bae2b2c0bec",
@@ -7930,6 +7937,20 @@
             "uri": "https://{canondata_backend}/1936947/659b615f15086142a8960946dabd06b519d43335/resource.tar.gz#test_sql2yql.test_insert-append_sorted_/sql.yql"
         }
     ],
+    "test_sql2yql.test[insert-append_view_fail]": [
+        {
+            "checksum": "6e02426ad7ddd42f68264f2e7361061e",
+            "size": 1106,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_insert-append_view_fail_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[insert-append_with_read_udf_fail]": [
+        {
+            "checksum": "6e02426ad7ddd42f68264f2e7361061e",
+            "size": 1106,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_insert-append_with_read_udf_fail_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[insert-double_append_to_anonymous]": [
         {
             "checksum": "3365759278a1fc82f47bf9b247cbf40b",
@@ -7986,6 +8007,34 @@
             "uri": "https://{canondata_backend}/212715/297d47f4f676b8e994e99293fc91643b6d66984d/resource.tar.gz#test_sql2yql.test_insert-keepmeta_/sql.yql"
         }
     ],
+    "test_sql2yql.test[insert-keepmeta_nonstrict_fail]": [
+        {
+            "checksum": "8b829b6434835296e73408e955355ca4",
+            "size": 1120,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_insert-keepmeta_nonstrict_fail_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[insert-keepmeta_proto_fail]": [
+        {
+            "checksum": "8b829b6434835296e73408e955355ca4",
+            "size": 1120,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_insert-keepmeta_proto_fail_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[insert-keepmeta_view_fail]": [
+        {
+            "checksum": "8b829b6434835296e73408e955355ca4",
+            "size": 1120,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_insert-keepmeta_view_fail_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[insert-keepmeta_with_read_udf_fail]": [
+        {
+            "checksum": "8b829b6434835296e73408e955355ca4",
+            "size": 1120,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_insert-keepmeta_with_read_udf_fail_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[insert-literals_to_string]": [
         {
             "checksum": "2166c3898858efe4aacfd2961efe5045",
@@ -8014,6 +8063,13 @@
             "uri": "https://{canondata_backend}/1936947/659b615f15086142a8960946dabd06b519d43335/resource.tar.gz#test_sql2yql.test_insert-override_/sql.yql"
         }
     ],
+    "test_sql2yql.test[insert-override_view_fail]": [
+        {
+            "checksum": "d5fb36d29981a2435a244e8909120bd1",
+            "size": 1105,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_insert-override_view_fail_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[insert-part_sortness]": [
         {
             "checksum": "e68353148f13a7416a6002e25708d5bc",
@@ -16575,6 +16631,13 @@
             "uri": "https://{canondata_backend}/1784117/d56ae82ad9d30397a41490647be1bd2124718f98/resource.tar.gz#test_sql2yql.test_schema-select_all_inferschema_range_/sql.yql"
         }
     ],
+    "test_sql2yql.test[schema-select_all_inferschema_range_empty_fail]": [
+        {
+            "checksum": "7f05c875c6cfd26502bc5deb626c3fbf",
+            "size": 1340,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_schema-select_all_inferschema_range_empty_fail_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[schema-select_field]": [
         {
             "checksum": "2c124c444180940ce83af38756dc02e4",
@@ -17709,90 +17772,6 @@
             "uri": "https://{canondata_backend}/1784117/d56ae82ad9d30397a41490647be1bd2124718f98/resource.tar.gz#test_sql2yql.test_simple_columns-simple_columns_union_all_qualified_star_/sql.yql"
         }
     ],
-    "test_sql2yql.test[solomon-BadDownsamplingAggregation]": [
-        {
-            "checksum": "71d8572d4941dcc0a5191b0c863d1a82",
-            "size": 1236,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-BadDownsamplingAggregation_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-BadDownsamplingDisabled]": [
-        {
-            "checksum": "2c4d08c8963b8ec3c040ac15874aa59c",
-            "size": 1233,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-BadDownsamplingDisabled_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-BadDownsamplingFill]": [
-        {
-            "checksum": "1bd1ce7e13ada0dcd77f817e7be5e527",
-            "size": 1229,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-BadDownsamplingFill_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-BadDownsamplingInterval]": [
-        {
-            "checksum": "074f93dbca47fd8642865801992c5155",
-            "size": 1237,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-BadDownsamplingInterval_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-Basic]": [
-        {
-            "checksum": "b16dcad0d233d0edf6a77e0545ad8929",
-            "size": 1198,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-Basic_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-BrokenJsonResponse]": [
-        {
-            "checksum": "3989d4c834dd77b2601f4c031d062837",
-            "size": 1199,
-            "uri": "https://{canondata_backend}/1599023/688233977db70f339a250f6f25033e36d5b327fb/resource.tar.gz#test_sql2yql.test_solomon-BrokenJsonResponse_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-DownsamplingValidSettings]": [
-        {
-            "checksum": "1e75df3c5096dd36a54c18e633a607a1",
-            "size": 1272,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-DownsamplingValidSettings_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-Downsampling]": [
-        {
-            "checksum": "75f43c8acaf9d8f7c0dac7184f1b0fb3",
-            "size": 1346,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-Downsampling_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-InvalidProject]": [
-        {
-            "checksum": "a245f9de278996da0a0fb71395f5bdf0",
-            "size": 1195,
-            "uri": "https://{canondata_backend}/1599023/688233977db70f339a250f6f25033e36d5b327fb/resource.tar.gz#test_sql2yql.test_solomon-InvalidProject_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-LabelColumns]": [
-        {
-            "checksum": "9cbee7499e54e16143791b73d4891146",
-            "size": 1289,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-LabelColumns_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-Subquery]": [
-        {
-            "checksum": "93c45f401cb4eaaf94f9731a8cf3d519",
-            "size": 2206,
-            "uri": "https://{canondata_backend}/1925842/4cd572fb4c53ca13dd4b61884e96490799969da0/resource.tar.gz#test_sql2yql.test_solomon-Subquery_/sql.yql"
-        }
-    ],
-    "test_sql2yql.test[solomon-UnknownSetting]": [
-        {
-            "checksum": "0ab48f8f6e277b880a88bc040a10a0a6",
-            "size": 1215,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql2yql.test_solomon-UnknownSetting_/sql.yql"
-        }
-    ],
     "test_sql2yql.test[stream_lookup_join-lookup_join]": [
         {
             "checksum": "cafb9f686b3f2fca7a4160d3f4d9f2ef",
@@ -17849,6 +17828,13 @@
             "uri": "https://{canondata_backend}/1784117/d56ae82ad9d30397a41490647be1bd2124718f98/resource.tar.gz#test_sql2yql.test_table_range-each_with_non_existing_/sql.yql"
         }
     ],
+    "test_sql2yql.test[table_range-each_with_non_existing_all_fail]": [
+        {
+            "checksum": "b4627eeca4f69a1d3c232b6058a2d5ef",
+            "size": 1328,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_table_range-each_with_non_existing_all_fail_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[table_range-limit_with_table_path_over_sorted_range]": [
         {
             "checksum": "8815c9ec98bf9cc65dbe9ed8fd61462d",
@@ -18327,9 +18313,9 @@
     ],
     "test_sql2yql.test[udf-python_struct]": [
         {
-            "checksum": "769753004b839ce1ac47798ec76c5e8a",
-            "size": 2229,
-            "uri": "https://{canondata_backend}/1784117/d56ae82ad9d30397a41490647be1bd2124718f98/resource.tar.gz#test_sql2yql.test_udf-python_struct_/sql.yql"
+            "checksum": "57e3e2517d06b55bd71527572777a037",
+            "size": 2230,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql2yql.test_udf-python_struct_/sql.yql"
         }
     ],
     "test_sql2yql.test[udf-regexp_udf]": [
@@ -20014,16 +20000,16 @@
     ],
     "test_sql_format.test[action-eval_atom_wrong_type_expr]": [
         {
-            "checksum": "5561ce9a193250739d88cdcdf7a6c919",
-            "size": 65,
-            "uri": "https://{canondata_backend}/1923547/2c6b73e812b6d7bc36fe15c35684a8f836c610fe/resource.tar.gz#test_sql_format.test_action-eval_atom_wrong_type_expr_/formatted.sql"
+            "checksum": "38d65e794d750fc3cf8410adc52192d9",
+            "size": 141,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_action-eval_atom_wrong_type_expr_/formatted.sql"
         }
     ],
     "test_sql_format.test[action-eval_atom_wrong_type_param]": [
         {
-            "checksum": "6bb9503b769369384ef6660c8f217a9a",
-            "size": 80,
-            "uri": "https://{canondata_backend}/1923547/2c6b73e812b6d7bc36fe15c35684a8f836c610fe/resource.tar.gz#test_sql_format.test_action-eval_atom_wrong_type_param_/formatted.sql"
+            "checksum": "cf99b8e68610084b21f2a4ec34460b2d",
+            "size": 168,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_action-eval_atom_wrong_type_param_/formatted.sql"
         }
     ],
     "test_sql_format.test[action-eval_capture]": [
@@ -20161,9 +20147,9 @@
     ],
     "test_sql_format.test[action-eval_on_modif_table_fail]": [
         {
-            "checksum": "0fdfcbe571574f02b96178cf6e451f19",
-            "size": 301,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_action-eval_on_modif_table_fail_/formatted.sql"
+            "checksum": "77345b75bc26433d2de36ca395564930",
+            "size": 358,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_action-eval_on_modif_table_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[action-eval_percentile]": [
@@ -20266,9 +20252,9 @@
     ],
     "test_sql_format.test[action-eval_typeof_output_table]": [
         {
-            "checksum": "d0fa43ca2549cc11a0134b00f792a663",
-            "size": 424,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_action-eval_typeof_output_table_/formatted.sql"
+            "checksum": "3c77cfcb8d8d2446fbdeb1b25ba9f79c",
+            "size": 473,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_action-eval_typeof_output_table_/formatted.sql"
         }
     ],
     "test_sql_format.test[action-eval_unresolved_type_arg]": [
@@ -20357,16 +20343,16 @@
     ],
     "test_sql_format.test[action-large_evaluate_for_fail]": [
         {
-            "checksum": "9057bbd7e90a4e33c50b0074ffad0538",
-            "size": 156,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_action-large_evaluate_for_fail_/formatted.sql"
+            "checksum": "bf59ec13bc70e24122136f6531aae446",
+            "size": 228,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_action-large_evaluate_for_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[action-mixed_eval_typeof_world1]": [
         {
-            "checksum": "44b5538a4dec5e0dbfc742f637a2c15d",
-            "size": 1432,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_action-mixed_eval_typeof_world1_/formatted.sql"
+            "checksum": "d305a27635f7c1e54f85b853e81a8f7f",
+            "size": 1497,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_action-mixed_eval_typeof_world1_/formatted.sql"
         }
     ],
     "test_sql_format.test[action-nested_action]": [
@@ -20420,9 +20406,9 @@
     ],
     "test_sql_format.test[action-pending_arg_fail]": [
         {
-            "checksum": "81f805b197da46c934804cec3602afaf",
-            "size": 104,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_action-pending_arg_fail_/formatted.sql"
+            "checksum": "a8975a9e0f3997ca68558b72eab22e92",
+            "size": 188,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_action-pending_arg_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[action-process_from_subquery_with_orderby]": [
@@ -22457,9 +22443,9 @@
     ],
     "test_sql_format.test[aggregate-library_error_in_aggregation_fail]": [
         {
-            "checksum": "77fe10b1e019b8f08c24afb99aa238f8",
-            "size": 352,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_aggregate-library_error_in_aggregation_fail_/formatted.sql"
+            "checksum": "1874c088a429c451a88d7094748cb902",
+            "size": 357,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_aggregate-library_error_in_aggregation_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[aggregate-list_after_group]": [
@@ -23129,9 +23115,9 @@
     ],
     "test_sql_format.test[binding-tie_bad_count_fail]": [
         {
-            "checksum": "125159a3e530d2401300986a429badb1",
-            "size": 102,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_binding-tie_bad_count_fail_/formatted.sql"
+            "checksum": "99fba29a9f6e73544a09096adf56cb77",
+            "size": 162,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_binding-tie_bad_count_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[binding-tie_scalar_context]": [
@@ -24389,100 +24375,100 @@
     ],
     "test_sql_format.test[column_group-hint_append_fail]": [
         {
-            "checksum": "d8756aff7c76d47d50affb769ec2cd4c",
-            "size": 100,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_append_fail_/formatted.sql"
+            "checksum": "67129def3ac113548f2608f81dd43ef9",
+            "size": 179,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_append_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_diff_grp_fail]": [
         {
-            "checksum": "f744b62377a234b3917a499ce855e287",
-            "size": 189,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_diff_grp_fail_/formatted.sql"
+            "checksum": "b1979eff19845062e12d2612583837be",
+            "size": 286,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_diff_grp_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_dup_col_fail]": [
         {
-            "checksum": "9369794c75b7ff64b291feba43b27a70",
-            "size": 122,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_dup_col_fail_/formatted.sql"
+            "checksum": "232a45515f6b7ec224da19de6933b9ad",
+            "size": 161,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_dup_col_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_dup_def_fail]": [
         {
-            "checksum": "1a4e614d1a3fb52812858f2d0ac3a2c8",
-            "size": 119,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_dup_def_fail_/formatted.sql"
+            "checksum": "5ab321bc3f459914b7d07954bdecb58a",
+            "size": 189,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_dup_def_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_empty_grp_fail]": [
         {
-            "checksum": "a941488bc5b6cea4b2973d4b34f42265",
-            "size": 112,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_empty_grp_fail_/formatted.sql"
+            "checksum": "6433d368e8d9060db8808fc2635bc8aa",
+            "size": 183,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_empty_grp_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_non_lst_yson_fail]": [
         {
-            "checksum": "76c3ad2040c49953fd0b04350957f428",
-            "size": 106,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_non_lst_yson_fail_/formatted.sql"
+            "checksum": "9ce3f908c1ebd5a927182d9939bac746",
+            "size": 157,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_non_lst_yson_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_non_map_yson_fail]": [
         {
-            "checksum": "33199477b1b4f4f065f10edfce9d1dca",
-            "size": 101,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_non_map_yson_fail_/formatted.sql"
+            "checksum": "bba4786d958c056aa7abe8650420d69a",
+            "size": 153,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_non_map_yson_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_non_str_yson_fail]": [
         {
-            "checksum": "d960e27fbf3ca9ec95078dd4ce11c9cb",
-            "size": 106,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_non_str_yson_fail_/formatted.sql"
+            "checksum": "a02b9315d3db781556b145e9a9b6222d",
+            "size": 185,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_non_str_yson_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_non_yson_fail]": [
         {
-            "checksum": "e31dfcc94cc41d84c70f07adc68a8e82",
-            "size": 97,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_non_yson_fail_/formatted.sql"
+            "checksum": "41a19927543b45a19682b76a4fb2d061",
+            "size": 149,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_non_yson_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_short_grp_fail]": [
         {
-            "checksum": "35b466f65b9494f1e9b06ea0439b4e00",
-            "size": 117,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_short_grp_fail_/formatted.sql"
+            "checksum": "6e4d26b2d6b468d69873aaec21cdcf0a",
+            "size": 188,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_short_grp_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-hint_unk_col_fail]": [
         {
-            "checksum": "d9765e8b9d22f9213e45d46ac63a77d7",
-            "size": 120,
-            "uri": "https://{canondata_backend}/1937027/bbc35c51807ca32a384973d8a730422ad871c54c/resource.tar.gz#test_sql_format.test_column_group-hint_unk_col_fail_/formatted.sql"
+            "checksum": "703833051f7c8f7c01aaaedd820475df",
+            "size": 185,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-hint_unk_col_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-insert_diff_groups1_fail]": [
         {
-            "checksum": "f354a922ac63e9db47f95ce2f5b17187",
-            "size": 295,
-            "uri": "https://{canondata_backend}/1871002/424fbf9b3e2a5083fa1289e0777dbe9463d049d9/resource.tar.gz#test_sql_format.test_column_group-insert_diff_groups1_fail_/formatted.sql"
+            "checksum": "557b02b76e82d5293f48dab260477ce8",
+            "size": 384,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-insert_diff_groups1_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-insert_diff_groups2_fail]": [
         {
-            "checksum": "995593fbae18a399f478e76bd83b364a",
-            "size": 303,
-            "uri": "https://{canondata_backend}/1871002/424fbf9b3e2a5083fa1289e0777dbe9463d049d9/resource.tar.gz#test_sql_format.test_column_group-insert_diff_groups2_fail_/formatted.sql"
+            "checksum": "b331b97a016d965cabc29e70e0481ccc",
+            "size": 392,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-insert_diff_groups2_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-insert_diff_groups3_fail]": [
         {
-            "checksum": "887f458985d36504bae92614369477d0",
-            "size": 143,
-            "uri": "https://{canondata_backend}/1942415/9610360ced2221ce66696bd9f6afd9579e452c44/resource.tar.gz#test_sql_format.test_column_group-insert_diff_groups3_fail_/formatted.sql"
+            "checksum": "e278038d0c8892f530e89495b5cf53c3",
+            "size": 222,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_group-insert_diff_groups3_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_group-length]": [
@@ -24690,16 +24676,16 @@
     ],
     "test_sql_format.test[column_order-union_all_positional_columns_count_fail]": [
         {
-            "checksum": "e24a6677a821ea10fa37dd0fb524a188",
-            "size": 156,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_column_order-union_all_positional_columns_count_fail_/formatted.sql"
+            "checksum": "b6201e549213a25c6e6e729b8f74cbda",
+            "size": 264,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_order-union_all_positional_columns_count_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_order-union_all_positional_unordered_fail]": [
         {
-            "checksum": "afcba43bbd7e3b2b3c8a833acf58e947",
-            "size": 177,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_column_order-union_all_positional_unordered_fail_/formatted.sql"
+            "checksum": "18146c0c1cf7d7c47ebd00974cfcb5fd",
+            "size": 262,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_column_order-union_all_positional_unordered_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[column_order-values]": [
@@ -25327,9 +25313,9 @@
     ],
     "test_sql_format.test[datetime-date_tz_impossible_cast]": [
         {
-            "checksum": "8ee9927e0d887b1fea8e2b7c29499353",
-            "size": 158,
-            "uri": "https://{canondata_backend}/1130705/d31a79698ba36e25d38301feb8a2518de6ef9df2/resource.tar.gz#test_sql_format.test_datetime-date_tz_impossible_cast_/formatted.sql"
+            "checksum": "9daa1eb8fc62037cea256385233a92c6",
+            "size": 203,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_datetime-date_tz_impossible_cast_/formatted.sql"
         }
     ],
     "test_sql_format.test[datetime-date_tz_io]": [
@@ -25691,16 +25677,16 @@
     ],
     "test_sql_format.test[expr-as_table_bad_columns_fail]": [
         {
-            "checksum": "4ca779a0e0656eda8ef5cd98d11cbb7f",
-            "size": 259,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-as_table_bad_columns_fail_/formatted.sql"
+            "checksum": "e82755ec85db8de747f9f3fe691b0085",
+            "size": 323,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-as_table_bad_columns_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-as_table_bad_row_type_fail]": [
         {
-            "checksum": "b42c4d2b043d0eeb8da960cde88b27a9",
-            "size": 101,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-as_table_bad_row_type_fail_/formatted.sql"
+            "checksum": "660b22e2fe24c35a462754cc9cbdb1c5",
+            "size": 156,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-as_table_bad_row_type_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-as_table_emptylist2]": [
@@ -25992,16 +25978,16 @@
     ],
     "test_sql_format.test[expr-ensure_runtime_fail]": [
         {
-            "checksum": "7c65ea048e465ffa8dd079d0da799fcd",
-            "size": 65,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-ensure_runtime_fail_/formatted.sql"
+            "checksum": "d18e02c5ffa612ab48399396c2b03ad0",
+            "size": 90,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-ensure_runtime_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-ensure_type_fail]": [
         {
-            "checksum": "107b79866e71f48a62864cde5ddd3083",
-            "size": 113,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-ensure_type_fail_/formatted.sql"
+            "checksum": "90a4591cab3b9800c0c8f2b4e3264bc5",
+            "size": 172,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-ensure_type_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-evaluate_parse_inf_nan]": [
@@ -26132,9 +26118,9 @@
     ],
     "test_sql_format.test[expr-implicit_bitcast_fail]": [
         {
-            "checksum": "890495d1d95b7bfc9b1c96826d2cecd5",
-            "size": 169,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-implicit_bitcast_fail_/formatted.sql"
+            "checksum": "ae4c6e8d4efc2570eacbdac2f5e3f3d5",
+            "size": 232,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-implicit_bitcast_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-implicit_cast_literals_under_if]": [
@@ -26335,9 +26321,9 @@
     ],
     "test_sql_format.test[expr-list_replicate_fail]": [
         {
-            "checksum": "93cb71186b1b55e95e2077c505c5547e",
-            "size": 56,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-list_replicate_fail_/formatted.sql"
+            "checksum": "68fcf84b73a17cb0bf7cc751d925134b",
+            "size": 164,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-list_replicate_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-list_sample]": [
@@ -26454,44 +26440,44 @@
     ],
     "test_sql_format.test[expr-non_persistable_group_by_column_fail]": [
         {
-            "checksum": "fac6ed789b7f73290e6e7136f0770871",
-            "size": 127,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-non_persistable_group_by_column_fail_/formatted.sql"
+            "checksum": "bfd2b897bff25f0bbdf3aebf3508b57d",
+            "size": 231,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-non_persistable_group_by_column_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-non_persistable_group_by_having_some_fail]": [
         {
-            "checksum": "6be35146fdd50bfee84fc693584a72bf",
-            "size": 145,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-non_persistable_group_by_having_some_fail_/formatted.sql"
+            "checksum": "dae09631d58e57d552fa1ae240abbdcb",
+            "size": 184,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-non_persistable_group_by_having_some_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-non_persistable_group_by_some_fail]": [
         {
-            "checksum": "dcc7649a0d90035f29bc5f00bf7423a6",
-            "size": 109,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-non_persistable_group_by_some_fail_/formatted.sql"
+            "checksum": "a5ac2dac285183f2bc4cb720935e7ff9",
+            "size": 148,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-non_persistable_group_by_some_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-non_persistable_inner_select_fail]": [
         {
-            "checksum": "1f7af1f477337920e0196b9ee45176b0",
-            "size": 125,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-non_persistable_inner_select_fail_/formatted.sql"
+            "checksum": "3fa8719bb84bf2e8d55da494a33b551e",
+            "size": 164,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-non_persistable_inner_select_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-non_persistable_insert_into_fail]": [
         {
-            "checksum": "81bc31b3e579717e14e690076bd4306e",
-            "size": 126,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-non_persistable_insert_into_fail_/formatted.sql"
+            "checksum": "975fc07c9494cb8fff909086c91c4353",
+            "size": 165,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-non_persistable_insert_into_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-non_persistable_order_by_fail]": [
         {
-            "checksum": "5f70a7ef4e1027b00809968814ef3ac7",
-            "size": 126,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-non_persistable_order_by_fail_/formatted.sql"
+            "checksum": "5c4bdfacb6bf956a53b77c30bcdda92c",
+            "size": 165,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-non_persistable_order_by_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-opt_list_map]": [
@@ -26776,9 +26762,9 @@
     ],
     "test_sql_format.test[expr-unwrap_runtime_fail]": [
         {
-            "checksum": "4d708fcc6a3e0d2c145d5f695c1c2b9f",
-            "size": 59,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_expr-unwrap_runtime_fail_/formatted.sql"
+            "checksum": "f866220cf81ee54e42f171149247535a",
+            "size": 84,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_expr-unwrap_runtime_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[expr-uuid]": [
@@ -26874,9 +26860,9 @@
     ],
     "test_sql_format.test[file-parse_file_bad_type_fail]": [
         {
-            "checksum": "8f9a9b8e0eb20d5773567b20e81073af",
-            "size": 66,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_file-parse_file_bad_type_fail_/formatted.sql"
+            "checksum": "f0ea8be298824a5f2bfffa803c739175",
+            "size": 115,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_file-parse_file_bad_type_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[file-parse_file_in_select_as_int]": [
@@ -26902,9 +26888,9 @@
     ],
     "test_sql_format.test[file-second_pass_parse_file_fail]": [
         {
-            "checksum": "27a9cea9d51503e96306b456f16be6a0",
-            "size": 296,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_file-second_pass_parse_file_fail_/formatted.sql"
+            "checksum": "02331d43ad6a85e54311c85f1de9900f",
+            "size": 479,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_file-second_pass_parse_file_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[file-where_key_in_file_content]": [
@@ -27637,16 +27623,16 @@
     ],
     "test_sql_format.test[in-in_tuple_check0_fail]": [
         {
-            "checksum": "e105585bea30c4f753859465f46401a0",
-            "size": 153,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_in-in_tuple_check0_fail_/formatted.sql"
+            "checksum": "43aed499f210b597b56d5f08121ae1e7",
+            "size": 241,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_in-in_tuple_check0_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[in-in_tuple_check1_fail]": [
         {
-            "checksum": "a11564df4ca7a97c800cf88826c678ad",
-            "size": 119,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_in-in_tuple_check1_fail_/formatted.sql"
+            "checksum": "17cd60c84770f58efff09ba215299af1",
+            "size": 181,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_in-in_tuple_check1_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[in-in_tuple_table]": [
@@ -27810,6 +27796,13 @@
             "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert-append_missing_null_/formatted.sql"
         }
     ],
+    "test_sql_format.test[insert-append_proto_fail]": [
+        {
+            "checksum": "5cb2d19a49baf91b1e48f3204578440c",
+            "size": 174,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-append_proto_fail_/formatted.sql"
+        }
+    ],
     "test_sql_format.test[insert-append_sorted]": [
         {
             "checksum": "d1853d5d720392d1d1b3f8f06d65d0c0",
@@ -27817,6 +27810,20 @@
             "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert-append_sorted_/formatted.sql"
         }
     ],
+    "test_sql_format.test[insert-append_view_fail]": [
+        {
+            "checksum": "39530bd5378c15ab4bbb6b267fbfac58",
+            "size": 165,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-append_view_fail_/formatted.sql"
+        }
+    ],
+    "test_sql_format.test[insert-append_with_read_udf_fail]": [
+        {
+            "checksum": "5cb2d19a49baf91b1e48f3204578440c",
+            "size": 174,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-append_with_read_udf_fail_/formatted.sql"
+        }
+    ],
     "test_sql_format.test[insert-double_append_to_anonymous]": [
         {
             "checksum": "9dc293eb09a0a2e763d81f3566a1a49d",
@@ -27833,9 +27840,9 @@
     ],
     "test_sql_format.test[insert-fail_read_view_after_modify]": [
         {
-            "checksum": "264d5cdf54c84403519f5d43d8396572",
-            "size": 173,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert-fail_read_view_after_modify_/formatted.sql"
+            "checksum": "cdec255ae24d7b398da52af91451c00c",
+            "size": 254,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-fail_read_view_after_modify_/formatted.sql"
         }
     ],
     "test_sql_format.test[insert-from_two_sorted_by_calc]": [
@@ -27873,6 +27880,34 @@
             "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert-keepmeta_/formatted.sql"
         }
     ],
+    "test_sql_format.test[insert-keepmeta_nonstrict_fail]": [
+        {
+            "checksum": "920f6a4be121240eb7905ff346466d99",
+            "size": 225,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-keepmeta_nonstrict_fail_/formatted.sql"
+        }
+    ],
+    "test_sql_format.test[insert-keepmeta_proto_fail]": [
+        {
+            "checksum": "87141bb666893e65b7c42fe3737c8205",
+            "size": 221,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-keepmeta_proto_fail_/formatted.sql"
+        }
+    ],
+    "test_sql_format.test[insert-keepmeta_view_fail]": [
+        {
+            "checksum": "e2c7905a932894b96e265f7731d16ab6",
+            "size": 195,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-keepmeta_view_fail_/formatted.sql"
+        }
+    ],
+    "test_sql_format.test[insert-keepmeta_with_read_udf_fail]": [
+        {
+            "checksum": "87141bb666893e65b7c42fe3737c8205",
+            "size": 221,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-keepmeta_with_read_udf_fail_/formatted.sql"
+        }
+    ],
     "test_sql_format.test[insert-literals_to_string]": [
         {
             "checksum": "01b4a4774a372f281dcfed0c9ca0115e",
@@ -27901,6 +27936,13 @@
             "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert-override_/formatted.sql"
         }
     ],
+    "test_sql_format.test[insert-override_view_fail]": [
+        {
+            "checksum": "0d495c20e7d78f79b68b1519901852ef",
+            "size": 161,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-override_view_fail_/formatted.sql"
+        }
+    ],
     "test_sql_format.test[insert-part_sortness]": [
         {
             "checksum": "a8c655bca002365b31e8d8d377c653b1",
@@ -28029,16 +28071,16 @@
     ],
     "test_sql_format.test[insert-use_anon_table_before_commit_fail]": [
         {
-            "checksum": "ef426f4b2f994739441cf52f5a299272",
-            "size": 98,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert-use_anon_table_before_commit_fail_/formatted.sql"
+            "checksum": "a667f5d052bf0da034ab3846d32c634e",
+            "size": 192,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-use_anon_table_before_commit_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[insert-use_anon_table_without_fill_fail]": [
         {
-            "checksum": "5839f14b91a2594b096fd8fa3845c8bb",
-            "size": 57,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert-use_anon_table_without_fill_fail_/formatted.sql"
+            "checksum": "ca618b643832e6c77c431de9b714cdc6",
+            "size": 151,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert-use_anon_table_without_fill_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[insert-values_subquery]": [
@@ -28064,16 +28106,16 @@
     ],
     "test_sql_format.test[insert_monotonic-break_sort_fail]": [
         {
-            "checksum": "1aa0b06f550e578a11e5eb6c19f34d62",
-            "size": 81,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert_monotonic-break_sort_fail_/formatted.sql"
+            "checksum": "3ad99ca175be4b0d2143b88aa947a404",
+            "size": 174,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert_monotonic-break_sort_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[insert_monotonic-break_unique_fail]": [
         {
-            "checksum": "a43dbba09ccf97567cc3719be2a8e491",
-            "size": 159,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert_monotonic-break_unique_fail_/formatted.sql"
+            "checksum": "dd22b8146a614cc4c3a190ed4405a83a",
+            "size": 170,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert_monotonic-break_unique_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[insert_monotonic-from_empty]": [
@@ -28099,23 +28141,23 @@
     ],
     "test_sql_format.test[insert_monotonic-non_existing_fail]": [
         {
-            "checksum": "c0ecc84adbbad89cdd70639ca02e4681",
-            "size": 93,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert_monotonic-non_existing_fail_/formatted.sql"
+            "checksum": "751c175d3060bfd08fa591e811b1246c",
+            "size": 189,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert_monotonic-non_existing_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[insert_monotonic-not_all_fail]": [
         {
-            "checksum": "14537225c9d05e5510a072db20d756c9",
-            "size": 185,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert_monotonic-not_all_fail_/formatted.sql"
+            "checksum": "91e09fb32f0c40192b3e98adee7a7a51",
+            "size": 281,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert_monotonic-not_all_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[insert_monotonic-overlaping_fail]": [
         {
-            "checksum": "a7c22f5cd90b816dc62d1f40756fb1d1",
-            "size": 150,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert_monotonic-overlaping_fail_/formatted.sql"
+            "checksum": "88b49c89eb0d7d88901d064d190edf0f",
+            "size": 187,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert_monotonic-overlaping_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[insert_monotonic-several1]": [
@@ -28148,9 +28190,9 @@
     ],
     "test_sql_format.test[insert_monotonic-truncate_fail]": [
         {
-            "checksum": "9439f178a0e4533c1cd340234ce78afe",
-            "size": 121,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_insert_monotonic-truncate_fail_/formatted.sql"
+            "checksum": "e66a5e32e9d0d4df5e5fb7230212e4de",
+            "size": 199,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_insert_monotonic-truncate_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[join-aggr_diff_order]": [
@@ -28610,9 +28652,9 @@
     ],
     "test_sql_format.test[join-join_table_conflict_fail]": [
         {
-            "checksum": "f9c6c9c84d57a19de1b33ebb7534314f",
-            "size": 370,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_join-join_table_conflict_fail_/formatted.sql"
+            "checksum": "94879b803db50cda2add7d9171672ece",
+            "size": 459,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_join-join_table_conflict_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[join-join_with_duplicate_keys_on_sorted]": [
@@ -29611,9 +29653,9 @@
     ],
     "test_sql_format.test[join-strict_keys]": [
         {
-            "checksum": "d23393460bdec348dce9f6a3e2b4d7b7",
-            "size": 336,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_join-strict_keys_/formatted.sql"
+            "checksum": "794d4a30354087d746dcf9e71441a907",
+            "size": 372,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_join-strict_keys_/formatted.sql"
         }
     ],
     "test_sql_format.test[join-three_equalities]": [
@@ -29779,9 +29821,9 @@
     ],
     "test_sql_format.test[json-json_exists/on_error_exception]": [
         {
-            "checksum": "1785927633e91e7ecba244a4c154458e",
-            "size": 211,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_exists_on_error_exception_/formatted.sql"
+            "checksum": "3602f61ef66fc55b31a6a51ff1219c31",
+            "size": 201,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_exists_on_error_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_exists/passing]": [
@@ -29793,9 +29835,9 @@
     ],
     "test_sql_format.test[json-json_exists/passing_exception]": [
         {
-            "checksum": "c4f5f9a6626acec4d09b0c5f0e08efce",
-            "size": 233,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_exists_passing_exception_/formatted.sql"
+            "checksum": "c9b635591647bec483527c2bede7b883",
+            "size": 269,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_exists_passing_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_query/common_syntax]": [
@@ -29821,9 +29863,9 @@
     ],
     "test_sql_format.test[json-json_query/on_empty_exception]": [
         {
-            "checksum": "1b1877544d70281fed15c425de9bc294",
-            "size": 202,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_query_on_empty_exception_/formatted.sql"
+            "checksum": "7050ec17fa46e6d7205a68667ef45a05",
+            "size": 188,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_query_on_empty_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_query/on_error]": [
@@ -29835,9 +29877,9 @@
     ],
     "test_sql_format.test[json-json_query/on_error_exception]": [
         {
-            "checksum": "7ba2ab7a1701bbb12b3605bac2c354fa",
-            "size": 210,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_query_on_error_exception_/formatted.sql"
+            "checksum": "277ecc7f949bd7a8011ad0e4eb5d1c67",
+            "size": 200,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_query_on_error_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_query/passing]": [
@@ -29849,9 +29891,9 @@
     ],
     "test_sql_format.test[json-json_query/passing_exception]": [
         {
-            "checksum": "43a49d058c315abbc97ee8d255780305",
-            "size": 265,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_query_passing_exception_/formatted.sql"
+            "checksum": "6fc906fe52e57c152ae50fbd8ba58fe4",
+            "size": 345,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_query_passing_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_query/wrapper]": [
@@ -29884,16 +29926,16 @@
     ],
     "test_sql_format.test[json-json_value/on_empty_cast_default_exception]": [
         {
-            "checksum": "5789af88bd717ac1a829c68e9919d4a0",
-            "size": 170,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_value_on_empty_cast_default_exception_/formatted.sql"
+            "checksum": "44a33a4bcf6dd8b4eeecdd378dfc423f",
+            "size": 225,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_value_on_empty_cast_default_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_value/on_empty_exception]": [
         {
-            "checksum": "7bb08b3eeb0f92fa8e027c510530dc19",
-            "size": 133,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_value_on_empty_exception_/formatted.sql"
+            "checksum": "0dfcf8ec32a02e549a3f8952e85e1142",
+            "size": 122,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_value_on_empty_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_value/on_error]": [
@@ -29905,30 +29947,30 @@
     ],
     "test_sql_format.test[json-json_value/on_error_cast_default_exception]": [
         {
-            "checksum": "8acb2591a82314db771515aff58553d6",
-            "size": 366,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_value_on_error_cast_default_exception_/formatted.sql"
+            "checksum": "9c0765fd797e1b961c3994cca2ff3b5d",
+            "size": 421,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_value_on_error_cast_default_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_value/on_error_cast_udf_exception]": [
         {
-            "checksum": "e04abe6da810f3c5e8e8574470d6895a",
-            "size": 289,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_value_on_error_cast_udf_exception_/formatted.sql"
+            "checksum": "eebd12df7999c5a52feeb5d3df79baf7",
+            "size": 313,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_value_on_error_cast_udf_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_value/on_error_cast_value_exception]": [
         {
-            "checksum": "a1553cd1e3aa02228a5e094052114d0a",
-            "size": 284,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_value_on_error_cast_value_exception_/formatted.sql"
+            "checksum": "83adce2249a316cb98a35c2092d0b7e6",
+            "size": 325,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_value_on_error_cast_value_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_value/on_error_jsonpath_exception]": [
         {
-            "checksum": "fade7358ec46694f9751e395f552f400",
-            "size": 136,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_value_on_error_jsonpath_exception_/formatted.sql"
+            "checksum": "1eb46371fa3ffae64612fac46ddde2cf",
+            "size": 126,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_value_on_error_jsonpath_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_value/passing]": [
@@ -29940,9 +29982,9 @@
     ],
     "test_sql_format.test[json-json_value/passing_exception]": [
         {
-            "checksum": "a450c4027bdf3d5ac214f3698f35ba3b",
-            "size": 232,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_json-json_value_passing_exception_/formatted.sql"
+            "checksum": "949b876661064d4c971ce3c3835cd156",
+            "size": 312,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_json-json_value_passing_exception_/formatted.sql"
         }
     ],
     "test_sql_format.test[json-json_value/returning]": [
@@ -30367,9 +30409,9 @@
     ],
     "test_sql_format.test[lambda-lambda_with_tie_bad_count_fail]": [
         {
-            "checksum": "7b9558bca37755d4576208ac9cf860a0",
-            "size": 193,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_lambda-lambda_with_tie_bad_count_fail_/formatted.sql"
+            "checksum": "2e8437d04945a8afacae985e3d64422e",
+            "size": 231,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_lambda-lambda_with_tie_bad_count_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[lambda-list_aggregate]": [
@@ -30626,9 +30668,9 @@
     ],
     "test_sql_format.test[lineage-error_type]": [
         {
-            "checksum": "aa7268913aed17bf13095a2f03f475ee",
-            "size": 106,
-            "uri": "https://{canondata_backend}/1784826/8212a6594777651314d94a2e2f95179c0016604c/resource.tar.gz#test_sql_format.test_lineage-error_type_/formatted.sql"
+            "checksum": "e694e5a155b33a62693478a6af71e0d9",
+            "size": 172,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_lineage-error_type_/formatted.sql"
         }
     ],
     "test_sql_format.test[lineage-flatten_by]": [
@@ -31004,9 +31046,9 @@
     ],
     "test_sql_format.test[match_recognize-test_type_predicate]": [
         {
-            "checksum": "9dc7192e7a809496ce854770180376c5",
-            "size": 416,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_match_recognize-test_type_predicate_/formatted.sql"
+            "checksum": "5e14728b9e0ccf50f5e64f2043882ceb",
+            "size": 472,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_match_recognize-test_type_predicate_/formatted.sql"
         }
     ],
     "test_sql_format.test[optimizers-aggregate_over_aggregate]": [
@@ -31144,9 +31186,9 @@
     ],
     "test_sql_format.test[optimizers-sort_by_nonstrict_const]": [
         {
-            "checksum": "a8ef5fa0a5a869ab80571d8a9c27cb93",
-            "size": 84,
-            "uri": "https://{canondata_backend}/1775059/2a9bd55a1c15f5a3a2740dd1a07c9cbfaaf0a087/resource.tar.gz#test_sql_format.test_optimizers-sort_by_nonstrict_const_/formatted.sql"
+            "checksum": "1e451e0361efb161b13623ca15d82d4e",
+            "size": 124,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_optimizers-sort_by_nonstrict_const_/formatted.sql"
         }
     ],
     "test_sql_format.test[optimizers-sort_constraint_in_left]": [
@@ -31998,9 +32040,9 @@
     ],
     "test_sql_format.test[params-missing_param_fail]": [
         {
-            "checksum": "36a92ca597d877445791dd9c322bfcc3",
-            "size": 59,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_params-missing_param_fail_/formatted.sql"
+            "checksum": "363c532c040ae122e68ec506c22d0a71",
+            "size": 109,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_params-missing_param_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[params-no_optional_param]": [
@@ -32012,9 +32054,9 @@
     ],
     "test_sql_format.test[params-no_params_fail]": [
         {
-            "checksum": "50909d9e66f2d5bef3d23676f5d4fad3",
-            "size": 39,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_params-no_params_fail_/formatted.sql"
+            "checksum": "60d953a656b62424584bbc5a46313fb2",
+            "size": 89,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_params-no_params_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[params-param_in_in_predicate]": [
@@ -32033,9 +32075,9 @@
     ],
     "test_sql_format.test[params-param_type_mismatch_fail]": [
         {
-            "checksum": "5796d57a1a05017abbd2f61b17e96157",
-            "size": 42,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_params-param_type_mismatch_fail_/formatted.sql"
+            "checksum": "317c0cec92f48f65ce81aec48db10c7a",
+            "size": 107,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_params-param_type_mismatch_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[params-primitives]": [
@@ -32362,9 +32404,9 @@
     ],
     "test_sql_format.test[pragma-yson_strict_fail]": [
         {
-            "checksum": "f63dda31155ab395808c0265722b3a9b",
-            "size": 91,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_pragma-yson_strict_fail_/formatted.sql"
+            "checksum": "f497884ca5cc8fa2c9ef0637092f1526",
+            "size": 147,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_pragma-yson_strict_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[produce-discard_process_with_lambda]": [
@@ -32439,9 +32481,9 @@
     ],
     "test_sql_format.test[produce-process_multi_out_bad_count_fail]": [
         {
-            "checksum": "938ab21d8cbc4e23cd64be7fde9f0417",
-            "size": 577,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_produce-process_multi_out_bad_count_fail_/formatted.sql"
+            "checksum": "47693979b1d374d98a0ebf9b12fbbdd2",
+            "size": 593,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_produce-process_multi_out_bad_count_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[produce-process_pure_with_sort]": [
@@ -33230,9 +33272,9 @@
     ],
     "test_sql_format.test[schema-read_schema_change_other]": [
         {
-            "checksum": "19563cb8172e8f1ad4f1314790e2e1d1",
-            "size": 68,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_schema-read_schema_change_other_/formatted.sql"
+            "checksum": "0bdc66b8093fccddb508d6ce09d4e97c",
+            "size": 133,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_schema-read_schema_change_other_/formatted.sql"
         }
     ],
     "test_sql_format.test[schema-read_schema_other]": [
@@ -33312,6 +33354,13 @@
             "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_schema-select_all_inferschema_range_/formatted.sql"
         }
     ],
+    "test_sql_format.test[schema-select_all_inferschema_range_empty_fail]": [
+        {
+            "checksum": "9dae94b5548329802dada2501f454f4b",
+            "size": 207,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_schema-select_all_inferschema_range_empty_fail_/formatted.sql"
+        }
+    ],
     "test_sql_format.test[schema-select_field]": [
         {
             "checksum": "d7b6c681fdf4d07b21ab12b1ae112f90",
@@ -33377,9 +33426,9 @@
     ],
     "test_sql_format.test[schema-user_schema_append]": [
         {
-            "checksum": "0cf9e17d2b8984b165498b532250f832",
-            "size": 129,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_schema-user_schema_append_/formatted.sql"
+            "checksum": "3e12f814c6ea0c069455e51aaa0d8f2e",
+            "size": 205,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_schema-user_schema_append_/formatted.sql"
         }
     ],
     "test_sql_format.test[schema-user_schema_bind]": [
@@ -33475,9 +33524,9 @@
     ],
     "test_sql_format.test[select-anon_clash]": [
         {
-            "checksum": "7a765b0d5b17822fa9d99f95b5f56a1a",
-            "size": 99,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_select-anon_clash_/formatted.sql"
+            "checksum": "ef9b93792758ed46b0bace9eb566f372",
+            "size": 144,
+            "uri": "https://{canondata_backend}/212715/768485cf7bb10437f575bf986ea1655015708a0a/resource.tar.gz#test_sql_format.test_select-anon_clash_/formatted.sql"
         }
     ],
     "test_sql_format.test[select-append_to_value]": [
@@ -34280,9 +34329,9 @@
     ],
     "test_sql_format.test[simple_columns-simple_columns_base_fail]": [
         {
-            "checksum": "f2f636650ab4ac5b4ad8d317ea3b08ae",
-            "size": 297,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_simple_columns-simple_columns_base_fail_/formatted.sql"
+            "checksum": "0aba9931faed8f1459bca05f9fc9410b",
+            "size": 317,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_simple_columns-simple_columns_base_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[simple_columns-simple_columns_join_all]": [
@@ -34357,9 +34406,9 @@
     ],
     "test_sql_format.test[simple_columns-simple_columns_join_fail]": [
         {
-            "checksum": "bbd30902c3f4730adc194f29536bec46",
-            "size": 402,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_simple_columns-simple_columns_join_fail_/formatted.sql"
+            "checksum": "fcf4a749afd8e98b52f0b963d05c9137",
+            "size": 419,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_simple_columns-simple_columns_join_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[simple_columns-simple_columns_join_qualified]": [
@@ -34446,90 +34495,6 @@
             "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_simple_columns-simple_columns_union_all_qualified_star_/formatted.sql"
         }
     ],
-    "test_sql_format.test[solomon-BadDownsamplingAggregation]": [
-        {
-            "checksum": "dbbaa96830e404bf63965b22829c09e5",
-            "size": 168,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-BadDownsamplingAggregation_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-BadDownsamplingDisabled]": [
-        {
-            "checksum": "795bb32d9417f71478b7ec70c6e7e820",
-            "size": 165,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-BadDownsamplingDisabled_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-BadDownsamplingFill]": [
-        {
-            "checksum": "f3f44c044ed971f2e5bfa8a83d3754bc",
-            "size": 161,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-BadDownsamplingFill_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-BadDownsamplingInterval]": [
-        {
-            "checksum": "08f7cf41c2404d74c4cc2c39208f270d",
-            "size": 170,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-BadDownsamplingInterval_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-Basic]": [
-        {
-            "checksum": "999941931538e981e6868785f407699e",
-            "size": 132,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-Basic_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-BrokenJsonResponse]": [
-        {
-            "checksum": "2ea7d86f378d1d0acea749729505b8e9",
-            "size": 133,
-            "uri": "https://{canondata_backend}/1599023/688233977db70f339a250f6f25033e36d5b327fb/resource.tar.gz#test_sql_format.test_solomon-BrokenJsonResponse_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-DownsamplingValidSettings]": [
-        {
-            "checksum": "1741d8968029a8b3c23885c5826009f3",
-            "size": 497,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-DownsamplingValidSettings_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-Downsampling]": [
-        {
-            "checksum": "6e216bc7dbf6e716c0f67bc36e199c65",
-            "size": 273,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-Downsampling_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-InvalidProject]": [
-        {
-            "checksum": "d9dc0179f957667ff446aae66459f359",
-            "size": 129,
-            "uri": "https://{canondata_backend}/1599023/688233977db70f339a250f6f25033e36d5b327fb/resource.tar.gz#test_sql_format.test_solomon-InvalidProject_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-LabelColumns]": [
-        {
-            "checksum": "5d2ff6d76dac9a34c9ca42f73fedbc40",
-            "size": 219,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-LabelColumns_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-Subquery]": [
-        {
-            "checksum": "011dae5a5c7dff0acaff130860bb39c5",
-            "size": 354,
-            "uri": "https://{canondata_backend}/1925842/4cd572fb4c53ca13dd4b61884e96490799969da0/resource.tar.gz#test_sql_format.test_solomon-Subquery_/formatted.sql"
-        }
-    ],
-    "test_sql_format.test[solomon-UnknownSetting]": [
-        {
-            "checksum": "19d67960961badcaf4cb43956c2b4abd",
-            "size": 145,
-            "uri": "https://{canondata_backend}/1880306/2acf5b55cb208565b2cb35901ac765fc11dca857/resource.tar.gz#test_sql_format.test_solomon-UnknownSetting_/formatted.sql"
-        }
-    ],
     "test_sql_format.test[stream_lookup_join-lookup_join]": [
         {
             "checksum": "847138b770815f5eaa57829f027f4772",
@@ -34586,6 +34551,13 @@
             "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_table_range-each_with_non_existing_/formatted.sql"
         }
     ],
+    "test_sql_format.test[table_range-each_with_non_existing_all_fail]": [
+        {
+            "checksum": "948bd3bd04201558c3e937b07f05791f",
+            "size": 178,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_table_range-each_with_non_existing_all_fail_/formatted.sql"
+        }
+    ],
     "test_sql_format.test[table_range-limit_with_table_path_over_sorted_range]": [
         {
             "checksum": "4547d6df36ebeb9e27b0e14cd71b1eca",
@@ -35043,9 +35015,9 @@
     ],
     "test_sql_format.test[udf-named_args_for_script_with_posargs_reuse_args_fail]": [
         {
-            "checksum": "6035273ae147f396e3fd3ed3a86733e2",
-            "size": 657,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_udf-named_args_for_script_with_posargs_reuse_args_fail_/formatted.sql"
+            "checksum": "d82297011ad066e486d5c51b6320e65e",
+            "size": 697,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_udf-named_args_for_script_with_posargs_reuse_args_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[udf-python_script]": [
@@ -35064,9 +35036,9 @@
     ],
     "test_sql_format.test[udf-python_struct]": [
         {
-            "checksum": "f202249d99f7c74e69ec895ec1b35ce4",
-            "size": 638,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_udf-python_struct_/formatted.sql"
+            "checksum": "9687f74db610676bf828447642b36c69",
+            "size": 639,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_udf-python_struct_/formatted.sql"
         }
     ],
     "test_sql_format.test[udf-regexp_udf]": [
@@ -35169,9 +35141,9 @@
     ],
     "test_sql_format.test[udf-wrong_args_fail]": [
         {
-            "checksum": "59adb4b6c343c9fdcc96a48bef8b9896",
-            "size": 270,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_udf-wrong_args_fail_/formatted.sql"
+            "checksum": "97c962cec960b3b5d478680c90870ba1",
+            "size": 327,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_udf-wrong_args_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[union-union_column_extention]": [
@@ -35344,9 +35316,9 @@
     ],
     "test_sql_format.test[view-file_eval]": [
         {
-            "checksum": "b08987d32b59d8b78f26f7d5667fd49d",
-            "size": 149,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_view-file_eval_/formatted.sql"
+            "checksum": "c66b645e61cf9e218a4b42376d8a2cc7",
+            "size": 232,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_view-file_eval_/formatted.sql"
         }
     ],
     "test_sql_format.test[view-file_inner]": [
@@ -35372,16 +35344,16 @@
     ],
     "test_sql_format.test[view-file_outer]": [
         {
-            "checksum": "09f94c43e09b2dfcac41fff318b2e8d4",
-            "size": 150,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_view-file_outer_/formatted.sql"
+            "checksum": "e20e82639bffef9b629410e8d93e6cec",
+            "size": 138,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_view-file_outer_/formatted.sql"
         }
     ],
     "test_sql_format.test[view-file_outer_library]": [
         {
-            "checksum": "40556299449bcb2bd5c8736abd8fed6d",
-            "size": 187,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_view-file_outer_library_/formatted.sql"
+            "checksum": "bc124dbac50f220e841b129fdf86ebe6",
+            "size": 220,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_view-file_outer_library_/formatted.sql"
         }
     ],
     "test_sql_format.test[view-init_view_after_eval]": [
@@ -35393,23 +35365,23 @@
     ],
     "test_sql_format.test[view-secure]": [
         {
-            "checksum": "53bab683c743905bc2bd8bf3b568ec0c",
-            "size": 146,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_view-secure_/formatted.sql"
+            "checksum": "276b0581d5af4228654891e91f064486",
+            "size": 163,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_view-secure_/formatted.sql"
         }
     ],
     "test_sql_format.test[view-secure_eval]": [
         {
-            "checksum": "4a358403c2e2689e800317a3139f2ce7",
-            "size": 151,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_view-secure_eval_/formatted.sql"
+            "checksum": "a3452bd2cea45ac41f828066ea82f7fe",
+            "size": 168,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_view-secure_eval_/formatted.sql"
         }
     ],
     "test_sql_format.test[view-secure_eval_dyn]": [
         {
-            "checksum": "7536d1692bf749890632ebbb4cd8645a",
-            "size": 159,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_view-secure_eval_dyn_/formatted.sql"
+            "checksum": "d2965ca5a5bd1018f97c04d74184c336",
+            "size": 185,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_view-secure_eval_dyn_/formatted.sql"
         }
     ],
     "test_sql_format.test[view-standalone_view_lambda]": [
@@ -35638,9 +35610,9 @@
     ],
     "test_sql_format.test[weak_field-weak_field_wrong_types_fail]": [
         {
-            "checksum": "bd6b0ab0a759e2c95de143eca3e4e399",
-            "size": 130,
-            "uri": "https://{canondata_backend}/1880306/64654158d6bfb1289c66c626a8162239289559d0/resource.tar.gz#test_sql_format.test_weak_field-weak_field_wrong_types_fail_/formatted.sql"
+            "checksum": "435b85eb44690d859b47180a3736df5b",
+            "size": 179,
+            "uri": "https://{canondata_backend}/1942415/9412486a083ee1e1736e2ef35ca9381a39429191/resource.tar.gz#test_sql_format.test_weak_field-weak_field_wrong_types_fail_/formatted.sql"
         }
     ],
     "test_sql_format.test[weak_field-weak_member_string_copy]": [
diff --git a/yql/essentials/tests/sql/suites/action/eval_atom_wrong_type_expr.sql b/yql/essentials/tests/sql/suites/action/eval_atom_wrong_type_expr.sql
index 9e8a2a8c6e..eeda7684a3 100644
--- a/yql/essentials/tests/sql/suites/action/eval_atom_wrong_type_expr.sql
+++ b/yql/essentials/tests/sql/suites/action/eval_atom_wrong_type_expr.sql
@@ -1,4 +1,5 @@
 /* yt can not */
+/* custom error: Expected data or optional of data, but got: List<String> */
 use plato;
 
 $n = ["foo"];
diff --git a/yql/essentials/tests/sql/suites/action/eval_atom_wrong_type_param.sql b/yql/essentials/tests/sql/suites/action/eval_atom_wrong_type_param.sql
index 7de917ef03..78990decb9 100644
--- a/yql/essentials/tests/sql/suites/action/eval_atom_wrong_type_param.sql
+++ b/yql/essentials/tests/sql/suites/action/eval_atom_wrong_type_param.sql
@@ -1,4 +1,5 @@
 /* yt can not */
+/* custom error: Expected data or optional of data, but got optional of: List<String> */
 use plato;
 
 declare $n as List<String>?;
diff --git a/yql/essentials/tests/sql/suites/action/eval_on_modif_table_fail.sql b/yql/essentials/tests/sql/suites/action/eval_on_modif_table_fail.sql
index 67ec4878f3..4cd9a1ba98 100644
--- a/yql/essentials/tests/sql/suites/action/eval_on_modif_table_fail.sql
+++ b/yql/essentials/tests/sql/suites/action/eval_on_modif_table_fail.sql
@@ -1,5 +1,6 @@
 /* syntax version 1 */
 /* postgres can not */
+/* custom error: Table  "Output" is used before commit */
 USE plato;
 
 insert into Output
diff --git a/yql/essentials/tests/sql/suites/action/eval_typeof_output_table.sql b/yql/essentials/tests/sql/suites/action/eval_typeof_output_table.sql
index 88b43b3736..80428193e3 100644
--- a/yql/essentials/tests/sql/suites/action/eval_typeof_output_table.sql
+++ b/yql/essentials/tests/sql/suites/action/eval_typeof_output_table.sql
@@ -1,5 +1,6 @@
 /* syntax version 1 */
 /* postgres can not */
+/* custom error: Table "Output" does not exist */
 USE plato;
 
 INSERT INTO Output
diff --git a/yql/essentials/tests/sql/suites/action/large_evaluate_for_fail.sql b/yql/essentials/tests/sql/suites/action/large_evaluate_for_fail.sql
index 74a9ac9790..539bda0b60 100644
--- a/yql/essentials/tests/sql/suites/action/large_evaluate_for_fail.sql
+++ b/yql/essentials/tests/sql/suites/action/large_evaluate_for_fail.sql
@@ -1,5 +1,6 @@
 /* syntax version 1 */
 /* postgres can not */
+/* custom error: Too large list for EVALUATE FOR, allowed: 3, got: 10 */
 pragma config.flags("EvaluateForLimit", "3");
 
 evaluate for $_i in ListFromRange(0, 10) do empty_action();
diff --git a/yql/essentials/tests/sql/suites/action/mixed_eval_typeof_world1.sql b/yql/essentials/tests/sql/suites/action/mixed_eval_typeof_world1.sql
index 54de5b2950..af5339c5a5 100644
--- a/yql/essentials/tests/sql/suites/action/mixed_eval_typeof_world1.sql
+++ b/yql/essentials/tests/sql/suites/action/mixed_eval_typeof_world1.sql
@@ -1,5 +1,6 @@
 /* syntax version 1 */
 /* postgres can not */
+/* custom error:Anonymous table "@Output1" must be materialized*/
 use plato;
 
 $force_remove_members = ($struct, $to_remove) -> {
diff --git a/yql/essentials/tests/sql/suites/action/pending_arg_fail.sql b/yql/essentials/tests/sql/suites/action/pending_arg_fail.sql
index 5c09ceb11c..5d3155c610 100644
--- a/yql/essentials/tests/sql/suites/action/pending_arg_fail.sql
+++ b/yql/essentials/tests/sql/suites/action/pending_arg_fail.sql
@@ -1,4 +1,5 @@
 /* syntax version 1 */
 /* postgres can not */
+/* custom error:Failed to evaluate unresolved argument: row. Did you use a column?*/
 use plato;
-select ListExtract(value,key) from Input;
-\ No newline at end of file
+select ListExtract(value,key) from Input;
diff --git a/yql/essentials/tests/sql/suites/aggregate/library_error_in_aggregation_fail.sql b/yql/essentials/tests/sql/suites/aggregate/library_error_in_aggregation_fail.sql
index 3d7640c756..53152d8437 100644
--- a/yql/essentials/tests/sql/suites/aggregate/library_error_in_aggregation_fail.sql
+++ b/yql/essentials/tests/sql/suites/aggregate/library_error_in_aggregation_fail.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Unsupported column type: String*/
 
 USE plato;
 
diff --git a/yql/essentials/tests/sql/suites/binding/tie_bad_count_fail.sql b/yql/essentials/tests/sql/suites/binding/tie_bad_count_fail.sql
index de29966b64..18e5b364db 100644
--- a/yql/essentials/tests/sql/suites/binding/tie_bad_count_fail.sql
+++ b/yql/essentials/tests/sql/suites/binding/tie_bad_count_fail.sql
@@ -1,5 +1,6 @@
 /* syntax version 1 */
 /* postgres can not */
+/* custom error:Expected tuple type of size: 2, but got: 3*/
 $i, $j = AsTuple(1, 5u, "test");
 
 select $i, $j;
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_append_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_append_fail.sql
index 2317d88dd2..720052d6e1 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_append_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_append_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Insert with "column_groups" to existing table is not allowed*/
 USE plato;
 
 insert into Output
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_diff_grp_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_diff_grp_fail.sql
index 9eaa116ad5..f47f4f81f9 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_diff_grp_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_diff_grp_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:All appends within the same commit should have the equal "column_groups" value*/
 USE plato;
 
 insert into Output
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_dup_col_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_dup_col_fail.sql
index e40a0624f9..1acaba9f6d 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_dup_col_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_dup_col_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Duplicate column "a"*/
 USE plato;
 
 -- duplicate column
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_dup_def_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_dup_def_fail.sql
index 445ed03645..8f0db30396 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_dup_def_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_dup_def_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Not more than one group should have # value: "def2"*/
 USE plato;
 
 -- duplicate column
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_empty_grp_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_empty_grp_fail.sql
index 30067b1ded..521675ee5d 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_empty_grp_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_empty_grp_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Expected list with at least two columns, group: "g1"*/
 USE plato;
 
 -- empty group
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_non_lst_yson_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_non_lst_yson_fail.sql
index e7d630bfea..00d0a444b5 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_non_lst_yson_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_non_lst_yson_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Expected list value, group: "g1"*/
 USE plato;
 
 -- bad yson
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_non_map_yson_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_non_map_yson_fail.sql
index 295f9ecf61..58b413af20 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_non_map_yson_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_non_map_yson_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Expected Yson map, got: list_node*/
 USE plato;
 
 -- bad yson
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_non_str_yson_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_non_str_yson_fail.sql
index 35fb731190..8ed51c1871 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_non_str_yson_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_non_str_yson_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Expected string value in list, found int64_node, group: "g1"*/
 USE plato;
 
 -- bad yson
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_non_yson_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_non_yson_fail.sql
index c2a36824dd..209aef0e43 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_non_yson_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_non_yson_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Unexpected '!' while parsing node*/
 USE plato;
 
 -- bad yson
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_short_grp_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_short_grp_fail.sql
index febf511fbe..895f4cbd61 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_short_grp_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_short_grp_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Expected list with at least two columns, group: "g1"*/
 USE plato;
 
 -- too short group
diff --git a/yql/essentials/tests/sql/suites/column_group/hint_unk_col_fail.sql b/yql/essentials/tests/sql/suites/column_group/hint_unk_col_fail.sql
index ebd127dbf3..64a49820a9 100644
--- a/yql/essentials/tests/sql/suites/column_group/hint_unk_col_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/hint_unk_col_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Column group "g1" refers to unknown column "l"*/
 USE plato;
 
 -- unknown column
diff --git a/yql/essentials/tests/sql/suites/column_group/insert_diff_groups1_fail.sql b/yql/essentials/tests/sql/suites/column_group/insert_diff_groups1_fail.sql
index f429533a41..e962ccf194 100644
--- a/yql/essentials/tests/sql/suites/column_group/insert_diff_groups1_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/insert_diff_groups1_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Insert with different "column_groups" to existing table is not allowed*/
 USE plato;
 
 pragma yt.ColumnGroupMode="perusage";
diff --git a/yql/essentials/tests/sql/suites/column_group/insert_diff_groups2_fail.sql b/yql/essentials/tests/sql/suites/column_group/insert_diff_groups2_fail.sql
index 2646c4cfe3..18ef3246fa 100644
--- a/yql/essentials/tests/sql/suites/column_group/insert_diff_groups2_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/insert_diff_groups2_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Insert with different "column_groups" to existing table is not allowed*/
 USE plato;
 
 pragma yt.ColumnGroupMode="perusage";
diff --git a/yql/essentials/tests/sql/suites/column_group/insert_diff_groups3_fail.sql b/yql/essentials/tests/sql/suites/column_group/insert_diff_groups3_fail.sql
index 5f09a1e177..1e0a1a4734 100644
--- a/yql/essentials/tests/sql/suites/column_group/insert_diff_groups3_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_group/insert_diff_groups3_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Insert with "column_groups" to existing table is not allowed*/
 USE plato;
 
 pragma yt.ColumnGroupMode="perusage";
diff --git a/yql/essentials/tests/sql/suites/column_order/union_all_positional_columns_count_fail.sql b/yql/essentials/tests/sql/suites/column_order/union_all_positional_columns_count_fail.sql
index 7f44ded569..3b5fd2428b 100644
--- a/yql/essentials/tests/sql/suites/column_order/union_all_positional_columns_count_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_order/union_all_positional_columns_count_fail.sql
@@ -1,5 +1,6 @@
 /* postgres can not */
 /* syntax version 1 */
+/* custom error:Different column counts in UNION ALL inputs: input #0 has 3 column, input #1 has 2 columns*/
 pragma PositionalUnionAll;
 
 select 1 as c, 2 as b, 3 as a
diff --git a/yql/essentials/tests/sql/suites/column_order/union_all_positional_unordered_fail.sql b/yql/essentials/tests/sql/suites/column_order/union_all_positional_unordered_fail.sql
index 78c4dd86c4..c4128ac9be 100644
--- a/yql/essentials/tests/sql/suites/column_order/union_all_positional_unordered_fail.sql
+++ b/yql/essentials/tests/sql/suites/column_order/union_all_positional_unordered_fail.sql
@@ -1,5 +1,4 @@
-/* postgres can not */
-/* syntax version 1 */
+/* custom error:Input #1 does not have ordered columns. Consider making column order explicit by using SELECT with column names*/
 pragma PositionalUnionAll;
 
 select 1 as c, 2 as b, 3 as a
diff --git a/yql/essentials/tests/sql/suites/datetime/date_tz_impossible_cast.sql b/yql/essentials/tests/sql/suites/datetime/date_tz_impossible_cast.sql
index f8f220c217..87057a8bd6 100644
--- a/yql/essentials/tests/sql/suites/datetime/date_tz_impossible_cast.sql
+++ b/yql/essentials/tests/sql/suites/datetime/date_tz_impossible_cast.sql
@@ -1,3 +1,4 @@
+/* custom error:cannot be casted to TzDate*/
 SELECT
     CAST(AddTimezone(
         /* "1970-01-01T20:59:59Z" */
diff --git a/yql/essentials/tests/sql/suites/expr/as_table_bad_columns_fail.sql b/yql/essentials/tests/sql/suites/expr/as_table_bad_columns_fail.sql
index a21a19e481..79f45f480c 100644
--- a/yql/essentials/tests/sql/suites/expr/as_table_bad_columns_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/as_table_bad_columns_fail.sql
@@ -1,4 +1,5 @@
 /* postgres can not */
+/* custom error:Member not found: Value3. Did you mean Value1?*/
 
 $data = AsList(
     AsStruct(1u AS Key, "v1" AS Value1, 100 AS Value2),
diff --git a/yql/essentials/tests/sql/suites/expr/as_table_bad_row_type_fail.sql b/yql/essentials/tests/sql/suites/expr/as_table_bad_row_type_fail.sql
index beb55021a6..3f972a327f 100644
--- a/yql/essentials/tests/sql/suites/expr/as_table_bad_row_type_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/as_table_bad_row_type_fail.sql
@@ -1,4 +1,5 @@
 /* postgres can not */
+/* custom error:Expected struct type, but got: Uint32*/
 
 $data = AsList(1u, 2u, 3u);
 
diff --git a/yql/essentials/tests/sql/suites/expr/ensure_runtime_fail.sql b/yql/essentials/tests/sql/suites/expr/ensure_runtime_fail.sql
index 4ea3509678..5756dbe688 100644
--- a/yql/essentials/tests/sql/suites/expr/ensure_runtime_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/ensure_runtime_fail.sql
@@ -1,2 +1,3 @@
 /* postgres can not */
+/* custom error:message*/
 select Ensure(42, 2 != 2, "message");
diff --git a/yql/essentials/tests/sql/suites/expr/ensure_type_fail.sql b/yql/essentials/tests/sql/suites/expr/ensure_type_fail.sql
index 08ae648b5c..a0aee93406 100644
--- a/yql/essentials/tests/sql/suites/expr/ensure_type_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/ensure_type_fail.sql
@@ -1,5 +1,5 @@
 /* syntax version 1 */
 /* postgres can not */
 /* syntax version 1 */
-
+/* custom error:Mismatch types: Int32 != String (message)*/
 select EnsureType(42, String, "message");
diff --git a/yql/essentials/tests/sql/suites/expr/implicit_bitcast_fail.sql b/yql/essentials/tests/sql/suites/expr/implicit_bitcast_fail.sql
index b30ed85ce3..f609402b29 100644
--- a/yql/essentials/tests/sql/suites/expr/implicit_bitcast_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/implicit_bitcast_fail.sql
@@ -1,4 +1,5 @@
 /* postgres can not */
+/* custom error:Cannot infer common type for Int64 and Uint64*/
 pragma warning("error", "1107");
 select AsList(
 7498311229109140978,
diff --git a/yql/essentials/tests/sql/suites/expr/list_replicate_fail.sql b/yql/essentials/tests/sql/suites/expr/list_replicate_fail.sql
index 0567764565..fe6b10be5c 100644
--- a/yql/essentials/tests/sql/suites/expr/list_replicate_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/list_replicate_fail.sql
@@ -1,3 +1,4 @@
 /* postgres can not */
+/* custom error:Second argument in ListReplicate = 18446744073709551615 exceeds maximum value = 4294967296*/
 select
 ListReplicate(1, -1);
diff --git a/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_column_fail.sql b/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_column_fail.sql
index eae813be7a..b20bac6443 100644
--- a/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_column_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_column_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Expected hashable and equatable type for key column: key, but got: Resource<'MTRand'>*/
 PRAGMA Warning("error", '1104');
 
 USE plato;
diff --git a/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_having_some_fail.sql b/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_having_some_fail.sql
index 3fc1126b89..d7e1dba4ad 100644
--- a/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_having_some_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_having_some_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Persistable required*/
 PRAGMA Warning("error", '1104');
 
 USE plato;
diff --git a/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_some_fail.sql b/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_some_fail.sql
index e7b61c9b47..9c99d9a10f 100644
--- a/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_some_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/non_persistable_group_by_some_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Persistable required*/
 PRAGMA Warning("error", '1104');
 
 USE plato;
diff --git a/yql/essentials/tests/sql/suites/expr/non_persistable_inner_select_fail.sql b/yql/essentials/tests/sql/suites/expr/non_persistable_inner_select_fail.sql
index 4f6a600c31..a01042a41c 100644
--- a/yql/essentials/tests/sql/suites/expr/non_persistable_inner_select_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/non_persistable_inner_select_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Persistable required*/
 PRAGMA Warning("error", '1104');
 
 USE plato;
diff --git a/yql/essentials/tests/sql/suites/expr/non_persistable_insert_into_fail.sql b/yql/essentials/tests/sql/suites/expr/non_persistable_insert_into_fail.sql
index cd75cf3d25..56b73236a9 100644
--- a/yql/essentials/tests/sql/suites/expr/non_persistable_insert_into_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/non_persistable_insert_into_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Persistable required*/
 PRAGMA Warning("error", '1104');
 
 USE plato;
diff --git a/yql/essentials/tests/sql/suites/expr/non_persistable_order_by_fail.sql b/yql/essentials/tests/sql/suites/expr/non_persistable_order_by_fail.sql
index c94d1805ab..d600f8d474 100644
--- a/yql/essentials/tests/sql/suites/expr/non_persistable_order_by_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/non_persistable_order_by_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Persistable required*/
 PRAGMA Warning("error", '1104');
 
 USE plato;
diff --git a/yql/essentials/tests/sql/suites/expr/unwrap_runtime_fail.sql b/yql/essentials/tests/sql/suites/expr/unwrap_runtime_fail.sql
index 64c87cd8dd..9d55855989 100644
--- a/yql/essentials/tests/sql/suites/expr/unwrap_runtime_fail.sql
+++ b/yql/essentials/tests/sql/suites/expr/unwrap_runtime_fail.sql
@@ -1,2 +1,3 @@
 /* postgres can not */
+/* custom error:message*/
 select Unwrap(null, "message");
diff --git a/yql/essentials/tests/sql/suites/file/parse_file_bad_type_fail.sql b/yql/essentials/tests/sql/suites/file/parse_file_bad_type_fail.sql
index 2a47763852..81fb716b15 100644
--- a/yql/essentials/tests/sql/suites/file/parse_file_bad_type_fail.sql
+++ b/yql/essentials/tests/sql/suites/file/parse_file_bad_type_fail.sql
@@ -1,2 +1,3 @@
 /* postgres can not */
+/* custom error:User type Uuid is not supported*/
 select ParseFile('uuid', "keyid.lst");
diff --git a/yql/essentials/tests/sql/suites/file/second_pass_parse_file_fail.sql b/yql/essentials/tests/sql/suites/file/second_pass_parse_file_fail.sql
index 10a2763a86..14980696a4 100644
--- a/yql/essentials/tests/sql/suites/file/second_pass_parse_file_fail.sql
+++ b/yql/essentials/tests/sql/suites/file/second_pass_parse_file_fail.sql
@@ -1,5 +1,6 @@
 /* postgres can not */
+/* custom error:The file iterator was already created. To scan file data multiple times please use ListCollect either over ParseFile or over some lazy function over it, e.g. ListMap*/
 $list = ParseFile("int32","keyid.lst");
 select ListExtend(
     ListMap($list, ($x)->{return $x + 1 }),
-    ListMap($list, ($x)->{return $x + 2 }));
-\ No newline at end of file
+    ListMap($list, ($x)->{return $x + 2 }));
diff --git a/yql/essentials/tests/sql/suites/hor_join/yield_off.cfg b/yql/essentials/tests/sql/suites/hor_join/yield_off.cfg
new file mode 100644
index 0000000000..3c11f9c54b
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/hor_join/yield_off.cfg
@@ -0,0 +1,3 @@
+in Input input.txt
+udf python3_udf
+providers yt
diff --git a/yql/essentials/tests/sql/suites/in/in_tuple_check0_fail.sql b/yql/essentials/tests/sql/suites/in/in_tuple_check0_fail.sql
index 6c8928c351..f32fb9bcff 100644
--- a/yql/essentials/tests/sql/suites/in/in_tuple_check0_fail.sql
+++ b/yql/essentials/tests/sql/suites/in/in_tuple_check0_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Can't compare Tuple<Int32,Int32> with Tuple<Int32,Tuple<Int32,Int32>>*/
 select AsTuple(1, 1) in (
   AsTuple(2, 1),
   AsTuple(1, 2),
diff --git a/yql/essentials/tests/sql/suites/in/in_tuple_check1_fail.sql b/yql/essentials/tests/sql/suites/in/in_tuple_check1_fail.sql
index ae352a79b6..91bda9b22d 100644
--- a/yql/essentials/tests/sql/suites/in/in_tuple_check1_fail.sql
+++ b/yql/essentials/tests/sql/suites/in/in_tuple_check1_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Can't compare Tuple<Int32,Int32> with Int32*/
 select AsTuple(1, 1) in (
   AsTuple(2, 1),
   AsTuple(1, 2),
diff --git a/yql/essentials/tests/sql/suites/insert/append-proto_fail.cfg b/yql/essentials/tests/sql/suites/insert/append_proto_fail.cfg
index 6d87958c65..6d87958c65 100644
--- a/yql/essentials/tests/sql/suites/insert/append-proto_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert/append_proto_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/insert/append_proto_fail.sql b/yql/essentials/tests/sql/suites/insert/append_proto_fail.sql
new file mode 100644
index 0000000000..437e165a80
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/insert/append_proto_fail.sql
@@ -0,0 +1,6 @@
+/* postgres can not */
+/* multirun can not */
+/* custom error:Table "Output" has udf remappers, append is not allowed*/
+insert into plato.Output
+select * from plato.Input;
+
diff --git a/yql/essentials/tests/sql/suites/insert/append-view_fail.cfg b/yql/essentials/tests/sql/suites/insert/append_view_fail.cfg
index db398a8d2f..db398a8d2f 100644
--- a/yql/essentials/tests/sql/suites/insert/append-view_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert/append_view_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/insert/append_view_fail.sql b/yql/essentials/tests/sql/suites/insert/append_view_fail.sql
new file mode 100644
index 0000000000..3a9f61a60c
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/insert/append_view_fail.sql
@@ -0,0 +1,6 @@
+/* postgres can not */
+/* multirun can not */
+/* custom error:Modification of "Output" view is not supported*/
+insert into plato.Output
+select * from plato.Input;
+
diff --git a/yql/essentials/tests/sql/suites/insert/append-with_read_udf_fail.cfg b/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.cfg
index 1d043c6420..1d043c6420 100644
--- a/yql/essentials/tests/sql/suites/insert/append-with_read_udf_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.sql b/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.sql
new file mode 100644
index 0000000000..437e165a80
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.sql
@@ -0,0 +1,6 @@
+/* postgres can not */
+/* multirun can not */
+/* custom error:Table "Output" has udf remappers, append is not allowed*/
+insert into plato.Output
+select * from plato.Input;
+
diff --git a/yql/essentials/tests/sql/suites/insert/fail_read_view_after_modify.sql b/yql/essentials/tests/sql/suites/insert/fail_read_view_after_modify.sql
index aa2f928459..a58b0d5d89 100644
--- a/yql/essentials/tests/sql/suites/insert/fail_read_view_after_modify.sql
+++ b/yql/essentials/tests/sql/suites/insert/fail_read_view_after_modify.sql
@@ -1,5 +1,6 @@
 /* postgres can not */
 /* syntax version 1 */
+/* custom error:Table "Output" cannot have any view after replacing its content*/
 insert into plato.Output with truncate
 select * from plato.Input;
 
diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta-nonstrict_fail.cfg b/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.cfg
index 1f376d1f93..1f376d1f93 100644
--- a/yql/essentials/tests/sql/suites/insert/keepmeta-nonstrict_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.sql b/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.sql
new file mode 100644
index 0000000000..4ca22363d6
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.sql
@@ -0,0 +1,6 @@
+/* postgres can not */
+/* multirun can not */
+/* custom error:Table "Output" has non-strict schema, truncate with keep meta is not allowed*/
+insert into plato.Output with (truncate, keepmeta)
+select * from plato.Input;
+
diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta-proto_fail.cfg b/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.cfg
index 6d87958c65..6d87958c65 100644
--- a/yql/essentials/tests/sql/suites/insert/keepmeta-proto_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.sql b/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.sql
new file mode 100644
index 0000000000..57967fed0f
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.sql
@@ -0,0 +1,6 @@
+/* postgres can not */
+/* multirun can not */
+/* custom error:Table "Output" has udf remappers, truncate with keep meta is not allowed*/
+insert into plato.Output with (truncate, keepmeta)
+select * from plato.Input;
+
diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta-view_fail.cfg b/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.cfg
index db398a8d2f..db398a8d2f 100644
--- a/yql/essentials/tests/sql/suites/insert/keepmeta-view_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.sql b/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.sql
new file mode 100644
index 0000000000..e4cea9e1cd
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.sql
@@ -0,0 +1,6 @@
+/* postgres can not */
+/* multirun can not */
+/* custom error:Modification of "Output" view is not supported*/
+insert into plato.Output with (truncate, keepmeta)
+select * from plato.Input;
+
diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta-with_read_udf_fail.cfg b/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.cfg
index 1d043c6420..1d043c6420 100644
--- a/yql/essentials/tests/sql/suites/insert/keepmeta-with_read_udf_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.sql b/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.sql
new file mode 100644
index 0000000000..57967fed0f
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.sql
@@ -0,0 +1,6 @@
+/* postgres can not */
+/* multirun can not */
+/* custom error:Table "Output" has udf remappers, truncate with keep meta is not allowed*/
+insert into plato.Output with (truncate, keepmeta)
+select * from plato.Input;
+
diff --git a/yql/essentials/tests/sql/suites/insert/override-view_fail.cfg b/yql/essentials/tests/sql/suites/insert/override_view_fail.cfg
index db398a8d2f..db398a8d2f 100644
--- a/yql/essentials/tests/sql/suites/insert/override-view_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert/override_view_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/insert/override_view_fail.sql b/yql/essentials/tests/sql/suites/insert/override_view_fail.sql
new file mode 100644
index 0000000000..9a2e8ed269
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/insert/override_view_fail.sql
@@ -0,0 +1,5 @@
+/* postgres can not */
+/* custom error:Modification of "Output" view is not supported*/
+insert into plato.Output with truncate
+select * from plato.Input;
+
diff --git a/yql/essentials/tests/sql/suites/insert/use_anon_table_before_commit_fail.sql b/yql/essentials/tests/sql/suites/insert/use_anon_table_before_commit_fail.sql
index acf1795e35..befe8e1209 100644
--- a/yql/essentials/tests/sql/suites/insert/use_anon_table_before_commit_fail.sql
+++ b/yql/essentials/tests/sql/suites/insert/use_anon_table_before_commit_fail.sql
@@ -1,4 +1,5 @@
 /* postgres can not */
+/* custom error:Anonymous table "@a" must be materialized. Use COMMIT before reading from it*/
 use plato;
 
 insert into @a
diff --git a/yql/essentials/tests/sql/suites/insert/use_anon_table_without_fill_fail.sql b/yql/essentials/tests/sql/suites/insert/use_anon_table_without_fill_fail.sql
index 5d78422272..fcb33546b6 100644
--- a/yql/essentials/tests/sql/suites/insert/use_anon_table_without_fill_fail.sql
+++ b/yql/essentials/tests/sql/suites/insert/use_anon_table_without_fill_fail.sql
@@ -1,4 +1,5 @@
 /* postgres can not */
+/* custom error:Anonymous table "@a" must be materialized. Use COMMIT before reading from it*/
 use plato;
 
 select * from @a;
diff --git a/yql/essentials/tests/sql/suites/insert_monotonic/break_sort_fail.sql b/yql/essentials/tests/sql/suites/insert_monotonic/break_sort_fail.sql
index a44b306f32..9aeefc479d 100644
--- a/yql/essentials/tests/sql/suites/insert_monotonic/break_sort_fail.sql
+++ b/yql/essentials/tests/sql/suites/insert_monotonic/break_sort_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Inserts with "monotonic_keys" setting must not change output table sorting*/
 use plato;
 
 INSERT INTO Output WITH MONOTONIC_KEYS
diff --git a/yql/essentials/tests/sql/suites/insert_monotonic/break_unique_fail.cfg b/yql/essentials/tests/sql/suites/insert_monotonic/break_unique_fail.cfg
index a517989811..281562f784 100644
--- a/yql/essentials/tests/sql/suites/insert_monotonic/break_unique_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert_monotonic/break_unique_fail.cfg
@@ -1,3 +1,4 @@
 xfail
 in Input input4.txt
 out Output sorted_unique.txt
+providers yt
diff --git a/yql/essentials/tests/sql/suites/insert_monotonic/break_unique_fail.sql b/yql/essentials/tests/sql/suites/insert_monotonic/break_unique_fail.sql
index 00865ab6c3..ea673eab1c 100644
--- a/yql/essentials/tests/sql/suites/insert_monotonic/break_unique_fail.sql
+++ b/yql/essentials/tests/sql/suites/insert_monotonic/break_unique_fail.sql
@@ -1,7 +1,7 @@
 /* ytfile can not */
-/* dqfile can not */
+/* custom error:Duplicate key*/
 USE plato;
 
 INSERT INTO Output WITH MONOTONIC_KEYS
 SELECT DISTINCT * FROM Input
-ORDER BY key, subkey;
-\ No newline at end of file
+ORDER BY key, subkey;
diff --git a/yql/essentials/tests/sql/suites/insert_monotonic/non_existing_fail.sql b/yql/essentials/tests/sql/suites/insert_monotonic/non_existing_fail.sql
index fe58dae84c..b60c6bb81f 100644
--- a/yql/essentials/tests/sql/suites/insert_monotonic/non_existing_fail.sql
+++ b/yql/essentials/tests/sql/suites/insert_monotonic/non_existing_fail.sql
@@ -1,5 +1,6 @@
+/* custom error:Insert with "monotonic_keys" setting cannot be used with a non-existent table*/
 USE plato;
 
 INSERT INTO Output WITH MONOTONIC_KEYS
 SELECT 1 as key
-ORDER BY key;
-\ No newline at end of file
+ORDER BY key;
diff --git a/yql/essentials/tests/sql/suites/insert_monotonic/not_all_fail.sql b/yql/essentials/tests/sql/suites/insert_monotonic/not_all_fail.sql
index a209e180d7..b00b52d880 100644
--- a/yql/essentials/tests/sql/suites/insert_monotonic/not_all_fail.sql
+++ b/yql/essentials/tests/sql/suites/insert_monotonic/not_all_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:All appends within the same commit should have the same "monotonic_keys" flag*/
 USE plato;
 
 INSERT INTO Output WITH MONOTONIC_KEYS
diff --git a/yql/essentials/tests/sql/suites/insert_monotonic/overlaping_fail.cfg b/yql/essentials/tests/sql/suites/insert_monotonic/overlaping_fail.cfg
index 1b0d1ea529..c8b120c0b3 100644
--- a/yql/essentials/tests/sql/suites/insert_monotonic/overlaping_fail.cfg
+++ b/yql/essentials/tests/sql/suites/insert_monotonic/overlaping_fail.cfg
@@ -1,3 +1,4 @@
 xfail
 in Input input3.txt
 out Output sorted.txt
+providers yt
diff --git a/yql/essentials/tests/sql/suites/insert_monotonic/overlaping_fail.sql b/yql/essentials/tests/sql/suites/insert_monotonic/overlaping_fail.sql
index ec7888b052..4064ac0b9b 100644
--- a/yql/essentials/tests/sql/suites/insert_monotonic/overlaping_fail.sql
+++ b/yql/essentials/tests/sql/suites/insert_monotonic/overlaping_fail.sql
@@ -1,7 +1,7 @@
 /* ytfile can not */
-/* dqfile can not */
+/* custom error:job outputs overlap with original table*/
 USE plato;
 
 INSERT INTO Output WITH MONOTONIC_KEYS
 SELECT * FROM Input
-ORDER BY key, subkey;
-\ No newline at end of file
+ORDER BY key, subkey;
diff --git a/yql/essentials/tests/sql/suites/insert_monotonic/truncate_fail.sql b/yql/essentials/tests/sql/suites/insert_monotonic/truncate_fail.sql
index 374d347fbf..50f8700e82 100644
--- a/yql/essentials/tests/sql/suites/insert_monotonic/truncate_fail.sql
+++ b/yql/essentials/tests/sql/suites/insert_monotonic/truncate_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:"monotonic_keys" setting can not be used with TRUNCATE mode*/
 USE plato;
 
 INSERT INTO Output WITH (MONOTONIC_KEYS, TRUNCATE)
diff --git a/yql/essentials/tests/sql/suites/join/join_table_conflict_fail-off.cfg b/yql/essentials/tests/sql/suites/join/join_table_conflict_fail-off.cfg
deleted file mode 100644
index 4408d29e54..0000000000
--- a/yql/essentials/tests/sql/suites/join/join_table_conflict_fail-off.cfg
+++ /dev/null
@@ -1,3 +0,0 @@
-xfail
-in Input input.txtproviders dq
-pragma Dq.HashJoinMode='off';
diff --git a/yql/essentials/tests/sql/suites/join/join_table_conflict_fail.sql b/yql/essentials/tests/sql/suites/join/join_table_conflict_fail.sql
index e499d334b0..45fb1781a5 100644
--- a/yql/essentials/tests/sql/suites/join/join_table_conflict_fail.sql
+++ b/yql/essentials/tests/sql/suites/join/join_table_conflict_fail.sql
@@ -1,5 +1,5 @@
+/* custom error:column name: value conflicted without correlation name it may be one of: Input.value, d.value*/
 PRAGMA DisableSimpleColumns;
-/* postgres can not */
 USE plato;
 
 $data = (SELECT key as kk, subkey as sk, value || value as value FROM Input WHERE cast(key as uint32)/100 > 3);
diff --git a/yql/essentials/tests/sql/suites/join/strict_keys-off.cfg b/yql/essentials/tests/sql/suites/join/strict_keys-off.cfg
deleted file mode 100644
index e334c38f00..0000000000
--- a/yql/essentials/tests/sql/suites/join/strict_keys-off.cfg
+++ /dev/null
@@ -1,5 +0,0 @@
-xfail
-in Input1 sorted_by_kv1.txt
-in Input2 sorted_by_kv1_opt.txt
-providers dq
-pragma Dq.HashJoinMode='off';
diff --git a/yql/essentials/tests/sql/suites/join/strict_keys.sql b/yql/essentials/tests/sql/suites/join/strict_keys.sql
index e9382fa7fa..b9ca0641f8 100644
--- a/yql/essentials/tests/sql/suites/join/strict_keys.sql
+++ b/yql/essentials/tests/sql/suites/join/strict_keys.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Strict key type match requested, but keys have different types*/
 use plato;
 
 define subquery $strict() as
diff --git a/yql/essentials/tests/sql/suites/json/json_exists/on_error_exception.sql b/yql/essentials/tests/sql/suites/json/json_exists/on_error_exception.sql
index 4670b0aa58..fbcaabcd77 100644
--- a/yql/essentials/tests/sql/suites/json/json_exists/on_error_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_exists/on_error_exception.sql
@@ -1,7 +1,6 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Member not found*/
 
 -- Accessing absent object member will cause jsonpath error in strict mode
 $json = CAST("{}" as Json);
 SELECT
-    JSON_EXISTS($json, "strict $.key" ERROR ON ERROR);
-\ No newline at end of file
+    JSON_EXISTS($json, "strict $.key" ERROR ON ERROR);
diff --git a/yql/essentials/tests/sql/suites/json/json_exists/passing_exception.sql b/yql/essentials/tests/sql/suites/json/json_exists/passing_exception.sql
index 540741eeba..84a75105a9 100644
--- a/yql/essentials/tests/sql/suites/json/json_exists/passing_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_exists/passing_exception.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Expected data or optional of data, but got: Tuple<Int32,Int32>*/
 
 $json = CAST(@@{
     "key": 123
@@ -11,4 +10,4 @@ SELECT
         $json, "strict $var"
         PASSING
             AsTuple(1, 2) as var
-    );
-\ No newline at end of file
+    );
diff --git a/yql/essentials/tests/sql/suites/json/json_query/on_empty_exception.sql b/yql/essentials/tests/sql/suites/json/json_query/on_empty_exception.sql
index 4298669f03..e175a5753f 100644
--- a/yql/essentials/tests/sql/suites/json/json_query/on_empty_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_query/on_empty_exception.sql
@@ -1,7 +1,6 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Empty result*/
 
 -- Accessing absent object member will cause empty result in lax mode
 $json = CAST("{}" as Json);
 SELECT
-    JSON_QUERY($json, "lax $.key" ERROR ON EMPTY);
-\ No newline at end of file
+    JSON_QUERY($json, "lax $.key" ERROR ON EMPTY);
diff --git a/yql/essentials/tests/sql/suites/json/json_query/on_error_exception.sql b/yql/essentials/tests/sql/suites/json/json_query/on_error_exception.sql
index 6b1a7e0701..572988b9be 100644
--- a/yql/essentials/tests/sql/suites/json/json_query/on_error_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_query/on_error_exception.sql
@@ -1,6 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
-
+/* custom error:Member not found*/
 -- Accessing absent object member will cause jsonpath error in strict mode
 $json = CAST("{}" as Json);
 SELECT
diff --git a/yql/essentials/tests/sql/suites/json/json_query/passing_exception.sql b/yql/essentials/tests/sql/suites/json/json_query/passing_exception.sql
index 0be7f24fa1..151e6dbcd1 100644
--- a/yql/essentials/tests/sql/suites/json/json_query/passing_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_query/passing_exception.sql
@@ -1,5 +1,6 @@
 /* syntax version 1 */
 /* postgres can not */
+/* custom error:Expected data or optional of data, but got: Tuple<Int32,Int32>*/
 
 $json = CAST(@@{
     "key": 123
@@ -12,4 +13,4 @@ SELECT
         PASSING
             AsTuple(1, 2) as var
         WITH UNCONDITIONAL ARRAY WRAPPER
-    );
-\ No newline at end of file
+    );
diff --git a/yql/essentials/tests/sql/suites/json/json_value/on_empty_cast_default_exception.sql b/yql/essentials/tests/sql/suites/json/json_value/on_empty_cast_default_exception.sql
index c646cdb91f..8237aef338 100644
--- a/yql/essentials/tests/sql/suites/json/json_value/on_empty_cast_default_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_value/on_empty_cast_default_exception.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Failed to cast default value from ON EMPTY clause to target type Optional<Uint32>*/
 
 $json = CAST("{}" as Json);
 SELECT
diff --git a/yql/essentials/tests/sql/suites/json/json_value/on_empty_exception.sql b/yql/essentials/tests/sql/suites/json/json_value/on_empty_exception.sql
index 1ec55af7ca..d30d3161b0 100644
--- a/yql/essentials/tests/sql/suites/json/json_value/on_empty_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_value/on_empty_exception.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Result is empty*/
 
 $json = CAST("{}" as Json);
 SELECT
diff --git a/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_default_exception.sql b/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_default_exception.sql
index 51f4591ad7..a7169032d9 100644
--- a/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_default_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_default_exception.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Failed to cast default value from ON ERROR clause to target type Optional<Uint16>*/
 
 -- Here JsonPath engine returns error result and ON ERROR section must be used.
 -- But default value in ON ERROR section is -123 and casting it to Uint16 will fail.
diff --git a/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_udf_exception.sql b/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_udf_exception.sql
index 722a06256c..a3fb807857 100644
--- a/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_udf_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_udf_exception.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Cannot convert extracted JSON value to target type*/
 
 -- In this case call to Json2::SqlValueNumber will fail because "string"
 -- does not represent Number value
diff --git a/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_value_exception.sql b/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_value_exception.sql
index 5b97c45e49..a671f89fca 100644
--- a/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_value_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_value/on_error_cast_value_exception.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Failed to cast extracted JSON value to target type Optional<Uint16>*/
 
 -- In this case call to Json2::SqlValueNumber will be successfull, but cast
 -- of -123 to Uint16 will fail
diff --git a/yql/essentials/tests/sql/suites/json/json_value/on_error_jsonpath_exception.sql b/yql/essentials/tests/sql/suites/json/json_value/on_error_jsonpath_exception.sql
index 8314007547..ee4467e138 100644
--- a/yql/essentials/tests/sql/suites/json/json_value/on_error_jsonpath_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_value/on_error_jsonpath_exception.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Member not found*/
 
 $json = CAST("{}" as Json);
 SELECT
diff --git a/yql/essentials/tests/sql/suites/json/json_value/passing_exception.sql b/yql/essentials/tests/sql/suites/json/json_value/passing_exception.sql
index 7e94a73ccc..2c6dfcf9b9 100644
--- a/yql/essentials/tests/sql/suites/json/json_value/passing_exception.sql
+++ b/yql/essentials/tests/sql/suites/json/json_value/passing_exception.sql
@@ -1,5 +1,6 @@
 /* syntax version 1 */
 /* postgres can not */
+/* custom error:Expected data or optional of data, but got: Tuple<Int32,Int32>*/
 
 $json = CAST(@@{
     "key": 123
@@ -11,4 +12,4 @@ SELECT
         $json, "strict $var"
         PASSING
             AsTuple(1, 2) as var
-    );
-\ No newline at end of file
+    );
diff --git a/yql/essentials/tests/sql/suites/lambda/lambda_with_tie_bad_count_fail.sql b/yql/essentials/tests/sql/suites/lambda/lambda_with_tie_bad_count_fail.sql
index 5172adb751..ce5e52aafa 100644
--- a/yql/essentials/tests/sql/suites/lambda/lambda_with_tie_bad_count_fail.sql
+++ b/yql/essentials/tests/sql/suites/lambda/lambda_with_tie_bad_count_fail.sql
@@ -1,4 +1,4 @@
-/* postgres can not */
+/* custom error:Expected tuple type of size: 2, but got: 3*/
 USE plato;
 
 $func = ($x, $y)->{
diff --git a/yql/essentials/tests/sql/suites/lineage/error_type.sql b/yql/essentials/tests/sql/suites/lineage/error_type.sql
index 21f12d6d0d..94fea56f9d 100644
--- a/yql/essentials/tests/sql/suites/lineage/error_type.sql
+++ b/yql/essentials/tests/sql/suites/lineage/error_type.sql
@@ -1,3 +1,4 @@
+/* custom error:Uncompatible member foo types: Int32 and String*/
 USE plato;
 
 INSERT INTO Output
diff --git a/yql/essentials/tests/sql/suites/match_recognize/test_type_predicate.sql b/yql/essentials/tests/sql/suites/match_recognize/test_type_predicate.sql
index b19e7c6671..68726319ce 100644
--- a/yql/essentials/tests/sql/suites/match_recognize/test_type_predicate.sql
+++ b/yql/essentials/tests/sql/suites/match_recognize/test_type_predicate.sql
@@ -1,3 +1,4 @@
+/* custom error:DEFINE expression must be a predicate*/
 pragma FeatureR010="prototype";
 pragma config.flags("MatchRecognizeStream", "disable");
 
diff --git a/yql/essentials/tests/sql/suites/optimizers/sort_by_nonstrict_const.sql b/yql/essentials/tests/sql/suites/optimizers/sort_by_nonstrict_const.sql
index 47abbabbd6..cd682fe33f 100644
--- a/yql/essentials/tests/sql/suites/optimizers/sort_by_nonstrict_const.sql
+++ b/yql/essentials/tests/sql/suites/optimizers/sort_by_nonstrict_const.sql
@@ -1,4 +1,5 @@
 /* yt can not */
+/* custom error:Member not found: date*/
 use plato;
 
 select * from Input order by date, double;
diff --git a/yql/essentials/tests/sql/suites/params/missing_param_fail.sql b/yql/essentials/tests/sql/suites/params/missing_param_fail.sql
index 65aa3ded37..49614fb221 100644
--- a/yql/essentials/tests/sql/suites/params/missing_param_fail.sql
+++ b/yql/essentials/tests/sql/suites/params/missing_param_fail.sql
@@ -1,3 +1,4 @@
+/* custom error:Missing value for parameter: $y*/
 declare $x as int;
 declare $y as int;
 select $x + $y;
diff --git a/yql/essentials/tests/sql/suites/params/no_params_fail.sql b/yql/essentials/tests/sql/suites/params/no_params_fail.sql
index 9144f91e92..4acbca7409 100644
--- a/yql/essentials/tests/sql/suites/params/no_params_fail.sql
+++ b/yql/essentials/tests/sql/suites/params/no_params_fail.sql
@@ -1,2 +1,3 @@
+/* custom error:Missing value for parameter: $x*/
 declare $x as int;
-select 2 * $x;
-\ No newline at end of file
+select 2 * $x;
diff --git a/yql/essentials/tests/sql/suites/params/param_type_mismatch_fail.sql b/yql/essentials/tests/sql/suites/params/param_type_mismatch_fail.sql
index ea6e631d35..e3fd5e0927 100644
--- a/yql/essentials/tests/sql/suites/params/param_type_mismatch_fail.sql
+++ b/yql/essentials/tests/sql/suites/params/param_type_mismatch_fail.sql
@@ -1,2 +1,3 @@
+/* custom error:Unexpected symbol "-" at pos 0 in string "-21"*/
 declare $x as UInt32;
-select 2 * $x;
-\ No newline at end of file
+select 2 * $x;
diff --git a/yql/essentials/tests/sql/suites/pg/join_using_table_used_order2.sql b/yql/essentials/tests/sql/suites/pg/join_using_table_used_order2.sql
index b5d0bdd25c..1a99d4d1fc 100644
--- a/yql/essentials/tests/sql/suites/pg/join_using_table_used_order2.sql
+++ b/yql/essentials/tests/sql/suites/pg/join_using_table_used_order2.sql
@@ -1,10 +1,11 @@
 --!syntax_pg
-select * from 
-    ((select 1 as foo, 1 as bar, 1 as zoo) aa 
+/* custom error:common column name "zoo" appears more than once in left table*/
+select * from
+    ((select 1 as foo, 1 as bar, 1 as zoo) aa
     join
     (select 1 as foo, 1 as bar, 1 as zoo) bb
     using (foo)
     join
     (select 1 as bar, 1 as zoo) cc
     using (zoo)
-    )
-\ No newline at end of file
+    )
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.sql
index 50a8ce4e63..587d729855 100644
--- a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.sql
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.sql
@@ -1,8 +1,9 @@
 --!syntax_pg
-select a.x + 1 as y, b.x + 1 as z from 
+/* custom error:Column reference is ambiguous: x*/
+select a.x + 1 as y, b.x + 1 as z from
     ((select 1 x) a
     join
     (select 1 x) b
     on a.x = b.x)
 order by x+1
--- column reference "x" is ambiguous
-\ No newline at end of file
+-- column reference "x" is ambiguous
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.sql
index 08260c4911..a5f79a68b3 100644
--- a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.sql
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.sql
@@ -1,5 +1,6 @@
 --!syntax_pg
-select a.* from 
+/* custom error:Column reference is ambiguous: x*/
+select a.* from
     (select 1 x, 2 x) a
 order by x
 -- ORDER BY "x" is ambiguous
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.sql
index 7efb496218..cda9243446 100644
--- a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.sql
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.sql
@@ -1,4 +1,5 @@
 --!syntax_pg
-select x + 1 as y, x - 1 as y from 
+/* custom error: ORDER BY column reference 'y' is ambigous*/
+select x + 1 as y, x - 1 as y from
     (select 1 x) a
-order by y+1
-\ No newline at end of file
+order by y+1
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.sql
index 9ceb4a1e41..bd8fb0c34b 100644
--- a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.sql
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.sql
@@ -1,5 +1,6 @@
 --!syntax_pg
-select x + 1 as y, x - 1 as y from 
+/* custom error:ORDER BY column reference 'y' is ambigous*/
+select x + 1 as y, x - 1 as y from
     (select 1 x) a
 order by y
--- order by y is ambigous
-\ No newline at end of file
+-- order by y is ambigous
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.sql
index f27341fb2b..6e83754925 100644
--- a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.sql
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.sql
@@ -1,5 +1,6 @@
 --!syntax_pg
-select z from 
+/* custom error:Column reference is ambiguous: x*/
+select z from
     (select 1 x, 1 x, 3 z) a
 order by x
--- column reference "x" is ambiguous
-\ No newline at end of file
+-- column reference "x" is ambiguous
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.sql
index 22098666df..ea0738592d 100644
--- a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.sql
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.sql
@@ -1,2 +1,3 @@
 --!syntax_pg
-select a.x from (select 1 x, 2 x) a
-\ No newline at end of file
+/* custom error:Column reference is ambiguous: x*/
+select a.x from (select 1 x, 2 x) a
diff --git a/yql/essentials/tests/sql/suites/pragma/yson_strict_fail.sql b/yql/essentials/tests/sql/suites/pragma/yson_strict_fail.sql
index 1db347862d..df71232b39 100644
--- a/yql/essentials/tests/sql/suites/pragma/yson_strict_fail.sql
+++ b/yql/essentials/tests/sql/suites/pragma/yson_strict_fail.sql
@@ -1,4 +1,5 @@
 /* postgres can not */
+/* custom error:Cannot parse string value from integer*/
 PRAGMA yson.Strict;
 
 SELECT Yson::ConvertToString(Yson("122"));
diff --git a/yql/essentials/tests/sql/suites/produce/process_multi_in.cfg b/yql/essentials/tests/sql/suites/produce/process_multi_in.cfg
index 19cfc046c5..5b95850078 100644
--- a/yql/essentials/tests/sql/suites/produce/process_multi_in.cfg
+++ b/yql/essentials/tests/sql/suites/produce/process_multi_in.cfg
@@ -1,3 +1,4 @@
 in Input input0.txt
 res result.txt
 udf python3_udf
+providers yt
diff --git a/yql/essentials/tests/sql/suites/produce/process_multi_out_bad_count_fail.sql b/yql/essentials/tests/sql/suites/produce/process_multi_out_bad_count_fail.sql
index fdd02d93e3..6ad283fafc 100644
--- a/yql/essentials/tests/sql/suites/produce/process_multi_out_bad_count_fail.sql
+++ b/yql/essentials/tests/sql/suites/produce/process_multi_out_bad_count_fail.sql
@@ -1,5 +1,4 @@
-/* syntax version 1 */
-/* postgres can not */
+/* custom error:Expected tuple type of size: 3, but got: 2*/
 $udfScript = @@
 def MyFunc(list):
     return [(int(x.key) % 2, x) for x in list]
diff --git a/yql/essentials/tests/sql/suites/produce/reduce_with_flat_python_stream.cfg b/yql/essentials/tests/sql/suites/produce/reduce_with_flat_python_stream.cfg
new file mode 100644
index 0000000000..e34e70ff55
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/produce/reduce_with_flat_python_stream.cfg
@@ -0,0 +1,3 @@
+in Input0 input0.txt
+udf python3_udf
+providers yt
diff --git a/yql/essentials/tests/sql/suites/schema/read_schema_change_other.sql b/yql/essentials/tests/sql/suites/schema/read_schema_change_other.sql
index 7be00eab9c..eb96315c2a 100644
--- a/yql/essentials/tests/sql/suites/schema/read_schema_change_other.sql
+++ b/yql/essentials/tests/sql/suites/schema/read_schema_change_other.sql
@@ -1 +1,2 @@
+/* custom error:It is forbidden to specify the column '_other'*/
 select * from plato.Input with schema Struct<_other:Yson>;
diff --git a/yql/essentials/tests/sql/suites/schema/select_all_inferschema_range-empty_fail.cfg b/yql/essentials/tests/sql/suites/schema/select_all_inferschema_range_empty_fail.cfg
index c2ff0dfe88..c2ff0dfe88 100644
--- a/yql/essentials/tests/sql/suites/schema/select_all_inferschema_range-empty_fail.cfg
+++ b/yql/essentials/tests/sql/suites/schema/select_all_inferschema_range_empty_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/schema/select_all_inferschema_range_empty_fail.sql b/yql/essentials/tests/sql/suites/schema/select_all_inferschema_range_empty_fail.sql
new file mode 100644
index 0000000000..60e0887a84
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/schema/select_all_inferschema_range_empty_fail.sql
@@ -0,0 +1,3 @@
+/* custom error:Cannot infer schema for table Input2, first 1 row(s) has no columns*/
+pragma yt.InferSchemaTableCountThreshold="0";
+select * from plato.range(``, Input1, Input3) with inferscheme;
diff --git a/yql/essentials/tests/sql/suites/schema/user_schema_append.sql b/yql/essentials/tests/sql/suites/schema/user_schema_append.sql
index 5ec9e939bd..f1b86675c3 100644
--- a/yql/essentials/tests/sql/suites/schema/user_schema_append.sql
+++ b/yql/essentials/tests/sql/suites/schema/user_schema_append.sql
@@ -1,4 +1,4 @@
-/* syntax version 1 */
+/* custom error:Table "Input" row type differs from the written row type: Struct<-subkey:String>*/
 USE plato;
 
 INSERT INTO Input
diff --git a/yql/essentials/tests/sql/suites/select/anon_clash.sql b/yql/essentials/tests/sql/suites/select/anon_clash.sql
index 7fa8927b9b..b4b62d51cf 100644
--- a/yql/essentials/tests/sql/suites/select/anon_clash.sql
+++ b/yql/essentials/tests/sql/suites/select/anon_clash.sql
@@ -1,3 +1,4 @@
+/* custom error: Table "a" does not exist */
 use plato;
 
 insert into @a select 1 as t;
diff --git a/yql/essentials/tests/sql/suites/simple_columns/simple_columns_base_fail.sql b/yql/essentials/tests/sql/suites/simple_columns/simple_columns_base_fail.sql
index 6930913766..85cca8dbec 100644
--- a/yql/essentials/tests/sql/suites/simple_columns/simple_columns_base_fail.sql
+++ b/yql/essentials/tests/sql/suites/simple_columns/simple_columns_base_fail.sql
@@ -1,4 +1,4 @@
-/* postgres can not */
+/* custom error:Duplicated member: magic*/
 PRAGMA SimpleColumns;
 
 USE plato;
@@ -6,7 +6,7 @@ USE plato;
 $req = (SELECT 100500 as magic, t.* FROM Input as t);
 
 --INSERT INTO Output
-SELECT 
+SELECT
   ff.*,
   subkey as magic, -- 'magic' is exist from ff.magic
   value as val
diff --git a/yql/essentials/tests/sql/suites/simple_columns/simple_columns_join_fail.sql b/yql/essentials/tests/sql/suites/simple_columns/simple_columns_join_fail.sql
index 7728a22ba1..0605937349 100644
--- a/yql/essentials/tests/sql/suites/simple_columns/simple_columns_join_fail.sql
+++ b/yql/essentials/tests/sql/suites/simple_columns/simple_columns_join_fail.sql
@@ -1,4 +1,4 @@
-/* postgres can not */
+/* custom error:Duplicated member: kk*/
 PRAGMA SimpleColumns;
 USE plato;
 
diff --git a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingAggregation.cfg b/yql/essentials/tests/sql/suites/solomon/BadDownsamplingAggregation.cfg
deleted file mode 100644
index 58b70eefbe..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingAggregation.cfg
+++ /dev/null
@@ -1,2 +0,0 @@
-providers solomon
-xfail
diff --git a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingAggregation.sql b/yql/essentials/tests/sql/suites/solomon/BadDownsamplingAggregation.sql
deleted file mode 100644
index dda21f9ce6..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingAggregation.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-  `downsampling.aggregation` = "ABC"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingDisabled.cfg b/yql/essentials/tests/sql/suites/solomon/BadDownsamplingDisabled.cfg
deleted file mode 100644
index 58b70eefbe..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingDisabled.cfg
+++ /dev/null
@@ -1,2 +0,0 @@
-providers solomon
-xfail
diff --git a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingDisabled.sql b/yql/essentials/tests/sql/suites/solomon/BadDownsamplingDisabled.sql
deleted file mode 100644
index 61ca6e90b5..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingDisabled.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-  `downsampling.disabled` = "ABC"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingFill.cfg b/yql/essentials/tests/sql/suites/solomon/BadDownsamplingFill.cfg
deleted file mode 100644
index 58b70eefbe..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingFill.cfg
+++ /dev/null
@@ -1,2 +0,0 @@
-providers solomon
-xfail
diff --git a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingFill.sql b/yql/essentials/tests/sql/suites/solomon/BadDownsamplingFill.sql
deleted file mode 100644
index cf7dac7f35..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingFill.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-  `downsampling.fill` = "ABC"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingInterval.cfg b/yql/essentials/tests/sql/suites/solomon/BadDownsamplingInterval.cfg
deleted file mode 100644
index 58b70eefbe..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingInterval.cfg
+++ /dev/null
@@ -1,2 +0,0 @@
-providers solomon
-xfail
diff --git a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingInterval.sql b/yql/essentials/tests/sql/suites/solomon/BadDownsamplingInterval.sql
deleted file mode 100644
index e5f24c16e9..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BadDownsamplingInterval.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-  `downsampling.grid_interval` = "ABC"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/Basic.sql b/yql/essentials/tests/sql/suites/solomon/Basic.sql
deleted file mode 100644
index d59089121f..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/Basic.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/BrokenJsonResponse.cfg b/yql/essentials/tests/sql/suites/solomon/BrokenJsonResponse.cfg
deleted file mode 100644
index 58b70eefbe..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BrokenJsonResponse.cfg
+++ /dev/null
@@ -1,2 +0,0 @@
-providers solomon
-xfail
diff --git a/yql/essentials/tests/sql/suites/solomon/BrokenJsonResponse.sql b/yql/essentials/tests/sql/suites/solomon/BrokenJsonResponse.sql
deleted file mode 100644
index c7fd10d9e3..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/BrokenJsonResponse.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-SELECT * FROM local_solomon.broken_json WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/Downsampling.sql b/yql/essentials/tests/sql/suites/solomon/Downsampling.sql
deleted file mode 100644
index 976cbc696a..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/Downsampling.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-  `downsampling.disabled` = "true",
-  `downsampling.aggregation` = "SUM",
-  `downsampling.grid_interval` = "25",
-  `downsampling.fill` = "PREVIOUS"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/DownsamplingValidSettings.sql b/yql/essentials/tests/sql/suites/solomon/DownsamplingValidSettings.sql
deleted file mode 100644
index c1f59e9de9..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/DownsamplingValidSettings.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-
-  `downsampling.aggregation` = "AVG",
-  `downsampling.aggregation` = "COUNT",
-  `downsampling.aggregation` = "DEFAULT_AGGREGATION",
-  `downsampling.aggregation` = "LAST",
-  `downsampling.aggregation` = "MAX",
-  `downsampling.aggregation` = "MIN",
-  `downsampling.aggregation` = "SUM",
-
-  `downsampling.fill` = "NONE",
-  `downsampling.fill` = "NULL",
-  `downsampling.fill` = "PREVIOUS"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/InvalidProject.cfg b/yql/essentials/tests/sql/suites/solomon/InvalidProject.cfg
deleted file mode 100644
index 58b70eefbe..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/InvalidProject.cfg
+++ /dev/null
@@ -1,2 +0,0 @@
-providers solomon
-xfail
diff --git a/yql/essentials/tests/sql/suites/solomon/InvalidProject.sql b/yql/essentials/tests/sql/suites/solomon/InvalidProject.sql
deleted file mode 100644
index a9275c07d1..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/InvalidProject.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-SELECT * FROM local_solomon.invalid WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/LabelColumns.sql b/yql/essentials/tests/sql/suites/solomon/LabelColumns.sql
deleted file mode 100644
index 0ff5b736c4..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/LabelColumns.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-  labels = "downsampling.disabled, downsampling.fill, project, downsampling.gridMillis"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/Subquery.sql b/yql/essentials/tests/sql/suites/solomon/Subquery.sql
deleted file mode 100644
index d3886b00ff..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/Subquery.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-DEFINE SUBQUERY $q($p) AS
-
-SELECT * FROM local_solomon.my_project WITH (
-  program = $p,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-  `downsampling.disabled` = "true",
-  `downsampling.aggregation` = "SUM",
-  `downsampling.grid_interval` = "25",
-  `downsampling.fill` = "PREVIOUS"
-);
-
-END DEFINE;
-
-SELECT * FROM $q(@@{}@@);
diff --git a/yql/essentials/tests/sql/suites/solomon/UnknownSetting.cfg b/yql/essentials/tests/sql/suites/solomon/UnknownSetting.cfg
deleted file mode 100644
index 58b70eefbe..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/UnknownSetting.cfg
+++ /dev/null
@@ -1,2 +0,0 @@
-providers solomon
-xfail
diff --git a/yql/essentials/tests/sql/suites/solomon/UnknownSetting.sql b/yql/essentials/tests/sql/suites/solomon/UnknownSetting.sql
deleted file mode 100644
index 0e51464d23..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/UnknownSetting.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-SELECT * FROM local_solomon.my_project WITH (
-  program = @@{}@@,
-  from = "2023-12-08T14:40:39Z",
-  to = "2023-12-08T14:45:39Z",
-  unk = "ABC"
-);
diff --git a/yql/essentials/tests/sql/suites/solomon/default.cfg b/yql/essentials/tests/sql/suites/solomon/default.cfg
deleted file mode 100644
index 3e2499f96d..0000000000
--- a/yql/essentials/tests/sql/suites/solomon/default.cfg
+++ /dev/null
@@ -1 +0,0 @@
-providers solomon
diff --git a/yql/essentials/tests/sql/suites/table_range/each_with_non_existing-all_fail.cfg b/yql/essentials/tests/sql/suites/table_range/each_with_non_existing_all_fail.cfg
index 62226ec6e8..62226ec6e8 100644
--- a/yql/essentials/tests/sql/suites/table_range/each_with_non_existing-all_fail.cfg
+++ b/yql/essentials/tests/sql/suites/table_range/each_with_non_existing_all_fail.cfg
diff --git a/yql/essentials/tests/sql/suites/table_range/each_with_non_existing_all_fail.sql b/yql/essentials/tests/sql/suites/table_range/each_with_non_existing_all_fail.sql
new file mode 100644
index 0000000000..fd8caf1393
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/table_range/each_with_non_existing_all_fail.sql
@@ -0,0 +1,5 @@
+/* syntax version 1 */
+/* kikimr can not - range not supported */
+/* custom error:The list of tables is empty*/
+USE plato;
+SELECT * FROM each(["Input1", "Input2", "Input3"]);
diff --git a/yql/essentials/tests/sql/suites/udf/named_args_for_script_with_posargs_reuse_args_fail.sql b/yql/essentials/tests/sql/suites/udf/named_args_for_script_with_posargs_reuse_args_fail.sql
index 21f66fa806..7efb78e427 100644
--- a/yql/essentials/tests/sql/suites/udf/named_args_for_script_with_posargs_reuse_args_fail.sql
+++ b/yql/essentials/tests/sql/suites/udf/named_args_for_script_with_posargs_reuse_args_fail.sql
@@ -1,5 +1,4 @@
-/* postgres can not */
-/* syntax version 1 */
+/* custom error:Argument with name age was already used for positional argument #2*/
 use plato;
 $udfScript = @@
 def AppendInfo(a_name, a_age = None, a_region = None):
diff --git a/yql/essentials/tests/sql/suites/udf/python_struct.cfg b/yql/essentials/tests/sql/suites/udf/python_struct.cfg
index d86459a8db..3c11f9c54b 100644
--- a/yql/essentials/tests/sql/suites/udf/python_struct.cfg
+++ b/yql/essentials/tests/sql/suites/udf/python_struct.cfg
@@ -1,3 +1,3 @@
 in Input input.txt
-udf python2_udf
+udf python3_udf
 providers yt
diff --git a/yql/essentials/tests/sql/suites/udf/python_struct.sql b/yql/essentials/tests/sql/suites/udf/python_struct.sql
index ed7fc8eeb3..82e43427d2 100644
--- a/yql/essentials/tests/sql/suites/udf/python_struct.sql
+++ b/yql/essentials/tests/sql/suites/udf/python_struct.sql
@@ -15,7 +15,7 @@ def NewPerson(name, age):
     (let str (DataType 'String))
     (let personType (StructType '('name str) '('age ui32)))
     (let udfType (CallableType '() '(personType) '(str) '(ui32)))
-    (let udf (ScriptUdf 'Python 'NewPerson udfType $udfScript))
+    (let udf (ScriptUdf 'Python3 'NewPerson udfType $udfScript))
     (return udf)
 ))@@;
 
diff --git a/yql/essentials/tests/sql/suites/udf/wrong_args_fail.sql b/yql/essentials/tests/sql/suites/udf/wrong_args_fail.sql
index 759bfd3816..eed17d5589 100644
--- a/yql/essentials/tests/sql/suites/udf/wrong_args_fail.sql
+++ b/yql/essentials/tests/sql/suites/udf/wrong_args_fail.sql
@@ -1,4 +1,5 @@
 /* postgres can not */
+/* custom error:Callable expected at most 3 argument(s)*/
 
 -- Find has optional args
 select String::ReplaceAll(); -- too few
diff --git a/yql/essentials/tests/sql/suites/view/file_eval.sql b/yql/essentials/tests/sql/suites/view/file_eval.sql
index 890ebdece4..6e64be4356 100644
--- a/yql/essentials/tests/sql/suites/view/file_eval.sql
+++ b/yql/essentials/tests/sql/suites/view/file_eval.sql
@@ -1,5 +1,6 @@
 /* postgres can not */
 /* syntax version 1 */
+/* custom error:FileContent function can't be used inside generated code in views*/
 pragma yt.ViewIsolation = 'true';
 USE plato;
 SELECT k, s, v FROM Input VIEW file_eval;
diff --git a/yql/essentials/tests/sql/suites/view/file_outer.sql b/yql/essentials/tests/sql/suites/view/file_outer.sql
index bc1b0a4070..952a4d8d92 100644
--- a/yql/essentials/tests/sql/suites/view/file_outer.sql
+++ b/yql/essentials/tests/sql/suites/view/file_outer.sql
@@ -1,5 +1,4 @@
-/* postgres can not */
-/* syntax version 1 */
+/* custom error:File not found*/
 pragma yt.ViewIsolation = 'true';
 USE plato;
 SELECT k, s, v FROM Input VIEW file_outer;
diff --git a/yql/essentials/tests/sql/suites/view/file_outer_library.sql b/yql/essentials/tests/sql/suites/view/file_outer_library.sql
index b7e7ee2ad4..e994026f4b 100644
--- a/yql/essentials/tests/sql/suites/view/file_outer_library.sql
+++ b/yql/essentials/tests/sql/suites/view/file_outer_library.sql
@@ -1,5 +1,6 @@
 /* postgres can not */
 /* syntax version 1 */
+/* custom error: does not exist*/
 pragma yt.ViewIsolation = 'true';
 USE plato;
 PRAGMA library('mylib.sql');
diff --git a/yql/essentials/tests/sql/suites/view/secure.sql b/yql/essentials/tests/sql/suites/view/secure.sql
index be73998ca2..15ef309d96 100644
--- a/yql/essentials/tests/sql/suites/view/secure.sql
+++ b/yql/essentials/tests/sql/suites/view/secure.sql
@@ -1,5 +1,4 @@
-/* postgres can not */
-/* syntax version 1 */
+/* custom error:SecureParam function can't be used in views*/
 pragma yt.ViewIsolation = 'true';
 USE plato;
 SELECT k, s, v FROM Input VIEW secure;
diff --git a/yql/essentials/tests/sql/suites/view/secure_eval.sql b/yql/essentials/tests/sql/suites/view/secure_eval.sql
index 32f07f32df..13acee4487 100644
--- a/yql/essentials/tests/sql/suites/view/secure_eval.sql
+++ b/yql/essentials/tests/sql/suites/view/secure_eval.sql
@@ -1,5 +1,4 @@
-/* postgres can not */
-/* syntax version 1 */
+/* custom error:SecureParam function can't be used in views*/
 pragma yt.ViewIsolation = 'true';
 USE plato;
 SELECT k, s, v FROM Input VIEW secure_eval;
diff --git a/yql/essentials/tests/sql/suites/view/secure_eval_dyn.sql b/yql/essentials/tests/sql/suites/view/secure_eval_dyn.sql
index 44f17b18da..0a1b696155 100644
--- a/yql/essentials/tests/sql/suites/view/secure_eval_dyn.sql
+++ b/yql/essentials/tests/sql/suites/view/secure_eval_dyn.sql
@@ -1,5 +1,4 @@
-/* postgres can not */
-/* syntax version 1 */
+/* custom error:FuncCode should have constant function name in views*/
 pragma yt.ViewIsolation = 'true';
 USE plato;
 SELECT k, s, v FROM Input VIEW secure_eval_dynamic;
diff --git a/yql/essentials/tests/sql/suites/weak_field/weak_field_wrong_types_fail.sql b/yql/essentials/tests/sql/suites/weak_field/weak_field_wrong_types_fail.sql
index 0d8cf87a35..447c2a5804 100644
--- a/yql/essentials/tests/sql/suites/weak_field/weak_field_wrong_types_fail.sql
+++ b/yql/essentials/tests/sql/suites/weak_field/weak_field_wrong_types_fail.sql
@@ -1,4 +1,4 @@
-/* postgres can not */
+/* custom error:incompatible WeakField types: Optional<Int32!=Uint32>*/
 use plato;
 SELECT
   WeakField(first_num, "int32", 42) -- first_num column have another type
author	udovichenko-r <udovichenko-r@yandex-team.com>	2024-11-23 22:29:07 +0300
committer	udovichenko-r <udovichenko-r@yandex-team.com>	2024-11-23 22:43:39 +0300
commit	8b9f13e29dea8f76f11579aae5344ac571d5e604 (patch)
tree	0449b096aa6444a36ba8cc5a3b3c64e0e7b94ed1
parent	284518c9e820058795b9e7cc44ff26b25f3f455b (diff)
download	ydb-8b9f13e29dea8f76f11579aae5344ac571d5e604.tar.gz