search

microsoft / spring-data-cosmosdb

Access data with Azure Cosmos DB
MIT License
94 stars 64 forks source link

IgnoreCase and AllIgnoreCase don't appear to function properly #362

Closed jamesggraf closed 4 years ago

jamesggraf commented 5 years ago

When using the query builder mechanism in Spring Data, the IgnoreCase and AllIgnoreCase keywords don't appear to function properly. For example, creating a Repository with the following method signature successfully creates a function that queries by first name and last name, but does so in a case sensitive manner List<Person> findByLastnameAndFirstnameAllIgnoreCase(String lastname, String firstname);

This signature should be supported as documented in Spring Data: https://docs.spring.io/spring-data/commons/docs/current/reference/html/#repositories.query-methods.details

Additionally Cosmos' SQL API appears to support the lower() function in its queries so adding support for this should be relatively simple?

dvanackere-lpg commented 4 years ago

When testing my program today I found the same problem... 8 months later. Could someone take a look on this? Thanks.

kushagraThapar commented 4 years ago

@david-lpg @jamesggraf I will take care of this in next release, sorry this got delayed.

mkaczor commented 4 years ago

Any update on that?

kushagraThapar commented 4 years ago

@mkaczor - I don't think so there is any update on this, tracking it now for new releases.

kushagraThapar commented 4 years ago

Closing it here as this is being tracked in a separate repo.