[hibernate-dev] Empty IN list support

Sanne Grinovero sanne at hibernate.org
Fri Feb 16 06:22:00 EST 2018


Thanks for reminding the JIRA, I see there's quite some people interested in it.

I've added a comment explaining our plans, I guess many are not aware
of our bigger picture.

On 16 February 2018 at 10:57, Bregler, Jonathan
<jonathan.bregler at sap.com> wrote:
> Ok, thanks. For some reason I missed the Jira issue.
>
> - Jonathan
>
> From: Guillaume Smet [mailto:guillaume.smet at gmail.com]
> Sent: Friday, February 16, 2018 11:39 AM
> To: Vlad Mihalcea <mihalcea.vlad at gmail.com>
> Cc: Bregler, Jonathan <jonathan.bregler at sap.com>; hibernate-dev at lists.jboss.org
> Subject: Re: [hibernate-dev] Empty IN list support
>
> See this related issue: https://hibernate.atlassian.net/browse/HHH-8091
>
> On Fri, Feb 16, 2018 at 11:23 AM, Vlad Mihalcea <mihalcea.vlad at gmail.com<mailto:mihalcea.vlad at gmail.com>> wrote:
> I see that we are only using it for testing so that we can skip the:
>
> testEmptyInListQuery
>
> query on certain Dialects.
>
> We could use this info when rendering the JPQL/HQL queries to throw an
> exception before executing the query.
> Nevertheless, an exception will be thrown anyway even if we don't do it.
>
> Vlad
>
> On Fri, Feb 16, 2018 at 11:21 AM, Bregler, Jonathan <
> jonathan.bregler at sap.com<mailto:jonathan.bregler at sap.com>> wrote:
>
>> Hi,
>>
>> HANA doesn't support empty IN lists, so executing an HQL query that gets
>> transformed into a SQL query with an empty IN list results in a SQL parser
>> error on the database side. I noticed that the Dialect class already
>> defines a method called "supportsEmptyInList()" which according to the
>> Javadoc returns "True if empty in lists are supported; false otherwise".
>> However, this method doesn't seem to be used anywhere in the Hibernate
>> code. Is there a reason for that?
>>
>> Thanks,
>> Jonathan
>> _______________________________________________
>> hibernate-dev mailing list
>> hibernate-dev at lists.jboss.org<mailto:hibernate-dev at lists.jboss.org>
>> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>
> _______________________________________________
> hibernate-dev mailing list
> hibernate-dev at lists.jboss.org<mailto:hibernate-dev at lists.jboss.org>
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>
> _______________________________________________
> hibernate-dev mailing list
> hibernate-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev


More information about the hibernate-dev mailing list