Aleksey Plekhanov created IGNITE-14730:
------------------------------------------
Summary: Calcite engine. Cast to INTERVAL data type is not working
Key: IGNITE-14730
URL: https://issues.apache.org/jira/browse/IGNITE-14730
Project: Ignite
Issue Type: Bug
Reporter: Aleksey Plekhanov
Cast of any expression to INTERVAL data type, for example:
{noformat}
select null::interval
{noformat}
Fails with the exception:
{noformat}
Caused by: class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse
query.
at
org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.prepareQuery(ExecutionServiceImpl.java:539)
at
org.apache.ignite.internal.processors.query.calcite.prepare.QueryPlanCacheImpl.queryPlan(QueryPlanCacheImpl.java:84)
at
org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.executeQuery(ExecutionServiceImpl.java:402)
at
org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.query(CalciteQueryProcessor.java:250)
at
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner.sql(SqlScriptRunner.java:111)
at
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner.access$600(SqlScriptRunner.java:51)
at
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Query.execute(SqlScriptRunner.java:512)
... 3 more
Caused by: org.apache.calcite.sql.parser.SqlParseException: Encountered " "::"
":: "" at line 1, column 12.
Was expecting:
<EOF>
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
