Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 39 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/expr/between.sql b/yql/essentials/tests/sql/suites/expr/between.sql
new file mode 100644
index 0000000000..df6af1dc4a
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/expr/between.sql
@@ -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;