N1QL "IN" query seems to have finite limit

Hello,

Yes. This is a heuristic in the planner. The reason is that IN is converted to OR, and OR can be combined with other logic to produce very complex planner combinations, so OR is heuristically bounded.

You can work around this using UNION ALL: put about 10 or 12 keys in each subquery, and then combine the subqueries using UNION ALL.