spring-data-commons icon indicating copy to clipboard operation
spring-data-commons copied to clipboard

Sorting with ignorecase is rejected despite the documentation

Open vgarmash opened this issue 4 years ago • 1 comments

In current documentation https://docs.spring.io/spring-data/data-mongodb/docs/current/reference/html/#core.web.basic I see the following table: image

It states that it is possible to change case sensitivity for sorting.

Although when trying to use "ignorecase" keyword I am getting the following error:

{
    "message": "Given sort contained an Order for patient.lastName with ignore case! MongoDB does not support sorting ignoring case currently!"
}

The message comes form the Query class: https://github.com/spring-projects/spring-data-mongodb/blob/73a0f0493358dae7040ff3613524ca1450e2a585/spring-data-mongodb/src/main/java/org/springframework/data/mongodb/core/query/Query.java#L211

Either things got changed and there is a way to sort with ignorecase (I guess the collation with strength 1 or 2 can help) or the documentation was copied from somewhere else without considerations of Mongodb specifics.

Please fix the documentation or fix the Query class.

vgarmash avatar Jun 18 '21 15:06 vgarmash

Thanks for reporting - we'll highlight store specific deviation of functionality provided via the commons module.

christophstrobl avatar Dec 13 '21 12:12 christophstrobl