[hibernate-dev] Empty IN list support

Bregler, Jonathan jonathan.bregler at sap.com
Fri Feb 16 05:57:33 EST 2018


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



More information about the hibernate-dev mailing list