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


1
2
3
4
5
6
7

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