ydb/yql/essentials/tests/s-expressions/suites/Optimizers/CoalesceOverNothing.yqls

(
(let config (DataSource 'config))

(let res_sink (DataSink 'result))
(let data (Coalesce (Nothing (OptionalType (DataType 'Int32))) (Int32 '2)))
(let world (Write! world res_sink (Key) data '('('type))))
(let data (Coalesce (Nothing (OptionalType (DataType 'Int32))) (Just (Int32 '2))))
(let world (Write! world res_sink (Key) data '('('type))))
(let data (Coalesce (Nothing (OptionalType (DataType 'Int32))) (Just (Int32 '2)) (Int32 '3)))
(let world (Write! world res_sink (Key) data '('('type))))
(let world (Commit! world res_sink))
(return world)
)