diff options
| 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 /yql/essentials | |
| parent | 284518c9e820058795b9e7cc44ff26b25f3f455b (diff) | |
| download | ydb-8b9f13e29dea8f76f11579aae5344ac571d5e604.tar.gz | |
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
Diffstat (limited to 'yql/essentials')
149 files changed, 617 insertions, 640 deletions
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 |