IN in combination with NULL

[cappadaan]

Proposal:

This currently does not work:

AND field IN (NULL, 'other', 'other2')

Gives: syntax error, unexpected NULL near 'NULL,

So we have to use

AND (field IS NULL OR field IN ( 'other', 'other2'))

Which is slow.

Request to add this functionality.

Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

- [ ] Implementation completed - [ ] Tests developed - [ ] Documentation updated - [ ] Documentation reviewed - [ ] [Changelog](https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1&gid=1102439133#gid=1102439133) updated - [x] OpenAPI YAML updated and issue created to rebuild clients

[sanikolaev]

Thanks for the feature request @cappadaan