diff options
author | YDBot <[email protected]> | 2025-10-23 18:38:13 +0000 |
---|---|---|
committer | YDBot <[email protected]> | 2025-10-23 18:38:13 +0000 |
commit | 564cf7cb2255a107b4f44c18b2a1844041f20b4d (patch) | |
tree | 6a4a60e8bde612dcc3ac7fd93fffbd36351d4e35 /yql/essentials/tests | |
parent | 89a17b25091c24744b7ebd0650b5b810457b1145 (diff) | |
parent | a703d86902fd02bd8e373d959b2498c034657449 (diff) |
Diffstat (limited to 'yql/essentials/tests')
34 files changed, 272 insertions, 12 deletions
diff --git a/yql/essentials/tests/common/test_framework/yql_utils.py b/yql/essentials/tests/common/test_framework/yql_utils.py index e40021d566c..335e6ebb608 100644 --- a/yql/essentials/tests/common/test_framework/yql_utils.py +++ b/yql/essentials/tests/common/test_framework/yql_utils.py @@ -702,9 +702,12 @@ def get_mount_config_file(content=None): def run_command(program, cmd, tmpdir_module=None, stdin=None, - check_exit_code=True, env=None, stdout=None): + check_exit_code=True, env=None, stdout=None, + cwd=None): if tmpdir_module is None: tmpdir_module = tempfile.mkdtemp() + if cwd is None: + cwd = tmpdir_module stdin_stream = None if isinstance(stdin, six.string_types): @@ -735,7 +738,7 @@ def run_command(program, cmd, tmpdir_module=None, stdin=None, res = yatest.common.execute( cmd, - cwd=tmpdir_module, + cwd=cwd, stdin=stdin_stream, stdout=stdout_stream, stderr=stderr_stream, diff --git a/yql/essentials/tests/sql/minirun/part1/canondata/result.json b/yql/essentials/tests/sql/minirun/part1/canondata/result.json index bf94623311a..5cb02eb55e3 100644 --- a/yql/essentials/tests/sql/minirun/part1/canondata/result.json +++ b/yql/essentials/tests/sql/minirun/part1/canondata/result.json @@ -559,6 +559,20 @@ "uri": "https://{canondata_backend}/1942525/d23808e75f3586fe0f94591ae8678878a50edd66/resource.tar.gz#test.test_expr-as_variant_enum-default.txt-Results_/results.txt" } ], + "test.test[expr-concat_many--Debug]": [ + { + "checksum": "7a4c31257f61a51d15236580c89e6122", + "size": 581, + "uri": "https://{canondata_backend}/212715/6d9ed45819070f2bb9ee6b84a7d7ce8c50efaa7c/resource.tar.gz#test.test_expr-concat_many--Debug_/opt.yql" + } + ], + "test.test[expr-concat_many--Results]": [ + { + "checksum": "66b26bd358dcff46379f0033958b0d96", + "size": 2515, + "uri": "https://{canondata_backend}/1784117/a4a7ed2a9293d986efe2868cc4011856a43b2563/resource.tar.gz#test.test_expr-concat_many--Results_/results.txt" + } + ], "test.test[expr-expr_named_yql_lambda_quotes-default.txt-Debug]": [ { "checksum": "9da8a64a8f8feb07730d84fe360e3096", diff --git a/yql/essentials/tests/sql/minirun/part4/canondata/result.json b/yql/essentials/tests/sql/minirun/part4/canondata/result.json index 474ac7fc4fe..6d7635ea9f5 100644 --- a/yql/essentials/tests/sql/minirun/part4/canondata/result.json +++ b/yql/essentials/tests/sql/minirun/part4/canondata/result.json @@ -1863,6 +1863,23 @@ "uri": "https://{canondata_backend}/1881367/0d65113c859922c39754b7a5431118dd49b482da/resource.tar.gz#test.test_select_yql-expr-default.txt-Results_/results.txt" } ], + "test.test[simple_pg-to_date-default.txt-Debug]": [ + { + "checksum": "9f5c3a94ec122f7884cd5781b16161ed", + "size": 469, + "uri": "https://{canondata_backend}/1773845/3457201fb85fe228147029c520474aa6b1c9f713/resource.tar.gz#test.test_simple_pg-to_date-default.txt-Debug_/opt.yql" + } + ], + "test.test[simple_pg-to_date-default.txt-Results]": [ + { + "checksum": "4a40b76692fd739bb30679dc9b6345a2", + "size": 892, + "uri": "https://{canondata_backend}/1773845/3457201fb85fe228147029c520474aa6b1c9f713/resource.tar.gz#test.test_simple_pg-to_date-default.txt-Results_/results.txt" + }, + { + "uri": "file://test.test_simple_pg-to_date-default.txt-Results_/extracted" + } + ], "test.test[udf-same_udf_modules--Debug]": [ { "checksum": "f90e4ed7c7d964c319a4155dda443d04", diff --git a/yql/essentials/tests/sql/minirun/part4/canondata/test.test_simple_pg-to_date-default.txt-Results_/extracted b/yql/essentials/tests/sql/minirun/part4/canondata/test.test_simple_pg-to_date-default.txt-Results_/extracted new file mode 100644 index 00000000000..0020aeb56c4 --- /dev/null +++ b/yql/essentials/tests/sql/minirun/part4/canondata/test.test_simple_pg-to_date-default.txt-Results_/extracted @@ -0,0 +1,5 @@ +<tmp_path>/program.sql:<main>: Warning: Parse Sql + + <tmp_path>/program.sql:<main>:1:18: Warning: Consider using function DateTime::Format instead to avoid performance overhead + select SimplePg::to_date('2023-03-01','%Y-%m-%d'); + ^
\ No newline at end of file diff --git a/yql/essentials/tests/sql/minirun/part5/canondata/result.json b/yql/essentials/tests/sql/minirun/part5/canondata/result.json index 36c33ebc277..e5acbc6acfe 100644 --- a/yql/essentials/tests/sql/minirun/part5/canondata/result.json +++ b/yql/essentials/tests/sql/minirun/part5/canondata/result.json @@ -1957,6 +1957,23 @@ "uri": "https://{canondata_backend}/1900335/2e7a3a0284dd25621ff685fc5c99cf0aa70fd6a5/resource.tar.gz#test.test_side_effects-x_not_x-default.txt-Results_/results.txt" } ], + "test.test[simple_pg-now-default.txt-Debug]": [ + { + "checksum": "2d3c63e18948b1dd8cab2769647acdd0", + "size": 898, + "uri": "https://{canondata_backend}/1916746/d2551994b6d45599afba8700f3b91fecc677c43d/resource.tar.gz#test.test_simple_pg-now-default.txt-Debug_/opt.yql" + } + ], + "test.test[simple_pg-now-default.txt-Results]": [ + { + "checksum": "56de73c873cafff267843da0d2621330", + "size": 889, + "uri": "https://{canondata_backend}/1916746/d2551994b6d45599afba8700f3b91fecc677c43d/resource.tar.gz#test.test_simple_pg-now-default.txt-Results_/results.txt" + }, + { + "uri": "file://test.test_simple_pg-now-default.txt-Results_/extracted" + } + ], "test.test[subselect-limit-default.txt-Debug]": [ { "checksum": "de86d4e45aba6e09a5162523125ace0b", diff --git a/yql/essentials/tests/sql/minirun/part5/canondata/test.test_simple_pg-now-default.txt-Results_/extracted b/yql/essentials/tests/sql/minirun/part5/canondata/test.test_simple_pg-now-default.txt-Results_/extracted new file mode 100644 index 00000000000..33bb6183207 --- /dev/null +++ b/yql/essentials/tests/sql/minirun/part5/canondata/test.test_simple_pg-now-default.txt-Results_/extracted @@ -0,0 +1,5 @@ +<tmp_path>/program.sql:<main>: Warning: Parse Sql + + <tmp_path>/program.sql:<main>:1:18: Warning: Consider using function CurrentUtcTimestamp instead to avoid performance overhead + select SimplePg::now() >= Date('1970-01-01'); + ^
\ No newline at end of file diff --git a/yql/essentials/tests/sql/minirun/part6/canondata/result.json b/yql/essentials/tests/sql/minirun/part6/canondata/result.json index 3d476f452ab..0280b63c4c4 100644 --- a/yql/essentials/tests/sql/minirun/part6/canondata/result.json +++ b/yql/essentials/tests/sql/minirun/part6/canondata/result.json @@ -1073,16 +1073,16 @@ ], "test.test[linear-types-default.txt-Debug]": [ { - "checksum": "013b2c346f23df65f2e461b9a9cff6f9", - "size": 420, - "uri": "https://{canondata_backend}/1781765/972251ebb8228a889fb9ce1afa36c3b56345fcfe/resource.tar.gz#test.test_linear-types-default.txt-Debug_/opt.yql" + "checksum": "e959afd820df98d7a89cbab6713dc174", + "size": 488, + "uri": "https://{canondata_backend}/1936997/cec6a07b611625302390ba988f3ac059f5c8f512/resource.tar.gz#test.test_linear-types-default.txt-Debug_/opt.yql" } ], "test.test[linear-types-default.txt-Results]": [ { - "checksum": "c41448a02612fcc93b6ebd7962faad93", - "size": 1625, - "uri": "https://{canondata_backend}/1781765/972251ebb8228a889fb9ce1afa36c3b56345fcfe/resource.tar.gz#test.test_linear-types-default.txt-Results_/results.txt" + "checksum": "961d16c08981e2d4058c5d6c48f46ccc", + "size": 2244, + "uri": "https://{canondata_backend}/1936997/cec6a07b611625302390ba988f3ac059f5c8f512/resource.tar.gz#test.test_linear-types-default.txt-Results_/results.txt" } ], "test.test[match_recognize-alerts_without_order-default.txt-Debug]": [ @@ -1631,6 +1631,40 @@ "uri": "https://{canondata_backend}/1920236/af1980602a860984760f6d3255d8f2a3de82777a/resource.tar.gz#test.test_pg_duplicated-star_from_crossjoin-default.txt-Results_/results.txt" } ], + "test.test[simple_pg-pragma-default.txt-Debug]": [ + { + "checksum": "2d3c63e18948b1dd8cab2769647acdd0", + "size": 898, + "uri": "https://{canondata_backend}/1942278/b7a0fe5dba368f323db6291b79e7017e3f0a91a0/resource.tar.gz#test.test_simple_pg-pragma-default.txt-Debug_/opt.yql" + } + ], + "test.test[simple_pg-pragma-default.txt-Results]": [ + { + "checksum": "56de73c873cafff267843da0d2621330", + "size": 889, + "uri": "https://{canondata_backend}/1942278/b7a0fe5dba368f323db6291b79e7017e3f0a91a0/resource.tar.gz#test.test_simple_pg-pragma-default.txt-Results_/results.txt" + }, + { + "uri": "file://test.test_simple_pg-pragma-default.txt-Results_/extracted" + } + ], + "test.test[simple_pg-round-default.txt-Debug]": [ + { + "checksum": "9ef172cabee319e50fd07d2f16588240", + "size": 523, + "uri": "https://{canondata_backend}/1936947/456885fb713a2218b2b2c8976283f4289cd33e92/resource.tar.gz#test.test_simple_pg-round-default.txt-Debug_/opt.yql" + } + ], + "test.test[simple_pg-round-default.txt-Results]": [ + { + "checksum": "53b6b44651c1a5168fbec7e2e66d51dc", + "size": 1377, + "uri": "https://{canondata_backend}/1936947/456885fb713a2218b2b2c8976283f4289cd33e92/resource.tar.gz#test.test_simple_pg-round-default.txt-Results_/results.txt" + }, + { + "uri": "file://test.test_simple_pg-round-default.txt-Results_/extracted" + } + ], "test.test[udf-automap_null--Debug]": [ { "checksum": "a4e7cb9b205e1bb880e5cedd016c264d", diff --git a/yql/essentials/tests/sql/minirun/part6/canondata/test.test_simple_pg-pragma-default.txt-Results_/extracted b/yql/essentials/tests/sql/minirun/part6/canondata/test.test_simple_pg-pragma-default.txt-Results_/extracted new file mode 100644 index 00000000000..960a18c84ce --- /dev/null +++ b/yql/essentials/tests/sql/minirun/part6/canondata/test.test_simple_pg-pragma-default.txt-Results_/extracted @@ -0,0 +1,5 @@ +<tmp_path>/program.sql:<main>: Warning: Parse Sql + + <tmp_path>/program.sql:<main>:2:8: Warning: Consider using function CurrentUtcTimestamp instead to avoid performance overhead + select now() >= Date('1970-01-01'); + ^
\ No newline at end of file diff --git a/yql/essentials/tests/sql/minirun/part6/canondata/test.test_simple_pg-round-default.txt-Results_/extracted b/yql/essentials/tests/sql/minirun/part6/canondata/test.test_simple_pg-round-default.txt-Results_/extracted new file mode 100644 index 00000000000..a8b5f7f1636 --- /dev/null +++ b/yql/essentials/tests/sql/minirun/part6/canondata/test.test_simple_pg-round-default.txt-Results_/extracted @@ -0,0 +1,8 @@ +<tmp_path>/program.sql:<main>: Warning: Parse Sql + + <tmp_path>/program.sql:<main>:1:18: Warning: Consider using function Math::Round instead to avoid performance overhead + select SimplePg::round(1.2345, 2), SimplePg::round(1.2345) + ^ + <tmp_path>/program.sql:<main>:1:46: Warning: Consider using function Math::Round instead to avoid performance overhead + select SimplePg::round(1.2345, 2), SimplePg::round(1.2345) + ^
\ No newline at end of file diff --git a/yql/essentials/tests/sql/sql2yql/canondata/result.json b/yql/essentials/tests/sql/sql2yql/canondata/result.json index c3a4b4510ab..d6015859102 100644 --- a/yql/essentials/tests/sql/sql2yql/canondata/result.json +++ b/yql/essentials/tests/sql/sql2yql/canondata/result.json @@ -2918,6 +2918,13 @@ "uri": "https://{canondata_backend}/1937150/ec0019724df75083b0e89cab22f57e10ef36744e/resource.tar.gz#test_sql2yql.test_expr-common_type_for_resource_and_data_/sql.yql" } ], + "test_sql2yql.test[expr-concat_many]": [ + { + "checksum": "d9e698da5ede3c7520b7f0d122ab8566", + "size": 1935, + "uri": "https://{canondata_backend}/1936842/92e2458bff4de81de9f2c44dae4a80b1a84e7c0c/resource.tar.gz#test_sql2yql.test_expr-concat_many_/sql.yql" + } + ], "test_sql2yql.test[expr-container_comp]": [ { "checksum": "6aaee0040ccee9661847c7edf6f681bb", @@ -5223,9 +5230,9 @@ ], "test_sql2yql.test[linear-types]": [ { - "checksum": "f756d489eb05467c7a6414636f47f37e", - "size": 1609, - "uri": "https://{canondata_backend}/1781765/e398ef188885373eb0a98e1d374e17ce1b8dfd7c/resource.tar.gz#test_sql2yql.test_linear-types_/sql.yql" + "checksum": "6557c445f5b203f2fcc92868f053a679", + "size": 1988, + "uri": "https://{canondata_backend}/1936997/73046b615bcbb6ccac48880b83eb4e65a52b2433/resource.tar.gz#test_sql2yql.test_linear-types_/sql.yql" } ], "test_sql2yql.test[linear-types_reflection]": [ @@ -8385,6 +8392,34 @@ "uri": "https://{canondata_backend}/1775059/be020ceb210e118c9d8f06ae73e0f97466c49478/resource.tar.gz#test_sql2yql.test_side_effects-x_not_x_fail_/sql.yql" } ], + "test_sql2yql.test[simple_pg-now]": [ + { + "checksum": "9c101cb0547fdd904399f3c7b83b3ab7", + "size": 1048, + "uri": "https://{canondata_backend}/1924537/1876fc2fd71d40ff2f24591df6891537a5b4956d/resource.tar.gz#test_sql2yql.test_simple_pg-now_/sql.yql" + } + ], + "test_sql2yql.test[simple_pg-pragma]": [ + { + "checksum": "9c101cb0547fdd904399f3c7b83b3ab7", + "size": 1048, + "uri": "https://{canondata_backend}/1936947/c82dd7041f2b3bfb7b87a0b701fa34f4580773cb/resource.tar.gz#test_sql2yql.test_simple_pg-pragma_/sql.yql" + } + ], + "test_sql2yql.test[simple_pg-round]": [ + { + "checksum": "4ed23580f5026bd7d37363a78184829a", + "size": 1272, + "uri": "https://{canondata_backend}/1924537/df91eb332806507b9bce1d113284c9fc64117e5a/resource.tar.gz#test_sql2yql.test_simple_pg-round_/sql.yql" + } + ], + "test_sql2yql.test[simple_pg-to_date]": [ + { + "checksum": "25d4a367b7ebbbce69bb57536228aeac", + "size": 1077, + "uri": "https://{canondata_backend}/1942278/d4aeb569707e31b9d1898c7eee38a87ffd0b47b9/resource.tar.gz#test_sql2yql.test_simple_pg-to_date_/sql.yql" + } + ], "test_sql2yql.test[subselect-aggregate]": [ { "checksum": "f948f4ad0c25bd1bf52f63dc1ba367e7", @@ -10918,6 +10953,11 @@ "uri": "file://test_sql_format.test_expr-common_type_for_resource_and_data_/formatted.sql" } ], + "test_sql_format.test[expr-concat_many]": [ + { + "uri": "file://test_sql_format.test_expr-concat_many_/formatted.sql" + } + ], "test_sql_format.test[expr-container_comp]": [ { "uri": "file://test_sql_format.test_expr-container_comp_/formatted.sql" @@ -13368,6 +13408,26 @@ "uri": "file://test_sql_format.test_side_effects-x_not_x_fail_/formatted.sql" } ], + "test_sql_format.test[simple_pg-now]": [ + { + "uri": "file://test_sql_format.test_simple_pg-now_/formatted.sql" + } + ], + "test_sql_format.test[simple_pg-pragma]": [ + { + "uri": "file://test_sql_format.test_simple_pg-pragma_/formatted.sql" + } + ], + "test_sql_format.test[simple_pg-round]": [ + { + "uri": "file://test_sql_format.test_simple_pg-round_/formatted.sql" + } + ], + "test_sql_format.test[simple_pg-to_date]": [ + { + "uri": "file://test_sql_format.test_simple_pg-to_date_/formatted.sql" + } + ], "test_sql_format.test[subselect-aggregate]": [ { "uri": "file://test_sql_format.test_subselect-aggregate_/formatted.sql" @@ -14045,6 +14105,41 @@ "uri": "https://{canondata_backend}/1924537/c7a75d88255019fa5cdd3450d7e30c52905fc710/resource.tar.gz#test_sql_negative.test_select-use_subrequest_as_table-_/err_file.out" } ], + "test_sql_negative.test[simple_pg-no_prefix-]": [ + { + "checksum": "82ad4cbdf252624cabf99462540b15a6", + "size": 217, + "uri": "https://{canondata_backend}/1942173/ba37bdfc0cbbc483e28a14d279a103b81539bcd0/resource.tar.gz#test_sql_negative.test_simple_pg-no_prefix-_/err_file.out" + } + ], + "test_sql_negative.test[simple_pg-pg_only_agg-]": [ + { + "checksum": "ffeb98f943a2d86d3fcd64bdf4696d18", + "size": 130, + "uri": "https://{canondata_backend}/1936273/cac61363c739bb4c3caa53e64b12539fb829b842/resource.tar.gz#test_sql_negative.test_simple_pg-pg_only_agg-_/err_file.out" + } + ], + "test_sql_negative.test[simple_pg-pg_only_normal-]": [ + { + "checksum": "468d7d943aa6b17315278fdba9df67b8", + "size": 100, + "uri": "https://{canondata_backend}/1936273/cac61363c739bb4c3caa53e64b12539fb829b842/resource.tar.gz#test_sql_negative.test_simple_pg-pg_only_normal-_/err_file.out" + } + ], + "test_sql_negative.test[simple_pg-pragma_off-]": [ + { + "checksum": "9e91df341ed1d8d5aba94245e41ad64b", + "size": 226, + "uri": "https://{canondata_backend}/1937027/d01fd2a56cb739bdb782ced3cf52623012d7ca49/resource.tar.gz#test_sql_negative.test_simple_pg-pragma_off-_/err_file.out" + } + ], + "test_sql_negative.test[simple_pg-warn_as_error-]": [ + { + "checksum": "06c97b751680598e14632d481ba20d80", + "size": 157, + "uri": "https://{canondata_backend}/1942173/ba37bdfc0cbbc483e28a14d279a103b81539bcd0/resource.tar.gz#test_sql_negative.test_simple_pg-warn_as_error-_/err_file.out" + } + ], "test_sql_negative.test[subselect-group_by_no_source-]": [ { "checksum": "89df5ece669c02f9a18c773bda291633", diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_expr-concat_many_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_expr-concat_many_/formatted.sql new file mode 100644 index 00000000000..0b837768499 --- /dev/null +++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_expr-concat_many_/formatted.sql @@ -0,0 +1,8 @@ +SELECT + concat(NULL), + concat('aa'), + concat('aa', 'bb', 'cc'), + concat(just('aa'u), just('bb')), + concat('aa', 'bb'u), + concat('aa'u, just('bb'u)) +; diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_linear-types_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_linear-types_/formatted.sql index 55128f8b7d7..ff8d5236b7a 100644 --- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_linear-types_/formatted.sql +++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_linear-types_/formatted.sql @@ -1,5 +1,7 @@ SELECT + FormatType(Linear<Int32>), FormatType(LinearType(Int32)), + FormatType(DynamicLinear<Int32>), FormatType(DynamicLinearType(Int32)), FormatType(ParseType('Linear<Int32>')), FormatType(LinearItemType(LinearType(Int32))) diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-now_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-now_/formatted.sql new file mode 100644 index 00000000000..b1dad8c0aa7 --- /dev/null +++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-now_/formatted.sql @@ -0,0 +1,3 @@ +SELECT + SimplePg::now() >= Date('1970-01-01') +; diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-pragma_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-pragma_/formatted.sql new file mode 100644 index 00000000000..1d36cc3d2be --- /dev/null +++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-pragma_/formatted.sql @@ -0,0 +1,5 @@ +PRAGMA SimplePg; + +SELECT + now() >= Date('1970-01-01') +; diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-round_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-round_/formatted.sql new file mode 100644 index 00000000000..61bc340acea --- /dev/null +++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-round_/formatted.sql @@ -0,0 +1,4 @@ +SELECT + SimplePg::round(1.2345, 2), + SimplePg::round(1.2345) +; diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-to_date_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-to_date_/formatted.sql new file mode 100644 index 00000000000..fadc8f35dca --- /dev/null +++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-to_date_/formatted.sql @@ -0,0 +1,3 @@ +SELECT + SimplePg::to_date('2023-03-01', '%Y-%m-%d') +; diff --git a/yql/essentials/tests/sql/suites/expr/concat_many.cfg b/yql/essentials/tests/sql/suites/expr/concat_many.cfg new file mode 100644 index 00000000000..7e882f1da85 --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/concat_many.cfg @@ -0,0 +1,2 @@ +langver 2025.04 + diff --git a/yql/essentials/tests/sql/suites/expr/concat_many.yql b/yql/essentials/tests/sql/suites/expr/concat_many.yql new file mode 100644 index 00000000000..58ef1cc243a --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/concat_many.yql @@ -0,0 +1,5 @@ +select concat(null),concat('aa'), + concat('aa','bb','cc'),concat(just('aa'u),just('bb')), + concat('aa','bb'u),concat('aa'u,just('bb'u)); + + diff --git a/yql/essentials/tests/sql/suites/linear/types.yql b/yql/essentials/tests/sql/suites/linear/types.yql index a9d832acd94..04d49c74b9c 100644 --- a/yql/essentials/tests/sql/suites/linear/types.yql +++ b/yql/essentials/tests/sql/suites/linear/types.yql @@ -1,4 +1,6 @@ -select FormatType(LinearType(Int32)), +select FormatType(Linear<Int32>), + FormatType(LinearType(Int32)), + FormatType(DynamicLinear<Int32>), FormatType(DynamicLinearType(Int32)), FormatType(ParseType('Linear<Int32>')), FormatType(LinearItemType(LinearType(Int32))) diff --git a/yql/essentials/tests/sql/suites/simple_pg/default.cfg b/yql/essentials/tests/sql/suites/simple_pg/default.cfg new file mode 100644 index 00000000000..617474f8d63 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/default.cfg @@ -0,0 +1 @@ +langver 2025.04 diff --git a/yql/essentials/tests/sql/suites/simple_pg/no_prefix.cfg b/yql/essentials/tests/sql/suites/simple_pg/no_prefix.cfg new file mode 100644 index 00000000000..b106572754f --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/no_prefix.cfg @@ -0,0 +1 @@ +xsqlfail diff --git a/yql/essentials/tests/sql/suites/simple_pg/no_prefix.yql b/yql/essentials/tests/sql/suites/simple_pg/no_prefix.yql new file mode 100644 index 00000000000..292af34c653 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/no_prefix.yql @@ -0,0 +1 @@ +select now(); diff --git a/yql/essentials/tests/sql/suites/simple_pg/now.yql b/yql/essentials/tests/sql/suites/simple_pg/now.yql new file mode 100644 index 00000000000..3dd4531a901 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/now.yql @@ -0,0 +1 @@ +select SimplePg::now() >= Date('1970-01-01'); diff --git a/yql/essentials/tests/sql/suites/simple_pg/pg_only_agg.cfg b/yql/essentials/tests/sql/suites/simple_pg/pg_only_agg.cfg new file mode 100644 index 00000000000..b106572754f --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/pg_only_agg.cfg @@ -0,0 +1 @@ +xsqlfail diff --git a/yql/essentials/tests/sql/suites/simple_pg/pg_only_agg.yql b/yql/essentials/tests/sql/suites/simple_pg/pg_only_agg.yql new file mode 100644 index 00000000000..0fccafd55d8 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/pg_only_agg.yql @@ -0,0 +1 @@ +select string_agg('a','b'); diff --git a/yql/essentials/tests/sql/suites/simple_pg/pg_only_normal.cfg b/yql/essentials/tests/sql/suites/simple_pg/pg_only_normal.cfg new file mode 100644 index 00000000000..b106572754f --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/pg_only_normal.cfg @@ -0,0 +1 @@ +xsqlfail diff --git a/yql/essentials/tests/sql/suites/simple_pg/pg_only_normal.yql b/yql/essentials/tests/sql/suites/simple_pg/pg_only_normal.yql new file mode 100644 index 00000000000..9f1476c6ef1 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/pg_only_normal.yql @@ -0,0 +1 @@ +select age(1); diff --git a/yql/essentials/tests/sql/suites/simple_pg/pragma.yql b/yql/essentials/tests/sql/suites/simple_pg/pragma.yql new file mode 100644 index 00000000000..9c0eede4e68 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/pragma.yql @@ -0,0 +1,2 @@ +pragma SimplePg; +select now() >= Date('1970-01-01'); diff --git a/yql/essentials/tests/sql/suites/simple_pg/pragma_off.cfg b/yql/essentials/tests/sql/suites/simple_pg/pragma_off.cfg new file mode 100644 index 00000000000..b106572754f --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/pragma_off.cfg @@ -0,0 +1 @@ +xsqlfail diff --git a/yql/essentials/tests/sql/suites/simple_pg/pragma_off.yql b/yql/essentials/tests/sql/suites/simple_pg/pragma_off.yql new file mode 100644 index 00000000000..1d4adb548f4 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/pragma_off.yql @@ -0,0 +1,7 @@ +pragma SimplePg; +define action $a() as + pragma DisableSimplePg; + select now(); +end define; + +do $a(); diff --git a/yql/essentials/tests/sql/suites/simple_pg/round.yql b/yql/essentials/tests/sql/suites/simple_pg/round.yql new file mode 100644 index 00000000000..63d54c35470 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/round.yql @@ -0,0 +1 @@ +select SimplePg::round(1.2345, 2), SimplePg::round(1.2345) diff --git a/yql/essentials/tests/sql/suites/simple_pg/to_date.yql b/yql/essentials/tests/sql/suites/simple_pg/to_date.yql new file mode 100644 index 00000000000..f83ee55e82b --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/to_date.yql @@ -0,0 +1 @@ +select SimplePg::to_date('2023-03-01','%Y-%m-%d'); diff --git a/yql/essentials/tests/sql/suites/simple_pg/warn_as_error.cfg b/yql/essentials/tests/sql/suites/simple_pg/warn_as_error.cfg new file mode 100644 index 00000000000..b106572754f --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/warn_as_error.cfg @@ -0,0 +1 @@ +xsqlfail diff --git a/yql/essentials/tests/sql/suites/simple_pg/warn_as_error.yql b/yql/essentials/tests/sql/suites/simple_pg/warn_as_error.yql new file mode 100644 index 00000000000..9ce5475cf20 --- /dev/null +++ b/yql/essentials/tests/sql/suites/simple_pg/warn_as_error.yql @@ -0,0 +1,2 @@ +pragma warning("error","1116"); +select SimplePg::now(); |