sql query issue with 2.2.4

[Alejandro Gomez]

Hi,

I have this query :

select ...

joins...

WHERE
        (       (ISSAMENODE(projects,
'/repository/projects/U970f5509-54de-46d8-88bd-bc1a94ab85eb')))
        AND
        (       ( ISDESCENDANTNODE( projects, '/repository/projects') AND
eventclassassociations.active = true )
                or
                ( ISDESCENDANTNODE( projects, '/repository/template') )
        )
        AND ((NAME(parentRelationshipStatus) = 'parentRelationshipStatus'))

There were NO problem with 2.1.2, when I moved to 2.2.4 I obtained :

javax.jcr.UnsupportedRepositoryOperationException: Unable to split a
constraint that references both sides of a join:
((ISDESCENDANTNODE(projects, [/repository/projects])) AND
(eventclassassociations.active = CAST('true' AS BOOLEAN))) OR
(ISDESCENDANTNODE(projects, [/repository/template]))



What does it means and why this happens now and not before?


Thanks to everyone


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.