[hibernate-issues] [JIRA] (HHH-16082) "no viable alternative at input" since Hibernate 6

Réda Housni Alaoui ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTFjMmE0YzJm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZTFjMm... ) HHH-16082 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZTFjMm... ) "no viable alternative at input" since Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZTFjMm... ) Change By: Réda Housni Alaoui ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) We are trying to move from Hibernate 5.6.10 to 6.1.5. We use Postgres 14. The following JPQL query works on {{5.6.10}}: {code:sql}select c from CalendarEventReminder c where (c.snoozeDate is null and (EXTRACT(EPOCH FROM (c.calendarEvent.startDate)) * 1000 - c.delay) <= ?1) or (c.snoozeDate is not null and (EXTRACT(EPOCH FROM (c.snoozeDate)) * 1000 + c.delay) <= ?1){code} But fails on ` {{ 6.1.5 ` }} with: {code:java}Caused by: java.lang.IllegalArgumentException: org.hibernate.query.SemanticException: A query exception occurred [select c from CalendarEventReminder c where (c.snoozeDate is null and (EXTRACT(EPOCH FROM (c.calendarEvent.startDate)) * 1000 - c.delay) <= ?1) or (c.snoozeDate is not null and (EXTRACT(EPOCH FROM (c.snoozeDate)) * 1000 + c.delay) <= ?1)] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:175) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:182) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:761) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:663) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:127) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:360) at jdk.proxy2/jdk.proxy2.$Proxy272.createQuery(Unknown Source) at org.springframework.data.jpa.repository.query.SimpleJpaQuery.validateQuery(SimpleJpaQuery.java:94) ... 239 more Caused by: org.hibernate.query.SemanticException: A query exception occurred [select c from CalendarEventReminder c where (c.snoozeDate is null and (EXTRACT(EPOCH FROM (c.calendarEvent.startDate)) * 1000 - c.delay) <= ?1) or (c.snoozeDate is not null and (EXTRACT(EPOCH FROM (c.snoozeDate)) * 1000 + c.delay) <= ?1)] at org.hibernate.query.hql.internal.StandardHqlTranslator.parseHql(StandardHqlTranslator.java:130) at org.hibernate.query.hql.internal.StandardHqlTranslator.translate(StandardHqlTranslator.java:77) at org.hibernate.internal.AbstractSharedSessionContract.lambda$createQuery$2(AbstractSharedSessionContract.java:748) at org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.createHqlInterpretation(QueryInterpretationCacheStandardImpl.java:141) at org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.resolveHqlInterpretation(QueryInterpretationCacheStandardImpl.java:128) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:745) ... 248 more Caused by: org.hibernate.query.sqm.ParsingException: line 1:85 no viable alternative at input 'selectcfromCalendarEventRemindercwhere(c.snoozeDateisnulland(EXTRACT(EPOCHFROM' at org.hibernate.query.hql.internal.StandardHqlTranslator$1.syntaxError(StandardHqlTranslator.java:46) at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41) at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:543) at org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:310) at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:136) at org.hibernate.grammars.hql.HqlParser.queryExpression(HqlParser.java:1180) at org.hibernate.grammars.hql.HqlParser.selectStatement(HqlParser.java:382) at org.hibernate.grammars.hql.HqlParser.statement(HqlParser.java:313) at org.hibernate.query.hql.internal.StandardHqlTranslator.parseHql(StandardHqlTranslator.java:116) ... 253 more{code} ( https://hibernate.atlassian.net/browse/HHH-16082#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16082#add-comment?atlOrigin=ey... ) 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.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100214- sha1:02c55de )