yt/yql/tests/sql/suites/optimizers/sorted_sql_in.yql


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

use plato;

$ou = select * from Input;

$a = select * from $ou where key > '0';

insert into @a
select * from $a order by key;

select * from $ou
where subkey > "0"
    and key not in compact (select key from $a)
order by key;