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

Union of JOIN and non-JOIN query does not work

XMLWordPrintable

      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.

              rhauch Randall Hauch (Inactive)
              rhauch Randall Hauch (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: