Usage of In operator with emptyList [DATAJDBC-604]

[spring-projects-issues]

benzen opened DATAJDBC-604 and commented

Using postgres as a DB

Given an Entity named person. Person have an id and a name.

Doing the following

personRepostory.findByIdIn(anEmptyList);

Will result in a postgres exception about badly defined request.

I expect spring data jdbc to provide a way to support this kind of usecase

---

Issue Links:

• DATAJDBC-639 Backport DATAJDBC-604 (Support empty IN lists) to 2.0.x branch

[spring-projects-issues]

Mark Paluch commented

Linked a related issue in Spring Data R2DBC.

Since most databases don't support empty IN lists, we would render a false condition for IN and a true condition for NOT IN (1=0 respective 1=1)

[spring-projects-issues]

Mark Paluch commented

That's fixed now