Using multi-tenant discriminator mode, IN queries are broken about gorm-hibernate5 HOT 3 OPEN

multi-tenant-hibernate-issue.zip
sample app

from gorm-hibernate5.

as far as I can see the “issue” is very old

I tried it in Grails 3.1.x and and older versions of GORM and the behaviour is the same

I can go back further versions but this is nothing new it seems
the issue can be worked around simply by replacing

inList("books", [book])

with

books {
                inList('id', book.id)
}

Should it work? Probably.. it would be a matter of altering AbstractHibernateQuery to detect that the query is on books and that books is an association and transforming the query into the latter example as above that could probably be regarded as a new feature / improvement since there is a current workaround.

Duplicates this report from a while back:

https://github.com/grails/grails-core/issues/10796

from gorm-hibernate5.

Thanks for looking into this. The only reason I assumed it should work because it was for them with gorm and mongo( at least on the older version they were running). I think the workaround will work fine for them now, I'll try that out today.

from gorm-hibernate5.