[
https://issues.apache.org/jira/browse/JCR-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jukka Zitting resolved JCR-3219.
--------------------------------
Resolution: Duplicate
> regression with self-join queries
> ---------------------------------
>
> Key: JCR-3219
> URL: https://issues.apache.org/jira/browse/JCR-3219
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-jcr-server, query, sql
> Reporter: David Buchmann
> Priority: Minor
> Attachments: JCR-3219-test.patch
>
>
> affects version 2.3.7
> running a query that joins on the same node type against 2.3.6 returns 1
> result, while running it against 2.3.7 returns the same node 3 times. if i
> join two different node types, i get only one result row...
> to reproduce: in my repository, i have 2 unstructured nodes with the same
> jcr:mimeType and one of them having the field zeronumber with value 0.
> QueryManager qm = s.getWorkspace().getQueryManager();
> Query q = qm.createQuery("SELECT data.zeronumber FROM
> [nt:unstructured] AS data INNER JOIN [nt:unstructured] AS second ON
> data.[jcr:mimeType] = second.[jcr:mimeType] WHERE data.zeronumber = 0",
> Query.JCR_JQOM);
> QueryResult r = q.execute();
> RowIterator i = r.getRows();
> while (i.hasNext()) {
> Row n = i.nextRow();
> System.out.println(n.getPath("data"));
> }
> jukka suspects this could be introduced by JCR-3198
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
