Realm-java: Case.INSENSITIVE query broken at 3.1.3

Created on 15 Jun 2017 · 7Comments · Source: realm/realm-java

It appears that case-insensitive queries are broken in some cases.

It appears that if you have a field with the same string in different cases, querying on the field in a case-insensitive manner returns no results, rather than the expected two results.

This behaviour was working in 3.1.2 but broke in 3.1.3. I suspect this may have been due to a change to realm core. It is still broken as of 3.3.2.

See the Repo here with a failing test:
https://github.com/51systems/RealmBugs

The following test fails:

realm.beginTransaction();
Dog dog1 = realm.copyToRealm(Dog.create("ROVER"));
Dog dog2 = realm.copyToRealm(Dog.create("Rover"));
realm.commitTransaction();

assertThat(realm.where(Dog.class).equalTo("name", "ROVER", Case.SENSITIVE).findAll(),
        containsInAnyOrder(dog1));

assertThat(realm.where(Dog.class).equalTo("name", "Rover", Case.SENSITIVE).findAll(),
        containsInAnyOrder(dog2));

//Fails here
assertThat(realm.where(Dog.class).equalTo("name", "rover", Case.INSENSITIVE).findAll(),
        containsInAnyOrder(dog1, dog2));

Blocked T-Bug

Source

powturns

All 7 comments

Update:
removing @Index from the Dog.name field allows the test to pass, so possibly an index issue.

powturns on 15 Jun 2017

You might be correct, there was an optimization a while ago that ended up in a deadlock when the string contained only numbers and the search was case-insensitive on an indexed field, maybe this is also a side-effect of said optimization and is most likely a bug, see https://github.com/realm/realm-core/pull/2578#issuecomment-297844618

@danielpovlsen

Nice find by the way