In operator is not working for subquery

SQL++
1

The following query is not working
SELECT *
FROM abc p
WHERE ANY item IN p.air
SATISFIES
item.dst in (select raw a.po from port AS a where a.name=“val”)
END

if i give
item.dst in ([“ABC”,“BCD”]) then it is working.

if i run subquery separately
select raw a.airports from airports AS a where a.name=“val”.
I am getting [[“ABC”,“BCD”]]

Please help me on this…

2

Can you copy and paste from your cbq shell. We need to see your query verbatim.

3

It looks like a.po is already ARRAY.

SELECT *
FROM abc p
WHERE ANY item IN p.air
SATISFIES
item.dst in ARRAY_FLATTEN( (select raw a.po from port AS a where a.name="val"),1)
END

OR

SELECT *
FROM abc p
WHERE ANY item IN p.air
SATISFIES
item.dst in (select raw a.po from port AS a where a.name="val")[0]
END