Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 24 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/coalesce/coalesce_few_opt.sql b/yql/essentials/tests/sql/suites/coalesce/coalesce_few_opt.sql
new file mode 100644
index 0000000000..1e2d541f60
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/coalesce/coalesce_few_opt.sql
@@ -0,0 +1,24 @@
+select
+    'first',
+    coalesce(first_null, 22),
+    coalesce(first_num, 33),
+    coalesce(coalesce(first_null, 122), 42),
+    coalesce(coalesce(first_num, 133), 43),
+    coalesce(coalesce(coalesce(first_null, 222), 442), 100500),
+    coalesce(coalesce(coalesce(first_num, 233), 443), 100501),
+    'second',
+    coalesce(second_null, 22),
+    coalesce(second_num, 33),
+    coalesce(coalesce(second_null, 122), 42),
+    coalesce(coalesce(second_num, 133), 43),
+    coalesce(coalesce(coalesce(second_null, 222), 442), 100500),
+    coalesce(coalesce(coalesce(second_num, 233), 443), 100501),
+    'third',
+    coalesce(third_null, 22),
+    coalesce(third_num, 33),
+    coalesce(coalesce(third_null, 122), 42),
+    coalesce(coalesce(third_num, 133), 43),
+    coalesce(coalesce(coalesce(third_null, 222), 442), 100500),
+    coalesce(coalesce(coalesce(third_num, 233), 443), 100501),
+    'end'
+from plato.Input;