yql/essentials/tests/sql/suites/in/yql-10038.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

/* postgres can not */
use plato;

insert into @input
select "foo" as reqid, "touch" as ui, AsList(1,2,236273) as test_ids;
commit;

$dict = (select "foo" as reqid);

select
    *
from 
   @input
where 
    ui='touch' and 
    reqid in (select reqid from $dict)
    and 236273 in test_ids