r2dbc/r2dbc-h2

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.