[jira] [Created] (IGNITE-14730) Calcite engine. Cast to INTERVAL data type is not working

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

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)