summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests
diff options
context:
space:
mode:
authorYDBot <[email protected]>2025-10-23 18:38:13 +0000
committerYDBot <[email protected]>2025-10-23 18:38:13 +0000
commit564cf7cb2255a107b4f44c18b2a1844041f20b4d (patch)
tree6a4a60e8bde612dcc3ac7fd93fffbd36351d4e35 /yql/essentials/tests
parent89a17b25091c24744b7ebd0650b5b810457b1145 (diff)
parenta703d86902fd02bd8e373d959b2498c034657449 (diff)
Merge pull request #27203 from ydb-platform/merge-rightlib-251021-0051HEADmain
Diffstat (limited to 'yql/essentials/tests')
-rw-r--r--yql/essentials/tests/common/test_framework/yql_utils.py7
-rw-r--r--yql/essentials/tests/sql/minirun/part1/canondata/result.json14
-rw-r--r--yql/essentials/tests/sql/minirun/part4/canondata/result.json17
-rw-r--r--yql/essentials/tests/sql/minirun/part4/canondata/test.test_simple_pg-to_date-default.txt-Results_/extracted5
-rw-r--r--yql/essentials/tests/sql/minirun/part5/canondata/result.json17
-rw-r--r--yql/essentials/tests/sql/minirun/part5/canondata/test.test_simple_pg-now-default.txt-Results_/extracted5
-rw-r--r--yql/essentials/tests/sql/minirun/part6/canondata/result.json46
-rw-r--r--yql/essentials/tests/sql/minirun/part6/canondata/test.test_simple_pg-pragma-default.txt-Results_/extracted5
-rw-r--r--yql/essentials/tests/sql/minirun/part6/canondata/test.test_simple_pg-round-default.txt-Results_/extracted8
-rw-r--r--yql/essentials/tests/sql/sql2yql/canondata/result.json101
-rw-r--r--yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_expr-concat_many_/formatted.sql8
-rw-r--r--yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_linear-types_/formatted.sql2
-rw-r--r--yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-now_/formatted.sql3
-rw-r--r--yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-pragma_/formatted.sql5
-rw-r--r--yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-round_/formatted.sql4
-rw-r--r--yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_simple_pg-to_date_/formatted.sql3
-rw-r--r--yql/essentials/tests/sql/suites/expr/concat_many.cfg2
-rw-r--r--yql/essentials/tests/sql/suites/expr/concat_many.yql5
-rw-r--r--yql/essentials/tests/sql/suites/linear/types.yql4
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/default.cfg1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/no_prefix.cfg1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/no_prefix.yql1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/now.yql1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/pg_only_agg.cfg1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/pg_only_agg.yql1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/pg_only_normal.cfg1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/pg_only_normal.yql1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/pragma.yql2
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/pragma_off.cfg1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/pragma_off.yql7
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/round.yql1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/to_date.yql1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/warn_as_error.cfg1
-rw-r--r--yql/essentials/tests/sql/suites/simple_pg/warn_as_error.yql2
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();