yql/essentials/tests/sql/suites/join/join_key_cmp_udf.sql


1
2
3
4
5
6
7
8
9
10
11

PRAGMA DisableSimpleColumns;
/* postgres can not */
USE plato;

--INSERT INTO Output
SELECT
    ib.*
FROM Input as ia
JOIN Input as ib
ON Unicode::ToUpper(CAST(ia.key AS Utf8)) == ib.subkey
ORDER BY ib.key, ib.subkey