IN operator is not working in case when colomn type is bytea
madhurpg71 opened this issue · 2 comments
Hello, we are using postgres db and we have a column of type bytea. In java we have mapped it with encryptedAttrVal attribute of type byte[]. Now when I am writing method using IN operator in the repository like below it is not returning any result.
Flux findAllByEncryptedAttrValIn(List<byte[]> attributeValues);
But if I write without IN and pass only one value, it returns the result.
Flux findAllByEncryptedAttrVal(byte[] attributeValues);
However this IN operator is working fine when I am using it on varchar type column. Like below
Flux findAllByStatusIn(List statusList);
This is the first time I am asking any question here so let me know If I need to add any more details.
Thanks in advance!
You said "we are using postgres db".
Have you logged this with https://github.com/pgjdbc/r2dbc-postgresql?
findAllByEncryptedAttrValIn
is not a H2 functionality.
If you would like us to spend some time helping you to diagnose the problem, please spend some time describing it and, ideally, providing a minimal sample using H2 R2DBC directly that reproduces the problem.