aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/column_order/join_nosimple.sql
blob: 8784238898acae59d3f5bd8739ee964e58d9804c (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
/* postgres can not */
/* syntax version 1 */
use plato;
pragma OrderedColumns;
pragma DisableSimpleColumns;

$foo = select 1 as sk, "150" as key, 2 as v;

select * from $foo as b join Input as a using(key);
select a.* from $foo as b join Input as a using(key);
select b.* from $foo as b join Input as a using(key);
select a.*, b.* from $foo as b join Input as a using(key);