Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
Description
Calcite has a default threshold of 20 for the number of values in an IN clause. If this threshold is reached, then Calcite transforms the IN clause into an inline table + sub-query which is not handled by SolrFilter, so that filter clause gets dropped from the resulting query to Solr, see:
The easiest solution is to update the config.withInSubQueryThreshold(Integer.MAX_VALUE)
I think we should also explore how to work with the sub-query against the inline table if possible.