Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Date: Tue, 1 Nov 2011 11:01:49 -0700 (PDT)
From: jsmarks <jmarks@salo.com>
To: users@jackrabbit.apache.org
Message-ID: <1320170509825-3964627.post@n4.nabble.com>
Subject: JCR_SQL2 joins
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Since XPATH is deprecated, I'm trying to learn SQL2 using the data from the
auto populate function off the home page.

Since there are three different primary node types (nt:file, nt:folder,
nt:resource) in the resulting repository, I can't use a single primary node
type in the SQL2. Unfortunately, when I try:

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.

I conclude from this that one can't query for more than one primary node
type. Am I missing something?

It does not help that I've been unable to find many examples.

--
View this message in context: http://jackrabbit.510166.n4.nabble.com/JCR-SQL2-joins-tp3964627p3964627.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.