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

commit_hash:d0ef1f92b09c94db7c2408f946d2a4c62b603f00

1 files changed, 20 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/expr/static_zip.sql b/yql/essentials/tests/sql/suites/expr/static_zip.sql
new file mode 100644
index 0000000000..8cbb9856e6
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/expr/static_zip.sql
@@ -0,0 +1,20 @@
+/* postgres can not */
+/* syntax version 1 */
+
+$s1 = AsStruct(1 as k1, "2" as k2, ["3", "4"] as k3);
+$s2 = AsStruct("10" as k1, [20, 30] as k2, 40 as k3);
+$s3 = AsStruct([100, 200] as k1, 300 as k2, "400" as k3);
+
+
+$t1 = AsTuple(1, "2", ["3", "4"]);
+$t2 = AsTuple("10", [20, 30], 40);
+$t3 = AsTuple([100, 200], 300, "400");
+
+SELECT
+    StaticZip($s1, $s2, $s3) as structs,
+    StaticZip($t1, $t2, $t3) as tuples,
+    StaticZip(AsStruct(), AsStruct()) as empty_structs,
+    StaticZip(AsTuple(), AsTuple()) as empty_tuples,
+    StaticZip($s1) as single_struct,
+    StaticZip($t1) as single_tuple,
+;