aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/binding/compact_named_with_subq_contexts.sql
blob: 0da0d7dd9730f2414bfcc57fc254bd305ce2a2a7 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
/* yt can not */
pragma CompactNamedExprs;

$a = (SELECT CAST(Unicode::ToUpper("o"u) AS String) || "utpu");
$b = $a || CAST(Unicode::ToLower("T"u) AS String);
select $b;
select $a || CAST(Unicode::ToLower("T"u) AS String);
select * from $a;
select "Outpu" in $a;

define subquery $sub() as
  select * from $a;
end define;

select * from $sub();