jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jukka Zitting <jukka.zitt...@gmail.com>
Subject Re: JCR_SQL2 joins
Date Tue, 01 Nov 2011 18:23:24 GMT
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
View raw message