Hi, On Wed, Oct 21, 2009 at 10:01, Benjamin Papez <[email protected]> wrote: > Hello, > > I am using Jackrabbit 2.0 alpha10 and I am testing the following SQL-2 > query: > > 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 > > but the ordering does not work.
does it work without the join? otherwise please file a jira issue and provide steps how to reproduce the issue. thanks. > Debugging the SimpleScoreDocComparator I see > that the values for comparing are null all the time. Looking at > *JCR-800<http://issues.apache.org/jira/browse/JCR-800> > *I assume that RelPathScoreDocComparator should be used instead. that one is only used when there is a relative path in the order by clause with more than one segment. otherwise the SimpleScoreDocComparator is used. regards marcel > Does this > already work with SQL-2 queries or do I have to change the query in order to > make it work ? > > Regards, > Benjamin >
