aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/action/nested_subquery.sql
blob: 375dee111690bd4f3c770ccd4310834642aeca0b (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
/* syntax version 1 */
/* postgres can not */
use plato;

define subquery $q($name) as
    define subquery $nested() as
        select $name;
    end define;

    process $nested();
end define;

process $q(CAST(Unicode::ToUpper("foo"u) AS String));