Kamil created JCR-3925:
--------------------------
Summary: JCR_SQL2 returns duplicated rows
Key: JCR-3925
URL: https://issues.apache.org/jira/browse/JCR-3925
Project: Jackrabbit Content Repository
Issue Type: Bug
Reporter: Kamil
In my repository I have created few nodes:
{noformat}
/foo
/bar
/bar/child
/bar/child/grandchild
{noformat}
When I execute following code:
{noformat}
NodeIterator nodes = session.getRootNode().getNodes();
while(nodes.hasNext()){
Node n = nodes.nextNode();
System.out.println(String.format("%s: %s", n.getIdentifier(), n));
}
{noformat}
I get:
{noformat}
deadbeef-cafe-babe-cafe-babecafebabe: node /jcr:system
c0457b0d-2113-4d47-aa7c-d150bc74ce16: node /rep:security
ff67a591-52cb-4d37-b826-772fe6611b7e: node /bar
e2a097b1-62b6-4296-ab91-12b06e600ba3: node /rep:accesscontrol
76dbbae0-3b4d-43fc-b5d5-753792e2256b: node /foo
{noformat}
which is correct. But when I invoke:
{noformat}
QueryManager manager = session.getWorkspace().getQueryManager();
Query query = manager.createQuery("SELECT * FROM [nt:unstructured] AS n WHERE
ISCHILDNODE('/')", Query.JCR_SQL2);
NodeIterator res = query.execute().getNodes();
while (res.hasNext()) {
Node n = res.nextNode();
System.out.println(String.format("%s: %s", n.getIdentifier(), n));
}
{noformat}
Nodes are duplicated!
{noformat}
76dbbae0-3b4d-43fc-b5d5-753792e2256b: node /foo
ff67a591-52cb-4d37-b826-772fe6611b7e: node /bar
ff67a591-52cb-4d37-b826-772fe6611b7e: node /bar
76dbbae0-3b4d-43fc-b5d5-753792e2256b: node /foo
{noformat}
Could you please fix that?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
