Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-816

Represent sub-query as a RexNode

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.6.0
    • None
    • None

    Description

      Represent IN, NOT IN, EXISTS and scalar sub-queries as RexSubQuery extends RexNode. Then we can write a planner rule that expands sub-queries.

      Attachments

        Issue Links

        breaks

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-1055 SubQueryRemoveRule should create Correlate, not Join, for correlated sub-queries

        • Major - Major loss of function.
        • Closed
        is depended upon by

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-1799 "OR ... IN" sub-query conversion is wrong

        • Major - Major loss of function.
        • Closed
        is related to

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-1799 "OR ... IN" sub-query conversion is wrong

        • Major - Major loss of function.
        • Closed
        relates to

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-838 Optimize "join to most recent" queries

        • Major - Major loss of function.
        • Open

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-863 AssertionError while translating query with UNNEST and having two correlation conditions

        • Major - Major loss of function.
        • Open

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-709 LIMIT inside scalar sub-query

        • Major - Major loss of function.
        • In Progress

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-551 Sub-query inside aggregate function

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-842 Decorrelator gets field offsets confused if fields have been trimmed

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-864 Correlation variable has incorrect row type if it is populated by right side of a Join

        • Major - Major loss of function.
        • Closed

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            julianhyde Julian Hyde
            julianhyde Julian Hyde
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment