Using in Query with collection of composite keys generates invalid query on Mysql with empty collection

Query to update by composite ids in collection works for multiple ids, but for empty collection against MySQL, bad query gets generated ends up being below (Captured by debugging org.hibernate.query.internal.AbstractProducedQuery#doExecuteUpdate )

Which later causes error:

We have entity with composite key, and then we have another table of that to hold our LOB columns to avoid loading them unnecessarily.

We want to be able to null out the jsonContent without having to load the entity (and the large column), so we wrote a query

This works fine in our test environment against h2 database, but against mysql, when ids is empty, get error explained above. works as long as there is 1 or more items in the collection.