[jira] [Commented] (CALCITE-3524) Add support for RexSubQuery creation from RelBuilder

["Julian Hyde (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-3524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16978900#comment-16978900 ] 

Julian Hyde commented on CALCITE-3524:
--------------------------------------

Makes sense.

Before we start changing {{RelBuilder}}, I would like to see some examples in this JIRA case of the code that one would write against {{RelBuilder}} to create the equivalent of IN, EXISTS, SOME, ANY SQL queries, perhaps with correlating variables.

(A previous proposal referenced fields by position, and we we had to re-work it to reference fields as expressions, which is consistent with the rest of {{RelBuilder}}.)

> Add support for RexSubQuery creation from RelBuilder
> ----------------------------------------------------
>
>                 Key: CALCITE-3524
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3524
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: Amir Gajst
>            Assignee: Amir Gajst
>            Priority: Minor
>
> When building relational expressions, the simplest way is by using the RelBuilder which does not currently support creation of a RexSubQuery.
> We can add RexSubQuery creation functions to the RelBuilder to make it more "visible" and convenient to use. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)