yql/essentials/tests/sql/suites/hor_join/runtime_dep.sql


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

/* postgres can not */
use plato;

INSERT INTO @ttt WITH TRUNCATE
SELECT CAST(key AS int) as key, subkey, value FROM Input;

COMMIT;

SELECT * FROM (
    SELECT key, '' as value FROM @ttt
    UNION ALL
    SELECT 0 as key, value from @ttt
) AS x
ORDER BY key, value
;