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

commit_hash:d0ef1f92b09c94db7c2408f946d2a4c62b603f00

1 files changed, 37 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/blocks/coalesce_complex.sql b/yql/essentials/tests/sql/suites/blocks/coalesce_complex.sql
new file mode 100644
index 0000000000..576394292f
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/blocks/coalesce_complex.sql
@@ -0,0 +1,37 @@
+USE plato;
+
+$strings = [
+   <|key:Just(Just("foo")),      subkey:Just("bar"),      value:1|>,
+   <|key:Just(Nothing(String?)), subkey:Just("two"),      value:2|>,
+   <|key:Nothing(String??),      subkey:Just("three"),    value:3|>,
+   <|key:Nothing(String??),      subkey:Nothing(String?), value:4|>,
+];
+
+$tuples = [
+   <|key:Just(Just(AsTuple(1, 2))),       subkey:Just(AsTuple(3, 4)),       value:1|>,
+   <|key:Just(Nothing(Tuple<Int, Int>?)), subkey:Just(AsTuple(4, 5)),       value:2|>,
+   <|key:Nothing(Tuple<Int, Int>??),      subkey:Just(AsTuple(5, 6)),       value:3|>,
+   <|key:Nothing(Tuple<Int, Int>??),      subkey:Nothing(Tuple<Int, Int>?), value:4|>,
+];
+
+insert into @strings
+select * from as_table($strings);
+
+insert into @tuples
+select * from as_table($tuples);
+
+commit;
+
+select
+   value,
+   key ?? subkey,
+   subkey ?? "xxx",
+from @strings
+order by value;
+
+select
+   value,
+   key ?? subkey,
+   subkey ?? AsTuple(100, 500),
+from @tuples
+order by value;