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.
