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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 3.1.0.Final
    • 3.0.0.Final
    • Search
    • None

      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.

              mmatloka Michal Matloka (Inactive)
              mmatloka Michal Matloka (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: