yql/essentials/tests/sql/suites/compute_range/in_literal_nulls.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

/* syntax version 1 */
/* postgres can not */
/* dq can not */
/* dqfile can not */
/* yt can not */
pragma warning("disable", "4510");
pragma warning("disable", "1108");

select YQL::RangeComputeFor(
  Struct<x:Int32?>,
  ($row) -> (($row.x IN (1,2,5,null)) ?? false),
  AsTuple(AsAtom("x"))
);