path: root/yql/essentials/tests/sql/suites/join/full_equal_not_null.sql

PRAGMA DisableSimpleColumns;
select count(*) from (select cast(subkey as int) as v1, subkey from plato.Input1) as a full join (select cast(subkey as int) as v2, subkey from plato.Input1) as b on a.v1 = b.v2;