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

Library import 241120-1113

1 files changed, 29 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/optimizers/total_order.sql b/yql/essentials/tests/sql/suites/optimizers/total_order.sql
new file mode 100644
index 0000000000..c9b185a101
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/optimizers/total_order.sql
@@ -0,0 +1,29 @@
+/* postgres can not */
+$x = AsTuple(Double("nan"),42);
+
+select $x = $x;
+select $x < $x;
+select $x <= $x;
+select $x > $x;
+select $x >= $x;
+select $x != $x;
+
+$x = AsStruct(Double("nan") as a,42 as b);
+select $x = $x;
+select $x != $x;
+
+$x = AsTuple(Nothing(ParseType("Int32?")), 1);
+select $x = $x;
+select $x < $x;
+select $x <= $x;
+select $x > $x;
+select $x >= $x;
+select $x != $x;
+
+$x = Nothing(ParseType("Int32?"));
+select $x = $x;
+select $x < $x;
+select $x <= $x;
+select $x > $x;
+select $x >= $x;
+select $x != $x;