Domain exists method cross joining entire table with Hibernate

[scottlollman]

I've been tracing some performance issues and found an issue with the GormEntity.exists when using Hibernate.

In AbstractHibernateGormStaticApi each call to criteriaQuery.from creates a new query root. The resulting HQL looks like this:

select count(generatedAlias0) 
from SomeDomain as generatedAlias1, 
SomeDomain as generatedAlias0 
where generatedAlias1.id=1L 

It looks like it just needs to have one of the calls to criteriaQuery.from eliminated.

[jdaugherty]

Can you please provide a sample project or test case that reproduces?

[scottlollman]

https://github.com/scottlollman/grails-data-mapping-issue-2071
Does this work for you?

The project executes the exists method in a Bootstrap on startup. It's configured to log the SQL of all queries.