aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/yql-6199.sql
blob: bb2decf34d539f879a2222e7c2c2a0f9a9347f41 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
PRAGMA DisableSimpleColumns;
/* postgres can not */

$i = (select 1 as key);

$j1 = (select a2.key,b.key as k from $i as a2 join $i as b on a2.key = b.key);

select a.* from $j1 as a join $i as d on a.k = d.key;

$j2 = (select a.key,b.key as k from $i as a join $i as b on a.key = b.key);

select a.* from $j2 as a join $i as d on a.k = d.key;