Skip to content
This repository has been archived by the owner on Jun 24, 2020. It is now read-only.

Binding arrays for "IN" queries #50

Closed
alexeremeev opened this issue Jun 3, 2019 · 1 comment
Closed

Binding arrays for "IN" queries #50

alexeremeev opened this issue Jun 3, 2019 · 1 comment
Labels
status: declined A suggestion or change that we don't feel we should currently apply

Comments

@alexeremeev
Copy link

As example:
List<Integer> age = new ArrayList(); age.add(10); age.add(20); age.add(30); r2dbc .withHandle(handle -> handle.select("select * from persons where age in ($1)") .bind("$1", ) .mapResult(result -> result.map(toWrapper())));

@mp911de mp911de added the status: declined A suggestion or change that we don't feel we should currently apply label Sep 11, 2019
@mp911de
Copy link
Member

mp911de commented Sep 11, 2019

This does not work as R2DBC Client does not process the SQL query. Each bound parameter in a IN requires its own placeholder. Similar, to how JDBC works.

@mp911de mp911de closed this as completed Sep 11, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
status: declined A suggestion or change that we don't feel we should currently apply
Projects
None yet
Development

No branches or pull requests

2 participants