Actually, the parenthesis around the vector list are considered structurally part of the query. But you have not added them. This needs to be:
select person from Person person where person.id is not null and (person.category is null or person.category in (:a1))
Also, this is NOT valid JPQL syntax. JPQL does not define passing a list of parameter values like this.
Actually, the parenthesis around the vector list are considered structurally part of the query. But you have not added them. This needs to be:
Also, this is NOT valid JPQL syntax. JPQL does not define passing a list of parameter values like this.