YQL-19206 Move contrib/ydb/library/yql/tests/sql/suites -> yql/essentials/tests/sql/suites

commit_hash:d0ef1f92b09c94db7c2408f946d2a4c62b603f00

1 files changed, 22 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/action/nested_rewrite_io.sql b/yql/essentials/tests/sql/suites/action/nested_rewrite_io.sql
new file mode 100644
index 0000000000..4150bc7e3f
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/action/nested_rewrite_io.sql
@@ -0,0 +1,22 @@
+use plato;
+$input = select * from AS_TABLE([<|a:"foo",b:"123"|>]);
+
+$mapping = select {"a":"String", "b":"Int32"} from Input limit 1;
+
+$transformer = ($type)->{
+    $t = EvaluateType(ParseTypeHandle($type));
+    return ($value)->{ return cast($value as $t); };
+};
+
+$converter = ($row)->{
+   return EvaluateCode(LambdaCode(($rowCode)->{
+       return FuncCode("AsStruct", ListMap(StructMembers($row), ($name)->{
+           return ListCode(
+               AtomCode($name),
+               FuncCode("Apply", QuoteCode($transformer(Unwrap($mapping[$name]))), FuncCode("Member", $rowCode, AtomCode($name)))
+           );
+       }));
+   }))($row);
+};
+
+select * from (select $converter(TableRow()) from $input) flatten columns;