Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2422

Support JCR-SQL2 correlated subqueries

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Rejected
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      MODE-869 added support for JCR-SQL2 subqueries, but requires that they be non-correlated. It would be extremely helpful if that wasn't the case. Take the following as an example:

      SELECT artifact1.* FROM [sramp:baseArtifactType] AS artifact1 
      WHERE artifact1.[sramp:artifactType] = 'Part' AND 'element' 
      NOT IN (
        SELECT relationship2.[sramp:relationshipType] 
        FROM [sramp:relationship] AS relationship2 
        WHERE ISCHILDNODE(relationship2,artifact1)
      )
      

      Since I can't correlate the subquery's artifact1 with the parent query's selector, I'm not sure how else to accomplish something like that (other than in-memory).

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  brmeyer Brett Meyer
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: