Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 17 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/coalesce/coalesce_few_real.sql b/yql/essentials/tests/sql/suites/coalesce/coalesce_few_real.sql
new file mode 100644
index 0000000000..0eebc69cc2
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/coalesce/coalesce_few_real.sql
@@ -0,0 +1,17 @@
+/* postgres can not */
+$optDuoFloat=Just(Just(cast(2.71 as float)));
+$optDuoDouble=Just(Just(cast(3.14 as double)));
+$optDuoFloatN=Just(Just(cast(null as float)));
+$optDuoDoubleN=Just(Just(cast(null as double)));
+
+select
+  ($optDuoFloat ?? 0) ?? 1,
+  ($optDuoDouble ?? 41) ?? 42,
+  ($optDuoFloatN ?? 0) ?? 1.,
+  ($optDuoDoubleN ?? 41.) ?? 42,
+  ($optDuoFloatN ?? cast(40.1 as float)) ?? cast(40.2 as float),
+  ($optDuoDoubleN ?? cast(40.1 as float)) ?? cast(40.2 as float),
+  (($optDuoFloatN ?? 0) ?? 1.) ?? 3,
+  (($optDuoDoubleN ?? 41) ?? 42) ?? 4,
+  'end'
+from plato.Input;