[ https://issues.apache.org/jira/browse/IGNITE-18817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Evgeny Stanilovsky resolved IGNITE-18817. ----------------------------------------- Resolution: Not A Problem > Sql. Calcite 1.33.0+. TIMESTAMPDIFF requires modification. > ---------------------------------------------------------- > > Key: IGNITE-18817 > URL: https://issues.apache.org/jira/browse/IGNITE-18817 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Maksim Zhuravkov > Priority: Major > Labels: calcite2-required > > After updating to calcite 1.33.0 TIMESTAMPDIFF requires some updates as well > otherwise we get an error. > Query: > {code:java} > SELECT TIMESTAMPDIFF(SECOND, TIMESTAMP '2022-02-01 10:30:28.123', TIMESTAMP > '2022-02-01 10:32:26') > {code} > Error: > {code:java} > Caused by: org.apache.ignite.lang.IgniteException: IGN-CMN-65535 > TraceId:1d8b4f81-efdf-4208-bff1-e90c607b3981 class > org.apache.calcite.sql.SqlIntervalQualifier cannot be cast to class > org.apache.calcite.sql.SqlLiteral > (org.apache.calcite.sql.SqlIntervalQualifier and > org.apache.calcite.sql.SqlLiteral are in unnamed module of loader 'app') > at > app//org.apache.ignite.lang.IgniteException.wrap(IgniteException.java:289) > at app//org.apache.ignite.sql.Session.execute(Session.java:60) > at > app//org.apache.ignite.internal.sqllogic.ScriptContext.executeQuery(ScriptContext.java:89) > at > app//org.apache.ignite.internal.sqllogic.Query.execute(Query.java:263) > at > app//org.apache.ignite.internal.sqllogic.SqlScriptRunner.run(SqlScriptRunner.java:70) > ... 6 more > Caused by: java.lang.ClassCastException: class > org.apache.calcite.sql.SqlIntervalQualifier cannot be cast to class > org.apache.calcite.sql.SqlLiteral > (org.apache.calcite.sql.SqlIntervalQualifier and > org.apache.calcite.sql.SqlLiteral are in unnamed module of loader 'app') > at > org.apache.ignite.internal.sql.engine.prepare.IgniteConvertletTable$TimestampDiffConvertlet.convertCall(IgniteConvertletTable.java:69) > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)