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

Union of JOIN and non-JOIN query does not work

    XMLWordPrintable

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.

      Attachments

        Issue Links

          relates to

          Bug - A problem that impairs or prevents the functions of the product. MODE-2054 Invalid query results for sql with outer join and OR join criteria

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: