aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/epochs/use_and_drop_anonymous.sql
blob: ee5c907dc9b5fe9b96e282daddf4a419a4456cf4 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
/* postgres can not */
/* multirun can not */
use plato;

insert into @tmp select * from Input where key > "100";
commit;

insert into Output
select * from @tmp where key != "150";

drop table @tmp;
commit;

insert into @tmp select * from Input where key > "200";
commit;

insert into Output
select * from @tmp where key != "150";

drop table @tmp;
commit;