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

Library import 241120-1113

1 files changed, 60 insertions, 0 deletions

diff --git a/yql/essentials/tests/s-expressions/suites/Builtins/OrOverOptional.yql b/yql/essentials/tests/s-expressions/suites/Builtins/OrOverOptional.yql
new file mode 100644
index 0000000000..8a1440b4a0
--- /dev/null
+++ b/yql/essentials/tests/s-expressions/suites/Builtins/OrOverOptional.yql
@@ -0,0 +1,60 @@
+(
+#comment
+(let mr_source (DataSource 'yt 'plato))
+(let x (Read! world mr_source (Key '('table (String 'Input))) '('key 'subkey 'value) '()))
+(let world (Left! x))
+(let table1 (Right! x))
+(let writer (lambda '(x) (MatchType x 'Optional 
+(lambda '(x) (Coalesce (Map x (lambda '(y) (ToString y))) (String 'NULL)))
+(lambda '(x) (ToString x)))))
+(let table1map (Map table1 (lambda '(item) (block '(
+   (let value (Member item 'value))
+   (let t (Bool 'true))
+   (let jt (Just t))
+   (let f (Bool 'false))
+   (let jf (Just f))
+   (let n (Nothing (OptionalType (DataType 'Bool))))
+   (let newValue value)
+
+   (let newValue (Concat newValue (String '" => OR true : ")))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or t t)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or t jt)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or t f)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or t jf)))))         
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or t n)))))
+   (let newValue (Concat newValue (String '" => OR false : ")))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or f t)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or f jt)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or f f)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or f jf)))))         
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or f n)))))          
+   (let newValue (Concat newValue (String '" => OR just true : ")))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jt t)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jt jt)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jt f)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jt jf)))))         
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jt n)))))
+   (let newValue (Concat newValue (String '" => OR just false : ")))   
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jf t)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jf jt)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jf f)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jf jf)))))         
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or jf n)))))                
+   (let newValue (Concat newValue (String '" => OR nothing : ")))      
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or n t)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or n jt)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or n f)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or n jf)))))         
+   (let newValue (Concat newValue (Concat (String '" ") (Apply writer (Or n n)))))                
+   
+   (let s (Struct))
+   (let s (AddMember s 'key (Member item 'key)))
+   (let s (AddMember s 'subkey (Member item 'subkey)))
+   (let s (AddMember s 'value newValue))
+   (return s)
+)))))
+(let mr_sink (DataSink 'yt (quote plato)))
+(let world (Write! world mr_sink (Key '('table (String 'Output))) table1map '('('mode 'append))))
+(let world (Commit! world mr_sink))
+(return world)
+)