YQL-20125 fix

commit_hash:f51c77dc72df30e1a870e784f99b1e8148e6cedb

4 files changed, 113 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/minirun/part1/canondata/result.json b/yql/essentials/tests/sql/minirun/part1/canondata/result.json
index 9f2a2db3d9b..404d7a82754 100644
--- a/yql/essentials/tests/sql/minirun/part1/canondata/result.json
+++ b/yql/essentials/tests/sql/minirun/part1/canondata/result.json
@@ -27,6 +27,20 @@
             "uri": "https://{canondata_backend}/1925821/e00f3e167890c5f5da97383429fa618c17c22f4b/resource.tar.gz#test.test_action-eval_capture--Results_/results.txt"
         }
     ],
+    "test.test[action-eval_data_types-default.txt-Debug]": [
+        {
+            "checksum": "89cee049de9ec7e6dd7b5a34f045dbe9",
+            "size": 944,
+            "uri": "https://{canondata_backend}/1777230/282d0efe193f0dc3b595b6d46dc07dba9352e2c1/resource.tar.gz#test.test_action-eval_data_types-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[action-eval_data_types-default.txt-Results]": [
+        {
+            "checksum": "3ce884c5cc0ae740b88b8798df6f7e3f",
+            "size": 8779,
+            "uri": "https://{canondata_backend}/1777230/282d0efe193f0dc3b595b6d46dc07dba9352e2c1/resource.tar.gz#test.test_action-eval_data_types-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[action-eval_python3_ann--Debug]": [
         {
             "checksum": "9519ba94e008fb057a6f9595f31626fa",
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/result.json b/yql/essentials/tests/sql/sql2yql/canondata/result.json
index e27799d5760..3181fd5b022 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/result.json
+++ b/yql/essentials/tests/sql/sql2yql/canondata/result.json
@@ -69,6 +69,13 @@
             "uri": "https://{canondata_backend}/1942173/99e88108149e222741552e7e6cddef041d6a2846/resource.tar.gz#test_sql2yql.test_action-eval_code_nested_/sql.yql"
         }
     ],
+    "test_sql2yql.test[action-eval_data_types]": [
+        {
+            "checksum": "be08d1fb0d6c1ec3e5299a443071ce91",
+            "size": 2119,
+            "uri": "https://{canondata_backend}/1916746/0727f8fb9611a7ea7b5b75eb4664803ea9a5befc/resource.tar.gz#test_sql2yql.test_action-eval_data_types_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[action-eval_ensuretype]": [
         {
             "checksum": "dd05b150de64ded2710848246e75356f",
@@ -7868,6 +7875,11 @@
             "uri": "file://test_sql_format.test_action-eval_code_nested_/formatted.sql"
         }
     ],
+    "test_sql_format.test[action-eval_data_types]": [
+        {
+            "uri": "file://test_sql_format.test_action-eval_data_types_/formatted.sql"
+        }
+    ],
     "test_sql_format.test[action-eval_ensuretype]": [
         {
             "uri": "file://test_sql_format.test_action-eval_ensuretype_/formatted.sql"
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_action-eval_data_types_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_action-eval_data_types_/formatted.sql
new file mode 100644
index 00000000000..bc1747302d8
--- /dev/null
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_action-eval_data_types_/formatted.sql
@@ -0,0 +1,48 @@
+$data = (
+    TRUE,
+    1t,
+    2ut,
+    3s,
+    4us,
+    5,
+    6u,
+    7l,
+    8ul,
+    9.0,
+    10.0f,
+    Decimal('11.3', 5, 2),
+    '\xff\xff',
+    "bar"u,
+    "{a=1}"y,
+    "[1,2,3]"j,
+    Date('2020-01-01'),
+    Datetime('2020-01-01T01:02:03Z'),
+    Timestamp('2020-01-01T01:02:03.456789Z'),
+    TzDate('2020-01-01,Europe/Moscow'),
+    TzDatetime('2020-01-01T01:02:03,Europe/Moscow'),
+    TzTimestamp('2020-01-01T01:02:03.456789,Europe/Moscow'),
+    Interval('P1D'),
+    Date32('2020-01-01'),
+    Datetime64('2020-01-01T01:02:03Z'),
+    Timestamp64('2020-01-01T01:02:03.456789Z'),
+    TzDate32('2020-01-01,Europe/Moscow'),
+    TzDatetime64('2020-01-01T01:02:03,Europe/Moscow'),
+    TzTimestamp64('2020-01-01T01:02:03.456789,Europe/Moscow'),
+    Interval64('P1D'),
+    DyNumber('12.4'),
+    JsonDocument('[1,2,3]')
+);
+
+$tc = TupleTypeComponents(TypeHandle(TypeOf($data)));
+
+SELECT
+    EvaluateCode(
+        ListCode(
+            ListMap(
+                ListEnumerate($tc), ($x) -> {
+                    RETURN FuncCode('Nth', ReprCode($data), AtomCode(CAST($x.0 AS String)));
+                }
+            )
+        )
+    )
+;
diff --git a/yql/essentials/tests/sql/suites/action/eval_data_types.sql b/yql/essentials/tests/sql/suites/action/eval_data_types.sql
new file mode 100644
index 00000000000..dc9fc829399
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/action/eval_data_types.sql
@@ -0,0 +1,39 @@
+$data = (
+    true,
+    1t,
+    2ut,
+    3s,
+    4us,
+    5,
+    6u,
+    7l,
+    8ul,
+    9.0,
+    10.0f,
+    Decimal("11.3",5,2),
+    "\xff\xff",
+    "bar"u,
+    "{a=1}"y,
+    "[1,2,3]"j,
+    Date('2020-01-01'),
+    Datetime('2020-01-01T01:02:03Z'),
+    Timestamp('2020-01-01T01:02:03.456789Z'),
+    TzDate('2020-01-01,Europe/Moscow'),
+    TzDatetime('2020-01-01T01:02:03,Europe/Moscow'),
+    TzTimestamp('2020-01-01T01:02:03.456789,Europe/Moscow'),
+    Interval('P1D'),
+    Date32('2020-01-01'),
+    Datetime64('2020-01-01T01:02:03Z'),
+    Timestamp64('2020-01-01T01:02:03.456789Z'),
+    TzDate32('2020-01-01,Europe/Moscow'),
+    TzDatetime64('2020-01-01T01:02:03,Europe/Moscow'),
+    TzTimestamp64('2020-01-01T01:02:03.456789,Europe/Moscow'),
+    Interval64('P1D'),
+    DyNumber('12.4'),
+    JsonDocument('[1,2,3]')
+);
+$tc = TupleTypeComponents(TypeHandle(TypeOf($data)));
+
+select EvaluateCode(ListCode(ListMap(ListEnumerate($tc),($x)->{
+    return FuncCode("Nth",ReprCode($data),AtomCode(cast($x.0 as String)));
+})));