jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jukka Zitting <jzitt...@adobe.com>
Subject RE: Left outer joins in SQL2
Date Tue, 29 Mar 2011 13:47:00 GMT

Manfred Sattler wrote:
> I think that left outer joins in SQL2 are not working korrect.

The behavior you describe is how a left outer join is supposed to work. From Wikipedia [1]:

    The result of a left outer join (or simply left join) for table A and B
    always contains all records of the "left" table (A), even if the
    join-condition does not find any matching record in the "right" table (B).

The JSR 283 spec describes the same thing in a much more cryptic way in section 6.7.5 [2].

[1] http://en.wikipedia.org/wiki/Join_(SQL)#Left_outer_join
[2] http://www.day.com/specs/jcr/2.0/6_Query.html#6.7.5+Join

Jukka Zitting
View raw message