jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@gmx.net>
Subject Re: Different resoult query SQL and XPath
Date Wed, 21 Mar 2007 09:44:25 GMT
Hi Łukasz,

Łukasz Sroka wrote:
> I have SQL query :
> select * from nt:unstructured where jcr:path like '%/childNode0Level1'
> and XPath :
> //GUI//childNode0Level1

those two statements are not exactly the same because the XPath statement you 
have contains two descendant-or-self axis. but that's another issue.

the reason why the SQL query only return one node is the fact that:
jcr:path like '%/childNode0Level1'

is roughly equivalent to an XPath statement:

//childNode0Level[1]

See spec section: 8.5.2.2

if you need all same name siblings you have to write:

jcr:path like '%/childNode0Level1[%]'

regards
  marcel

Mime
View raw message