[JCR-3219] regression with self-join queries

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Component/s: jackrabbit-jcr-server, query, sql
• Assignee: Unassigned
• Reporter: David Buchmann
• Created: 24/Jan/12 15:22
• Updated: 27/May/12 10:01
• Resolved: 29/Mar/12 17:24

Description

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