Jukka Zitting created JCR-3677: ---------------------------------- Summary: Invalid SQL2OrderByTest.testOrderByScore test case Key: JCR-3677 URL: https://issues.apache.org/jira/browse/JCR-3677 Project: Jackrabbit Content Repository Issue Type: Bug Components: jackrabbit-core Affects Versions: 2.7.1 Reporter: Jukka Zitting Priority: Minor
The SQL2OrderByTest.testOrderByScore test case makes a query like the following: SELECT * FROM [nt:base] WHERE ISCHILDNODE([/testroot]) ORDER BY [jcr:score] The test then expects that he matching nodes are returned in a specific order. This is wrong on two counts: 1) The score of a search result is defined only for full text queries. It is meaningless for other queries and undefined by the spec. 2) Even if the score was a defined for such queries, the SQL2 syntax for accessing it is "SCORE()", not "[jcr:score]". Thus I suggest to either remove the test case or to make it use full text search and/or just verify that the results are ordered according to their scores instead of being in any specific predetermined order. -- This message was sent by Atlassian JIRA (v6.1#6144)