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


1
2
3
4
5
6
7
8

/* syntax version 1 */

USE plato;

select key, some(subkey) from (select * from Input where key > "010" and value in []) group by key
union all
select key, some(subkey) from (select * from Input where key > "020" and value in []) group by key
;