HibernateOrmCriteriaEntityLoader needs to execute multiple queries in cases where the underlying database has a limit on the total amount of query parameters

Description

Remove the assumption from org.hibernate.search.integrationtest.mapper.orm.search.loading.SearchQueryEntityLoadingFetchSizeIT#checkFetchSizeSupported once this is implemented, as we will probably use the fetch size to determine the number of queries to execute?

CriteriaObjectsInitializer already takes care of the case that some databases only support a limited amount of entries per IN clause. However, in some databases there exists also a overall limit of parameter which can be set per query, eg SQLServer.

See also: https://forum.hibernate.org/viewtopic.php?f=9&t=1013066 and

Environment

None

Assignee

Yoann Rodière

Reporter

Hardy Ferentschik

Labels

None

Suitable for new contributors

Yes, likely

Feedback Requested

None

Components

Fix versions

Affects versions

Priority

Major
Configure