union_positional_mix.sql « union « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/union/union_positional_mix.sql

blob: 52302030f479e468c5618593c5c6cb4bd82267e6 (plain) (blame)

PRAGMA PositionalUnionAll;

SELECT
    1 as y, 2 as x
UNION
SELECT
    1 as x, 2 as y
UNION ALL
SELECT
    1 as y, 2 as x;