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

Union of JOIN and non-JOIN query does not work

    Details

      Description

      The following query (workaround for MODE-2054) does not work:

      SELECT p.[jcr:path] FROM [test:parent] AS p
      WHERE CONTAINS(p.*, 'name2')
      UNION
      SELECT p.[jcr:path] FROM [test:parent] AS p JOIN [test:Child] AS c ON ISCHILDNODE(c,p)
      WHERE CONTAINS(c.*, 'name2')
      

      and results in either an exception (like IndexOutOfBoundsException) or the incorrect values being placed into the result set.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  rhauch Randall Hauch
                  Reporter:
                  rhauch Randall Hauch
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: