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

Library import 241120-1113

1 files changed, 78 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/compute_range/in3.sql b/yql/essentials/tests/sql/suites/compute_range/in3.sql
new file mode 100644
index 0000000000..e1e02cbe7e
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/compute_range/in3.sql
@@ -0,0 +1,78 @@
+/* syntax version 1 */
+/* postgres can not */
+/* dq can not */
+/* dqfile can not */
+/* yt can not */
+pragma warning("disable", "4510");
+pragma warning("disable", "1108");
+
+$Input = [(4, 100), (5, 100)];
+select YQL::RangeComputeFor(
+  Struct<
+    a:Int32?,
+    b:Int32?,
+    c:Int32?,
+    d:Int32?,
+    e:Int32?,
+  >,
+  
+  ($row) -> (((
+              $row.a,
+              $row.d)
+              IN $Input) ?? false),
+  AsTuple(
+    AsAtom("a"),
+    AsAtom("b"),
+    AsAtom("c"),
+    AsAtom("d"),
+  )
+);
+
+$Input2 = [(30, 20, 88), (31, 21, 99)];
+select YQL::RangeComputeFor(
+  Struct<
+    a:Int32?,
+    b:Int32?,
+    c:Int32?,
+    d:Int32?,
+    e:Int32?,
+  >,
+
+  ($row) -> ((((
+              $row.c,
+              $row.b,
+              $row.e)
+              IN $Input2) AND $row.a == 10) ?? false),
+  AsTuple(
+    AsAtom("a"),
+    AsAtom("b"),
+    AsAtom("c"),
+    AsAtom("d"),
+    AsAtom("e"),
+  )
+);
+
+$Input3 = [(20, 10, 30, 99), (21, 10, 31, 88)];
+select YQL::RangeComputeFor(
+  Struct<
+    a:Int32?,
+    b:Int32?,
+    c:Int32?,
+    d:Int32?,
+    e:Int32?,
+  >,
+
+  ($row) -> ((($row.c = 33 AND $row.d = 44 AND (
+              $row.b,
+              $row.a,
+              $row.b,
+              $row.e)
+              IN $Input3)) ?? false),
+  AsTuple(
+    AsAtom("a"),
+    AsAtom("b"),
+    AsAtom("c"),
+    AsAtom("d"),
+    AsAtom("e"),
+  )
+);