XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.2.0
    • 3.2.0
    • SQL
    • None

    Description

      Inline subqueries with OneRowRelation as leaf nodes instead of decorrelating and rewriting them as left outer joins.

      Scalar subquery:
      ```
      SELECT (SELECT c1) FROM t1 -> SELECT c1 FROM t1
      ```

      Lateral subquery:
      ```
      SELECT * FROM t1, LATERAL (SELECT c1, c2) -> SELECT c1, c2 , c1, c2 FROM t1
      ```

      Attachments

        Activity

          People

            allisonwang-db Allison Wang
            allisonwang-db Allison Wang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: