[ES|QL] TOP(..., 1, ...) ignores WHERE clause

[jan-elastic]

Elasticsearch Version

main

Installed Plugins

No response

Java Version

n/a

OS Version

n/a

Problem Description

The following ES|QL query gives incorrect results:

ROW x = [1,2,3,4] 
  | MV_EXPAND x
  | STATS top1 = TOP(x, 1, "ASC") WHERE x==3,
          top2 = TOP(x, 2, "ASC") WHERE x==3,
          min  = MIN(x) WHERE x==3

The three aggs should give the same result (3), however the results are:

     top1      |     top2      |      min      
---------------+---------------+---------------
1              |3              |3         

Note that:

• top2 is effectively the same as top1 here and correctly works
• top1 has min as surrogate, however something goes wrong there
• min itself is correct

Steps to Reproduce

see above

Logs (if relevant)

No response

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)

[jan-elastic]

I think there's more cases like this (the filter not being propagated to a surrogate), e.g. Median -> Percentile. I don't have time to hunt them all...

[clement-fouque]

I confirm the issue is present on MEDIAN but not on PERCENTILE. I've found a workaround to use PERCENTILE(my_field, 50).

[ivancea]

Fixed in #134461