yt/yql/tests/sql/suites/action/dep_world_quote_code.yql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

/* syntax version 1 */
/* postgres can not */
use plato;

$combineQueries = ($query, $list) -> {
    RETURN EvaluateCode(LambdaCode(($world) -> {
        $queries = ListMap($list, ($arg) -> {
                RETURN FuncCode("Apply", QuoteCode($query), $world, ReprCode($arg))
            });

        RETURN FuncCode("Extend", $queries);
    }));
};

DEFINE ACTION $aaa($z) as 

$k = (select count(*) from $z);

DEFINE SUBQUERY $sub($n) AS
   SELECT $n + $k FROM $z;
END DEFINE;

$fullQuery = $combineQueries($sub, ListFromRange(0, 10));
SELECT * FROM $fullQuery();

END DEFINE;

EVALUATE FOR $z IN AsList("Input") 
    DO $aaa($z);
 
DO $aaa("Input");