ÓscarHernández
New Contributor II

‎04-23-2025 10:54 PM

I have tried to simplify the query as much as possible to see if that helps but the bug still persists. The problem should be something with the way Databricks treats columns passed as arguments for a function.

I tried these queries:

select * FROM VALUES (183915595, 231504) AS A (column1, column2)
LEFT JOIN lateral myfunction(A.column1, A.column2) FIP ON TRUE;
 
SELECT B.*, A.*
FROM VALUES (183915595, 231504) AS A (column1, column2)
CROSS JOIN LATERAL (
    SELECT *
    FROM myfunction(A.column1, A.column2)
) AS B;
 
Has anyone else had problems when using tabular functions with columns passed as arguments?
Thanks in advance! 
0 Kudos