Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-559

Outer join can produce wrong result

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 0.7
    • query
    • None

    Description

      Outer join queries of the following form can produce wrong results:

      select * from l left outer join r on l.x = r.x
      

      The reason is that a "property x is not null" restriction is added to the left hand side (the inner selector of the outer join). This is incorrect.

      Attachments

        Issue Links

          Activity

            People

              thomasm Thomas Mueller
              thomasm Thomas Mueller
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: