yql/essentials/tests/sql/suites/insert/anonymous_tables.sql


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

/* postgres can not */
use plato;
pragma yt.MapJoinLimit="1M";

insert into @a
select * from Input;

commit;

select count(*) from @a;
select * from @a limit 2;
select count(*) from @a as a cross join @a as b;

commit;