Follow-up to #115281
The current push down optimization, where we transform ... | STATS ... BY field | WHERE field > 10 into WHERE field > 10 | STATS ... BY field (and similarly for more complex filters), does not yet take into account that field could be multivalued. In case it is, the correct push down result is EVAL field = MV_DEDUPE(field) | MV_EXPAND field | WHERE field > 10 | STATS ... BY field.
Let's make our filter push down multi-values aware.
Follow-up to #115281
The current push down optimization, where we transform
... | STATS ... BY field | WHERE field > 10intoWHERE field > 10 | STATS ... BY field(and similarly for more complex filters), does not yet take into account thatfieldcould be multivalued. In case it is, the correct push down result isEVAL field = MV_DEDUPE(field) | MV_EXPAND field | WHERE field > 10 | STATS ... BY field.Let's make our filter push down multi-values aware.