jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manfred Sattler (JIRA)" <j...@apache.org>
Subject [jira] [Created] (JCR-2933) SQL2 Left Outer Join
Date Tue, 29 Mar 2011 09:33:05 GMT
SQL2 Left Outer Join
--------------------

                 Key: JCR-2933
                 URL: https://issues.apache.org/jira/browse/JCR-2933
             Project: Jackrabbit Content Repository
          Issue Type: Bug
          Components: jackrabbit-core
    Affects Versions: 2.2.4
            Reporter: Manfred Sattler


Create this nodes.
def n1 = root.addNode("node1", "sling:SamplePage");
n1.setProperty("n1prop1", "page1");
def n2 = n1.addNode("node2", "sling:SampleContent");
n2.setProperty("n2prop1", "content1");

Execute this Query:
Select * from [sling:SamplePage] as page left outer join [sling:SampleContent] as content
on ISDESCENDANTNODE(content,page) where page.n1prop1 = 'page1' and content.n2prop1 = 'content1';
The resultset have 1 row with 2 Nodes. This OK.

Then execute this:
Select * from [sling:SamplePage] as page left outer join [sling:SampleContent] as content
on ISDESCENDANTNODE(content,page) where page.n1prop1 = 'page1' and content.n2prop1 = 'XXXXX';

The resultset has 1 row with 1 node.
This wrong. The result should be 0 rows.

Old Versions, prior 2.2.2 have also 0 rows as result.

Also, if nodes "n2" not exists, jackrabbit reports 1 row as result.



--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message