[JIRA] (HHH-16082) "no viable alternative at input" since Hibernate 6
by Réda Housni Alaoui (JIRA)
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=eyJpIjoiZThlNzlmYjE3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZThlNz... ) HHH-16082 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZThlNz... ) "no viable alternative at input" since Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZThlNz... )
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}
The entities:
{code:java}@Entity
public class CalendarEventReminder implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Access(AccessType.PROPERTY)
private int id;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(nullable = false)
private CalendarEvent calendarEvent;
private Date snoozeDate;
private long delay;
}
@Entity
public class CalendarEvent extends Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Access(AccessType.PROPERTY)
private int id;
@Temporal(TemporalType.TIMESTAMP)
private Date startDate;
}{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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100214- sha1:02c55de )
1 year, 8 months
[JIRA] (HHH-16082) "no viable alternative at input" since Hibernate 6
by Réda Housni Alaoui (JIRA)
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=eyJpIjoiYmVjMzNkMmJi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiYmVjMz... ) HHH-16082 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiYmVjMz... ) "no viable alternative at input" since Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiYmVjMz... )
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}
The entities:
{code:java}@Entity
public class CalendarEventReminder implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Access(AccessType.PROPERTY)
private int id;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(nullable = false)
private CalendarEvent calendarEvent;
private Date snoozeDate;
private long delay;
}
public class CalendarEvent extends Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Access(AccessType.PROPERTY)
private int id;
@Temporal(TemporalType.TIMESTAMP)
private Date startDate;
}{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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100214- sha1:02c55de )
1 year, 8 months
[JIRA] (HHH-16082) "no viable alternative at input" since Hibernate 6
by Réda Housni Alaoui (JIRA)
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=eyJpIjoiNWM3NzczYjc5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiNWM3Nz... ) HHH-16082 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiNWM3Nz... ) "no viable alternative at input" since Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiNWM3Nz... )
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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100214- sha1:02c55de )
1 year, 8 months
[JIRA] (HHH-16082) "no viable alternative at input" since Hibernate 6
by Réda Housni Alaoui (JIRA)
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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100214- sha1:02c55de )
1 year, 8 months
[JIRA] (HHH-16082) "no viable alternative at input" since Hibernate 6
by Réda Housni Alaoui (JIRA)
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=eyJpIjoiNDRjYTdlZjIy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiNDRjYT... ) HHH-16082 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiNDRjYT... ) "no viable alternative at input" since Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiNDRjYT... )
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 in 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 ` 5. 6. 10 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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100214- sha1:02c55de )
1 year, 8 months
[JIRA] (HHH-16082) "no viable alternative at input" since Hibernate 6
by Réda Housni Alaoui (JIRA)
Réda Housni Alaoui ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue
Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZmUzYmU5NDNh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZmUzYm... ) HHH-16082 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZmUzYm... ) "no viable alternative at input" since Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16082?atlOrigin=eyJpIjoiZmUzYm... )
Issue Type: Bug Affects Versions: 6.1.5 Assignee: Unassigned Created: 23/Jan/2023 09:23 AM Priority: Major Reporter: 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 in 5.6.10:
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)
But fails on `5.6.10` with:
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
( 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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100214- sha1:02c55de )
1 year, 8 months