yql/essentials/tests/sql/suites/simple_columns/simple_columns_tablerow.sql


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

/* syntax version 1 */
PRAGMA SimpleColumns;

SELECT 100500 as magic, TableRow() AS tr FROM plato.Input AS t;
SELECT 100500 as magic, t.*              FROM plato.Input AS t;

SELECT
TableRow() AS tr
FROM (SELECT Just(1ul) AS k, 1 AS v1) AS a
JOIN (SELECT 1         AS k, 2 AS v2) AS b
ON a.k = b.k;

SELECT
*
FROM (SELECT Just(1ul) AS k, 1 AS v1) AS a
JOIN (SELECT 1         AS k, 2 AS v2) AS b
ON a.k = b.k;