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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

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

$a = (SELECT CAST(Unicode::ToUpper("o"u) AS String) || "utpu");
$b = (SELECT CAST(Unicode::ToUpper("i"u) AS String) || "npu");
$a = $a || CAST(Unicode::ToLower("T"u) AS String);
$b = $b || CAST(Unicode::ToLower("T"u) AS String);
INSERT INTO $a
SELECT
    key as key,
    "" as subkey,
    "value:" || value as value
FROM $b
WHERE key < "100"
ORDER BY key;