yql-10038.sql 290 B

123456789101112131415161718
  1. /* postgres can not */
  2. use plato;
  3. insert into @input
  4. select "foo" as reqid, "touch" as ui, AsList(1,2,236273) as test_ids;
  5. commit;
  6. $dict = (select "foo" as reqid);
  7. select
  8. *
  9. from
  10. @input
  11. where
  12. ui='touch' and
  13. reqid in (select reqid from $dict)
  14. and 236273 in test_ids