[hibernate-issues] [JIRA] (HHH-13896) Issue with CriteriaBuilder with nested functions

[Ramy Siha (JIRA)]

Ramy Siha ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Acc888f26-2932-4bab-97e3-f752e9c285c3 ) *created* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzUyYmQ2NDQ0OTIxNDVjZDgzYjg5Zjc2OGVlMjk2MGEiLCJwIjoiaiJ9 ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13896?atlOrigin=eyJpIjoiNzUyYmQ2NDQ0OTIxNDVjZDgzYjg5Zjc2OGVlMjk2MGEiLCJwIjoiaiJ9 ) HHH-13896 ( https://hibernate.atlassian.net/browse/HHH-13896?atlOrigin=eyJpIjoiNzUyYmQ2NDQ0OTIxNDVjZDgzYjg5Zjc2OGVlMjk2MGEiLCJwIjoiaiJ9 ) Issue with CriteriaBuilder with nested functions ( https://hibernate.atlassian.net/browse/HHH-13896?atlOrigin=eyJpIjoiNzUyYmQ2NDQ0OTIxNDVjZDgzYjg5Zjc2OGVlMjk2MGEiLCJwIjoiaiJ9 )

Issue Type: Bug Affects Versions: 5.4.12 Assignee: Unassigned Attachments: demo.hibernate.zip Components: hibernate-core Created: 15/Mar/2020 04:13 AM Labels: criteria hibernate jpa21 Priority: Major Reporter: Ramy Siha ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Acc888f26-2932-4bab-97e3-f752e9c285c3 )

I've registered a Postgres "jsonb_extract_path_text" function that can extract a specific Json key from JSONB column.
Now trying to apply count aggregate function on it, it produces QuerySyntaxException, seems that the function schema does not support braces

CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery cq = cb.createQuery();
>From from = cq.from(Domain.class);
cq.select(cb.count(cb.function( "jsonb_extract_path_text" , String.class, from.get( "extra" ), cb.literal( "test1" ))));
TypedQuery query = em.createQuery(cq);
List list = query.getResultList();
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: expecting CLOSE, found '(' near line 1, column 22 [select count(function( 'jsonb_extract_path_text' , generatedAlias0.extra, 'test1' )) from com.example.demo.Domain as generatedAlias0]
   at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.hql.internal.ast.ErrorTracker.throwQueryException(ErrorTracker.java:93) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:297) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:113) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:155) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:604) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:716) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
   ... 43 common frames omitted

I've tested the same implementation with EclipseLink and it did not produce any errors, so I don't believe that this goes against JPA specifications.

( https://hibernate.atlassian.net/browse/HHH-13896#add-comment?atlOrigin=eyJpIjoiNzUyYmQ2NDQ0OTIxNDVjZDgzYjg5Zjc2OGVlMjk2MGEiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13896#add-comment?atlOrigin=eyJpIjoiNzUyYmQ2NDQ0OTIxNDVjZDgzYjg5Zjc2OGVlMjk2MGEiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100121- sha1:a2b3dcc )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200315/082eb65a/attachment.html