ydb/yql/essentials/tests/sql/suites/compute_range/in3.sql

/* 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"),
  )
);