Intermediate changes

commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972

1 files changed, 39 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/expr/between.yql b/yql/essentials/tests/sql/suites/expr/between.yql
new file mode 100644
index 00000000000..df6af1dc4ac
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/expr/between.yql
@@ -0,0 +1,39 @@
+select
+    1 between 2 and 4,
+    3 between 2 and 4,
+    5 between 2 and 4,
+    3 between 4 and 2,
+    5 between 4 and 2,
+    null between 2 and 4,
+    1 between null and 4,
+    1 between 4 and null,
+    1 between 0 and null,
+    1 between null and null,
+    null between null and null;
+
+select
+    1 between asymmetric 2 and 4,
+    3 between asymmetric 2 and 4,
+    5 between asymmetric 2 and 4,
+    3 between asymmetric 4 and 2,
+    5 between asymmetric 4 and 2,
+    null between asymmetric 2 and 4,
+    1 between asymmetric null and 4,
+    1 between asymmetric 4 and null,
+    1 between asymmetric 0 and null,
+    1 between asymmetric null and null,
+    null between asymmetric null and null;
+
+select
+    1 between symmetric 2 and 4,
+    3 between symmetric 2 and 4,
+    5 between symmetric 2 and 4,
+    1 between symmetric 4 and 2,
+    3 between symmetric 4 and 2,
+    5 between symmetric 4 and 2,
+    null between symmetric 2 and 4,
+    1 between symmetric null and 4,
+    1 between symmetric 4 and null,
+    1 between symmetric 0 and null,
+    1 between symmetric null and null,
+    null between symmetric null and null;