Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

IN operator is not working in case when colomn type is bytea #181

Open
madhurpg71 opened this issue Jan 6, 2021 · 2 comments
Open

IN operator is not working in case when colomn type is bytea #181

madhurpg71 opened this issue Jan 6, 2021 · 2 comments
Labels
status: waiting-for-feedback We need additional information before we can continue

Comments

@madhurpg71
Copy link

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!

@gregturn
Copy link
Contributor

You said "we are using postgres db".

Have you logged this with https://github.com/pgjdbc/r2dbc-postgresql?

@mp911de
Copy link
Member

mp911de commented Jan 15, 2021

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.

@mp911de mp911de added the status: waiting-for-feedback We need additional information before we can continue label Jan 15, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status: waiting-for-feedback We need additional information before we can continue
Projects
None yet
Development

No branches or pull requests

3 participants