jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alejandro Gomez <alejandro.go...@gmail.com>
Subject SQL2 query fails on jkr 2.2.4 : Unable to split a constraint that references both sides of a join
Date Wed, 02 Mar 2011 20:27:43 GMT
Hi Guys,

I have this query:

SELECT * from [nt:myfirstnodetype] as myfirstnodetypes
INNER JOIN [nt:mysecondnodetype] as mysecondnodetypes
	ON ISDESCENDANTNODE(myfirstnodetypes, mysecondnodetypes)
INNER JOIN [nt:mythirdnodetype] as mythirdnodetypes
	ON ISDESCENDANTNODE (mysecondnodetypes, mythirdnodetypes)
WHERE
	( ISDESCENDANTNODE( mythirdnodetypes, '/some/path') OR
myfirstnodetypes.active = true)

When I run it, I obtain:

javax.jcr.UnsupportedRepositoryOperationException: Unable to split a
constraint that references both sides of a join:
(ISDESCENDANTNODE(mythirdnodetypes, [/some/path])) OR
(myfirstnodetypes.active = CAST('true' AS BOOLEAN))

Is there something wrong? Does anyone have some clue?

This query didn't return any exception with 2.1.2.


I'll appreciate your help regarding this subject.


Best Regards


Alejandro Gomez
	



-- 
Lo que creas de los demás estará signado por lo que creas de ti mismo,
y del mismo modo los hechos de tu vida.

Mime
View raw message