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

FullTextSearch Left/Right outer join invalid behaviour on null join value

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 3.0.0.Final
    • Fix Version/s: 3.1.0.Final
    • Component/s: Search
    • Labels:
      None

      Description

      1. Defined types
      Typ A
      property name
      property reference 'ref'

      Type B
      property name
      property reference 'ref'

      2. Value in repository

      type a, name 'something' , ref =empty (null)

      3. Query:

      SELECT a.* FROM [a] LEFT OUTER JOIN [b] ON a.[ref] = b.[jcr:uuid]

      4. Result of query = empty, should be contained element

      In source code:
      NestedLoopJoinComponent class in case LEFT_OUTER/RIGH_OUTER:

      Object leftValue = leftSelector.evaluate(leftTuple);
           if (leftValue == null) {
                  continue;
           }
      

      leftValue is null - because my ref is empty. continue is executed so nothing added to results.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  mmatloka Michal Matloka
                  Reporter:
                  mmatloka Michal Matloka
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: