yql/essentials/tests/sql/suites/optimizers/pushdown_nonsep_over_aggregate.sql


1
2
3
4
5
6
7
8
9
10
11
12

USE plato;

pragma config.flags("OptimizerFlags", "PushdownComplexFiltersOverAggregate");

SELECT * FROM (
    SELECT
        key as key,
        min(value) as mv
    FROM Input
    GROUP BY key
)
WHERE AssumeNonStrict(200 > 100) and (2000 > 1000) and key != "911" and (key < "150" and mv != "ddd" or key > "200");