Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1167 Improve join capabilities
  3. PHOENIX-1332

Support correlated subqueries in comparison with ANY/SOME/ALL

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0, 4.0.0
    • 4.2.0, 3.2.0
    • None
    • None

    Description

      Support grammar like:

      select * from OrderTable o where quantity >= ALL(select quantity from OrderTable where item_id = o.item_id)

      Attachments

        1. 1332.patch
          48 kB
          Wei Xue

        Activity

          People

            maryannxue Wei Xue
            maryannxue Wei Xue
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: