NOT IN comparator is not working with Criteria API

[rjaros]

This code:

client.delete().from("tab").matching(where("id").notIn(1, 2))

generates SQL statement without any conditions:

DELETE FROM tab

When combined with other conditions, an incorrect SQL statement is generated:

client.delete().from("tab").matching(where("pole").`is`(1).and("id").notIn(1, 2))

generates:

DELETE FROM tab WHERE tab.pole = $1 AND 

The IN comparator is working fine.

[mp911de]

Looks like a bug in the Spring Data Relational (JDBC) project as we're using the SqlRenderer.

[schauder]

This will get fixed by https://jira.spring.io/browse/DATAJDBC-410

[mp911de]

Fixed in Spring Data JDBC, added tests in Spring Data R2DBC.