yql/essentials/tests/sql/suites/select/dot_name_subrequest.sql


1
2
3
4
5
6
7
8

/* postgres can not */
USE plato;
PRAGMA DisableSimpleColumns;

$req = (SELECT 100500 as magic, t.* FROM Input as t);

--INSERT INTO Output
SELECT `t.subkey` as sk, `t.value` as val FROM $req ORDER BY sk