yql/essentials/tests/sql/suites/optimizers/yql-15210_sqlin.sql


1
2
3
4
5
6
7
8
9
10

/* postgres can not */
USE plato;

$max = select max(key) from Input;
$list = select key from Input where subkey > "1";

select * from (
    select if(key = $max, "max", key) as key, value from Input
)
where key in compact $list