Subquery in the FROM clause DOES not handle WHERE clause

[eaudet]

SELECT * FROM ( SELECT subtract(2020, 2019) as sub, vintage as v FROM myindex ) o2 WHERE 2 = 1

returns true all the time

[penghuo]

SELECT * FROM ( SELECT subtract(2020, 2019) as sub, vintage as v FROM myindex ) o2 WHERE 2 = 1

returns true all the time

Hi.
Have u enabled the new engine?
In the new engine, we didn't support substract function, but we have "-" operator supported. then, the following query should work as expected, I tested it.

SELECT * FROM (SELECT 2020 - 2019 as sub FROM kibana_sample_data_logs ) o2 WHERE 2 = 1

[anirudha]

This is enabled by default now