jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Parvulescu <alex.parvule...@gmail.com>
Subject Re: JCR_SQL2 joins
Date Mon, 05 Dec 2011 11:21:51 GMT
Hi,

Actually, it should be able to expand the "*". What version of jackrabbit
are you using?

See [0], [1] for some examples of SQL2 joins.

best,
alex


[0]
http://svn.apache.org/repos/asf/jackrabbit/trunk/jackrabbit-core/src/test/java/org/apache/jackrabbit/core/query/JoinTest.java
[1]
http://svn.apache.org/repos/asf/jackrabbit/trunk/jackrabbit-core/src/test/java/org/apache/jackrabbit/core/query/SQL2OuterJoinTest.java


On Tue, Nov 1, 2011 at 7:23 PM, Jukka Zitting <jukka.zitting@gmail.com>wrote:

> Hi,
>
> On Tue, Nov 1, 2011 at 7:01 PM, jsmarks <jmarks@salo.com> wrote:
> > select * from [nt:folder] as fo left outer join [nt:file] as fi on
> > isdescendantnode(fi, fo)
> >
> > the error is "This query result contains more than one selector". Trying
> fo
> > or fi in place of * tells me I need to supply a selector name.
>
> Use "fo.*", "fi.*" or "fo.*, fi.*" instead of "*".
>
> I guess we should make the query parser automatically expand "*" to
> all the properties of all the selectors, but until that's done you
> need to explicitly list the selectors from which you want results.
>
> BR,
>
> Jukka Zitting
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message