[
https://issues.apache.org/jira/browse/CALCITE-6242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18080220#comment-18080220
]
terran2010 commented on CALCITE-6242:
-------------------------------------
Agreed — the issue scope has been broadened to cover validation, conversion,
and execution changes needed for lambda closure support. Will add
SqlConformance.allowLambdaClosure() so that conformances can opt out of closure
support if their target dialect doesn't allow it.Thank you for providing
detailed suggestions. I have updated the code accordingly. [~mbudiu] Could you
please help review the code again
> Enhance lambda closure parsing
> ------------------------------
>
> Key: CALCITE-6242
> URL: https://issues.apache.org/jira/browse/CALCITE-6242
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Hanumath Rao Maduri
> Assignee: terran2010
> Priority: Major
> Labels: pull-request-available
>
> The following query is throwing a "param not found" in calcite whereas the
> same query works fine in apache spark.
> {code:java}
> select *
> from (select array(1, 2, 3) as arr) as t1 inner join
> (select 1 as v) as t2 on "EXISTS"(arr, x -> x = t2.v); {code}
> The following error reported for the above query
> {code:java}
> > java.sql.SQLException: Error while executing SQL "select *
> > from (select array(1, 2, 3) as arr) as t1 inner join
> > (select 1 as v) as t2 on "EXISTS"(arr, x -> x = t2.v)": From line 3,
> > column 54 to line 3, column 57: Param 'T2.V' not found in lambda expression
> > '`X` -> `X` = `T2`.`V`' {code}
> Steps to repro:
> 1. Place the query in lambda.iq
> 2. Run CoreQuidemTest.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
