Hello again, when I execute the following queries (Oak 1.12.0, with no indexes created by me):
*SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] DESCSELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] ASC* I am getting the nodes in the same order (seems ascending), regardless I use ASC or DESC. Is it currently possible to sort by node name? These are org.apache.jackrabbit.oak.query.QueryImpl details for each query, in case it is useful... - Parsing JCR-SQL2 statement: SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] ASC - cost using filter Filter(query=SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] ASC, path=/repo4/*) - cost for reference is Infinity - cost for property is Infinity - cost for nodeType is 44.0 - cost for lucene-property is Infinity - cost for aggregate lucene is Infinity - cost for traverse is 1000.0 - count: 1 query: SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] ASC - query execute SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] ASC - query plan [nt:file] as [s] /* nodeType Filter(query=SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] ASC, path=/repo4/*) where ischildnode([s], [/repo4]) */ - Parsing JCR-SQL2 statement: SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] DESC - cost using filter Filter(query=SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] DESC, path=/repo4/*) - cost for reference is Infinity - cost for property is Infinity - cost for nodeType is 44.0 - cost for lucene-property is Infinity - cost for aggregate lucene is Infinity - cost for traverse is 1000.0 - count: 1 query: SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] DESC - query execute SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] DESC - query plan [nt:file] as [s] /* nodeType Filter(query=SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4]) ORDER BY [NAME()] DESC, path=/repo4/*) where ischildnode([s], [/repo4]) */ Thanks in advance. Jorge
