[hibernate-dev] HHH-1123 - Cannot put more than 1000 elements in a InExpression

[Emmanuel Bernard]

Also note that there is a limit for the query size globally in some vendors and that people relieved from HHH-1123 cal fall into the second limit.
A solution would be for Hibernate to split one query into several but I'm not sure I like the idea.

Emmanuel

On 29 nov. 2011, at 21:29, Łukasz Antoniak wrote:

> Hi all!
> 
> Recently I had a closer look at HHH-1123 issue. This bug affects both - 
> Criteria API and HQL. I have introduced 
> Dialect#maximumInExpressionElements() method which returns maximum 
> number of allowed elements in a single SQL IN clause, or null treated as 
> infinite. The change of InExpression was very easy. However, fixing this 
> bug for HQL queries requires modification of ParameterMetadata 
> (namedDescriptorMap cannot remain unmodifiable), as well as 
> AbstractQueryImpl (queryString). As I don't see any other solution, I 
> wanted to ask you guys for suggestions. Is it the only possible way of 
> fixing this issue? Finally, shall we really fix this? This is a DB 
> vendor limitation, but 40 user gave their vote for it.
> 
> Regards,
> Lukasz Antoniak
> _______________________________________________
> hibernate-dev mailing list
> hibernate-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev