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

Library import 241120-1113

1 files changed, 69 insertions, 0 deletions

diff --git a/yql/essentials/tests/s-expressions/suites/Builtins/CompareWithEmptyOptionals.yql b/yql/essentials/tests/s-expressions/suites/Builtins/CompareWithEmptyOptionals.yql
new file mode 100644
index 0000000000..4e7c2ed97f
--- /dev/null
+++ b/yql/essentials/tests/s-expressions/suites/Builtins/CompareWithEmptyOptionals.yql
@@ -0,0 +1,69 @@
+(
+#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 table1map (Map table1 (lambda '(item) (block '(
+   (let value (Member item 'value))
+   (let x (Uint32 '700))
+   (let y (Uint32 '20))
+   (let z (Uint32 '0))
+   (let jx (FromString (Member item 'key) 'Uint32))
+   (let jy (FromString (Member item 'subkey) 'Uint32))
+   (let n (Nothing (OptionalType (DataType 'Uint32))))
+   (let test (lambda '(item) (If (Exists item) (ToString (Coalesce item (Bool 'false))) (String 'NULL))))
+   (let newValue value)
+   (let newValue (Concat newValue (String '" => ")))
+   (let newValue (Concat newValue (String '" < ")))
+   (let newValue (Concat newValue (Concat (String '" ") (ToString (< x y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (< jx y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (< x jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (< jx jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (< jx n)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (< n jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (< x n)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (< n y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (< n n)))))
+   (let newValue (Concat newValue (String '" > ")))
+   (let newValue (Concat newValue (Concat (String '" ") (ToString (> x y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (> jx y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (> x jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (> jx jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (> jx n)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (> n jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (> x n)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (> n y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (> n n)))))
+   (let newValue (Concat newValue (String '" == ")))
+   (let newValue (Concat newValue (Concat (String '" ") (ToString (== x y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (== jx y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (== x jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (== jx jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (== jx n)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (== n jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (== x n)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (== n y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (== n n)))))
+   (let newValue (Concat newValue (String '" != ")))
+   (let newValue (Concat newValue (Concat (String '" ") (ToString (!= x y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (!= jx y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (!= x jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (!= jx jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (!= jx n)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (!= n jy)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (!= x n)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (!= n y)))))
+   (let newValue (Concat newValue (Concat (String '" ") (Apply test (!= 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 '()))
+(let world (Commit! world mr_sink))
+(return world)
+)