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

Library import 241120-1113

1 files changed, 18 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/expr/distinct_from_containers.sql b/yql/essentials/tests/sql/suites/expr/distinct_from_containers.sql
new file mode 100644
index 0000000000..622fdddc30
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/expr/distinct_from_containers.sql
@@ -0,0 +1,18 @@
+/* syntax version 1 */
+/* postgres can not */
+
+$vt1 = ParseType("Variant<Int32,Int32?>");
+$vt2 = ParseType("Variant<Int64,Null>");
+
+$svt1 = ParseType("Variant<a:Int32,b:Int32?>");
+$svt2 = ParseType("Variant<a:Int64,b:Null>");
+
+select
+  (1, 2) is not distinct from (1, 2, 1/0),     --true
+  <|a:1/0, b:Nothing(String?), c:1|>  is not distinct from
+  <|c:1u, d:1u/0u, e:Nothing(Utf8?)|>,         --true
+  [1, 2, null] is not distinct from [1, 2, just(1/0)], --false
+  {1:null} is distinct from {1u:2/0},          --false
+  Variant(1/0, "1", $vt1) is distinct from  Variant(null, "1", $vt2), --false
+  Variant(1/0, "b", $svt1) is not distinct from Variant(null, "b", $svt2), --true
+;