Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0, 4.0.0
    • Fix Version/s: 4.3.0, 3.3.0
    • Labels:
      None

      Description

      1. Semi/anti joins: including "IN / NOT IN" tests operating on non-correlated sub-queries (PHOENIX-167).
      We can evaluate the sub-queries as sets and execute the outer query the same way as we now do IN clause.

      2. Other non-correlated sub-queries: having a comparison operator with no modifier or a comparison operator modified by ANY, SOME or ALL (PHOENIX-1168).
      a) The sub-query can/must be evaluated as a single value. (Like "= / !=" with no modifiers; Or in cases like "> / < / >= / <=" "ANY/SOME/ALL", either max() or min() can be applied to the sub-query).
      b) In cases like "= / !=" "ANY / SOME / ALL", they are equivalent to category 2 queries.

      3. General correlated sub-queries (PHOENIX-945):
      Need more sophisticated rewriting techniques to convert them into joins.

        • if none of the dependence of inner query on the outer query is equi condition, we are currently unable to handle them.

      4. Nested sub-queries: having sub-queries in the FROM clause.
      We are now able to handle most of them. Exceptions are PHOENIX-943, PHOENIX-944.

        Activity

        Hide
        enis Enis Soztutar added a comment -

        Bulk close of all issues that has been resolved in a released version.

        Show
        enis Enis Soztutar added a comment - Bulk close of all issues that has been resolved in a released version.

          People

          • Assignee:
            maryannxue Maryann Xue
            Reporter:
            maryannxue Maryann Xue
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 3,144h
              3,144h
              Remaining:
              Remaining Estimate - 3,144h
              3,144h
              Logged:
              Time Spent - Not Specified
              Not Specified

                Development