[hibernate-issues] [Hibernate-JIRA] Commented: (HSEARCH-962) CriteriaObjectsInitializer needs to execute multiple queries in cases where the underlying database has a limit on the total amount of query parameters

[Emmanuel Bernard (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=44185#comment-44185 ] 

Emmanuel Bernard commented on HSEARCH-962:
------------------------------------------

I think both mechanisms should be at play BTW. The IN clause max and the total max to keep it as efficient as possible

> CriteriaObjectsInitializer needs to execute multiple queries in cases where the underlying database has a limit on the total amount of query parameters
> -------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HSEARCH-962
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-962
>             Project: Hibernate Search
>          Issue Type: Bug
>          Components: engine
>    Affects Versions: 3.4.1.Final, 4.0.0.CR1
>            Reporter: Hardy Ferentschik
>
> _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 HHH-1123

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira