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.