Intermediate changes

commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972

1 files changed, 63 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/expr/variant_struct_comp.yql b/yql/essentials/tests/sql/suites/expr/variant_struct_comp.yql
new file mode 100644
index 00000000000..f7eb33dc848
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/expr/variant_struct_comp.yql
@@ -0,0 +1,63 @@
+/* postgres can not */
+$id = ($x)->{
+    $f = Yql::Callable(CallableType(0, TypeOf($x)), ()->{return $x});
+    return $f();
+};
+
+$vt1 = ParseType("Variant<a:Int32,b:Uint32?>");
+$vt2 = ParseType("Variant<b:Int64,c:Uint32>");
+
+select AsTuple(
+    Variant(1,"a",$vt1) == Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) == Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) == Variant($id(2u),"b",$vt2),
+    Variant(1,"b",$vt1) == Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) == Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) == Variant($id(1u),"b",$vt2)
+);
+
+select AsTuple(
+    Variant(1,"a",$vt1) != Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) != Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) != Variant($id(2u),"b",$vt2),
+    Variant(1,"b",$vt1) != Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) != Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) != Variant($id(1u),"b",$vt2)
+);
+
+select AsTuple(
+    Variant(1,"a",$vt1) < Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) < Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) < Variant($id(2u),"b",$vt2),
+    Variant(1,"b",$vt1) < Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) < Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) < Variant($id(1u),"b",$vt2)
+);
+
+select AsTuple(
+    Variant(1,"a",$vt1) <= Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) <= Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) <= Variant($id(2u),"b",$vt2),
+    Variant(1,"b",$vt1) <= Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) <= Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) <= Variant($id(1u),"b",$vt2)
+);
+
+select AsTuple(
+    Variant(1,"a",$vt1) > Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) > Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) > Variant($id(2u),"b",$vt2),
+    Variant(1,"b",$vt1) > Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) > Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) > Variant($id(1u),"b",$vt2)
+);
+
+select AsTuple(
+    Variant(1,"a",$vt1) >= Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) >= Variant($id(1u),"b",$vt2),
+    Variant(1,"b",$vt1) >= Variant($id(2u),"b",$vt2),
+    Variant(1,"b",$vt1) >= Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) >= Variant($id(1u),"c",$vt2),
+    Variant(1u/0u,"b",$vt1) >= Variant($id(1u),"b",$vt2)
+);
+