yql/essentials/tests/sql/suites/union_all/union_all_multiple.sql


1
2
3
4
5
6
7
8
9

SELECT * FROM (
    SELECT CAST(key AS int) as key, '' as subkey, '' as value FROM plato.Input
    UNION ALL
    SELECT 1 as key, subkey, '' as value from plato.Input
    UNION ALL
    SELECT 1 as key, '' as subkey, value from plato.Input
)
ORDER BY key, subkey, value
;