You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "David Buchmann (Resolved) (JIRA)" <ji...@apache.org> on 2012/03/29 12:02:27 UTC
[jira] [Resolved] (JCR-3219) regression with self-join queries
[ https://issues.apache.org/jira/browse/JCR-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Buchmann resolved JCR-3219.
---------------------------------
Resolution: Fixed
indeed you are right. sorry for opening a ticket about something that got fixed :-(
i was confused by the semantics of joins in jcr - its not the most obvious operation (and i still don't know what the use case would be of self-joining queries).
> 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