The condition equalTo() seems wrong

[JarvanMo]

Here's peek from my java file PlayHistory.java:

public class PlayHistory extends RealmObject{
    @PrimaryKey
    private String id;
    public String categorySn = "";
    public String mediaSn = "";
    private int type = TYPE_AUDIO_ONLY;
}

And this my query:

 PlayHistory playHistory = realm.where(PlayHistory.class)
                .equalTo("type", type)
                .equalTo("categorySn", categorySn)
                .findFirst();

It works well until the categorySn becomes integer, like "11115454454".The playHistory is always null if categorySn is an integer.
I don't know why.
I use Realm-4.2.0.

[cmelchior]

Your primary key is a String, so trying to use an Int as input will not work as Realm will not automatically convert the value to a String. It should not return null though, but throw an exception instead.

[JarvanMo]

I can't promise categorySn is always a normal String.

[beeender]

I feel that after you change categorySn to integer, the stored data was not correct. How do you store it? You may need to inspect your realm file first. try realm-studio.

[JarvanMo]

@beeender Here's my peek from realm-studio:

[Zhuinden]

Maybe it's actually a long and not an int?

[JarvanMo]

@Zhuinden I think that's not the point because the categorySn is stored as a String。

[beeender]

@JarvanMo from the screenshot, your categorySn is String. is it possible that categorySn has some characters doesn't match the case? by default, the equalTo is case sensitive match.
Also, is it possible that your string has some invisible characters? maybe you can try with contains(fieldName, value, Case.INSENSITIVE) to identify the issue.

[VenomVendor]

@beeender
From the issue reported.

It works well until the categorySn becomes integer, like "11115454454".

String test = "11115454454";
System.out.println(test.toUpperCase().equals(test.toLowerCase())); // true

@JarvanMo
What is the log of below snippet.

RealmResults<PlayHistory> playHistories = realm.where(PlayHistory.class)
                                            .equalTo("type", type)
                                            .findAll();

for (PlayHistory playHistory : playHistories) {
    if (categorySn.equals(playHistory.categorySn)) {
        Log.e(TAG, "Match Found : Id is " + playHistory.id);
        break;
    } else if (categorySn.trim().equals(playHistory.categorySn)) {
        Log.e(TAG, "Match Found, but not valid : Id is " + playHistory.id);
        break;
    } else if (playHistory.categorySn != null
            && categorySn.trim().equals(playHistory.categorySn.trim())) {
        Log.e(TAG, "Match Found, but double Invalid : Id is " + playHistory.id);
        break;
    }
}

[beeender]

close due to no response