YQL-19206 Move contrib/ydb/library/yql/tests/sql/suites -> yql/essentials/tests/sql/suites

commit_hash:d0ef1f92b09c94db7c2408f946d2a4c62b603f00

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;