jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin Papez (JIRA)" <j...@apache.org>
Subject [jira] Created: (JCR-2391) SQL-2 child axis in order by clause does not work
Date Thu, 12 Nov 2009 14:55:39 GMT
SQL-2 child axis in order by clause does not work
-------------------------------------------------

                 Key: JCR-2391
                 URL: https://issues.apache.org/jira/browse/JCR-2391
             Project: Jackrabbit Content Repository
          Issue Type: Bug
          Components: JCR 2.0, query, sql
    Affects Versions: 2.0-beta1
            Reporter: Benjamin Papez


My wanted query is like this, which seems to be a valid query from specification point of
view:

select press.* from [web_templates:pressContainer] as press 
  inner join [jnt:translation] as translation on ischildnode(translation, press) 
  where contains(press.*, '${searchTerm}') or contains(translation.*, '${searchTerm}') 
  order by translation.[jcr:title_en] desc

unfortunately it does not work, because it looks like SimpleScoreDocComparator is looking
in Lucene documents representing pressContainer and not translation (child node).

Perhaps a patch could check in the JoinQuery for the child node join condition and internally
when creating the lucene orderings create the relative path if
the ordering is on the child node - so that RelPathScoreDocComparator would be used. 

It should also work for other join constraints than ischildnode.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message