Description
The ordered index returns the wrong nodes (the child nodes) when the "order by" uses a relative path for the property name. Example:
select * from [nt:file] order by [jcr:content/jcr:lastModified]
This query returns the nodes at level "jcr:content" (the child nodes) instead of the nodes at level "nt:file".