yt/yql/tests/sql/suites/subselect/inline_subquery_named_node_scalar_join.yql


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

/* dqfile can not */
/* hybridfile can not - missing langver support */
USE plato;

$a = (SELECT Max(Input.key || Input2.subkey) FROM Input JOIN Input2 ON Input.subkey = Input2.key);

$b = "1" || (SELECT Max(Input.key || Input2.subkey) FROM Input JOIN Input2 ON Input.subkey = Input2.key);

$c = (SELECT Max(Input.key || Input2.subkey) FROM Input JOIN Input2 ON Input.subkey = Input2.key) || "1";

$d = "1" || (SELECT Max(Input.key || Input2.subkey) FROM Input JOIN Input2 ON Input.subkey = Input2.key) || "1";

SELECT $a, $b, $c, $d;