Query regression when upgrading to latest core

[rorbech]

Bumping realm-java to latest core in realm/realm-java#7837 one of the query test fails. I have isolated the failing query into a separate test and traced the new behavior to originate from d861035

The specific assertion that now fails is in https://github.com/realm/realm-java/pull/7837/files#diff-6301796adc65d635adbd23145c98bfc7828db7ed740a2265aaa89496cc2d4168R579. Before the above commit the query returns two objects while it returns three after the update.

Core version: d861035

[nirinchev]

This may be related to #6831

[rorbech]

I have tried to cut the model down to the essential properties. So basically having:

• Three object, all with an empty dictionary property
• Two of them referencing an object in their children-list-property
  The query "@links.TestClass.children.dictionary.@size == 0" returns 3 elements but returned 2 before including this commit

public class TestClass extends RealmObject {
        @PrimaryKey
        public long id;

        public RealmList<io.realm.entities.TestClass> children;
        public RealmDictionary<io.realm.entities.TestClass> dictionary;
}

@Test
public void coreQueryRegression() {
        realm.beginTransaction();

        TestClass o1 = new TestClass();
        o1.id = 1L;
        TestClass o1Managed = realm.copyToRealm(o1);

        TestClass o2 = new TestClass();
        o2.id = 2L;
        o2.children = new RealmList<>(o1Managed);

        TestClass o2managed = realm.copyToRealmOrUpdate(o2);

        TestClass o3 = new TestClass();
        o3.id = 3L;
        o3.children = new RealmList<>(o2managed);
        realm.copyToRealm(o3);

        realm.commitTransaction();

        RealmResults<TestClass> all = realm.where(TestClass.class).findAll();
        assertEquals(3, all.size());

        RealmQuery<TestClass> empty = realm.where(TestClass.class)
                .rawPredicate("@links.TestClass.children.dictionary.@size == 0");

        assertEquals(2, empty.count()); // Test fails as the above query matches all the entities
}