Hi
I have SQL query :
select * from nt:unstructured where jcr:path like '%/childNode0Level1'
and XPath :
//GUI//childNode0Level1
My repository :
root
|->jcr:system
|->GUI
|->new.xml
new.xml look :
<rootElement>
<childNode0Level1>
<childNode0Level2>
</childNode0Level2>
</childNode0Level1>
<childNode1Level1>
<childNode0Level2>
</childNode0Level2>
</childNode1Level1>
<childNode0Level1>
<childNode0Level2>
</childNode0Level2>
</childNode0Level1>
</rootElement>
And the problem is different result returned by XPath and SQL. XPath
find 2 childNode0Level1 and SQL only 1. Why?