I try to understand the following problem. I have a table, let it be A, where ID field is varbinary(50).
Then trying to select from this table:

select id from A where id in (9044923298344967);

This clearly should give me one unique records, but I’m getting 3 records instead:

[ { "id": "9044923298344967" }, { "id": "9044923298344968" }, { "id": "9044923298344969" } ].

Those are of course unique records, not only ID but all other data differs.
It works as expected when I modify my query and pass ID as a string:

select id from A where id in ("9044923298344967");

[ { "id": "9044923298344967" } ]

In fact the problem is solved. But I would like to understand what happen here, so I know what impact it could have in other place of the application.