[jira] [Created] (CALCITE-5271) Error while unparsing FLOOR function using Postgres dialect

["Parag Jain (Jira)" <ji...@apache.org>]

Parag Jain created CALCITE-5271:
-----------------------------------

             Summary: Error while unparsing FLOOR function using Postgres dialect
                 Key: CALCITE-5271
                 URL: https://issues.apache.org/jira/browse/CALCITE-5271
             Project: Calcite
          Issue Type: Bug
            Reporter: Parag Jain


Using Calcite(1.30.0) to parse this query - select FLOOR(TIMESTAMP '2022-08-01' TO Year)

Parsing is successful but while doing `toSqlString(PostgresqlSqlDialect.DEFAULT).getSql()`. on the parsed *SqlNode* getting following exception -
 
{code:java}
Request failed: java.lang.ClassCastException: class org.apache.calcite.sql.SqlIntervalQualifier cannot be cast to class org.apache.calcite.sql.SqlLiteral 
at org.apache.calcite.sql.dialect.PostgresqlSqlDialect.unparseCall(PostgresqlSqlDialect.java:128)
at org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:126)
at org.apache.calcite.sql.pretty.SqlPrettyWriter$FrameImpl.list2(SqlPrettyWriter.java:1303)
at org.apache.calcite.sql.pretty.SqlPrettyWriter$FrameImpl.list(SqlPrettyWriter.java:1283)
at org.apache.calcite.sql.pretty.SqlPrettyWriter.list(SqlPrettyWriter.java:1080)
at org.apache.calcite.sql.SqlSelectOperator.unparse(SqlSelectOperator.java:154)
at org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:460)
at org.apache.calcite.sql.dialect.PostgresqlSqlDialect.unparseCall(PostgresqlSqlDialect.java:137)
at org.apache.calcite.sql.SqlSelect.unparse(SqlSelect.java:261)
at org.apache.calcite.sql.SqlNode.toSqlString(SqlNode.java:156)
at org.apache.calcite.sql.SqlNode.toSqlString(SqlNode.java:178)
at org.apache.calcite.sql.SqlNode.toSqlString(SqlNode.java:187){code}

Looks like a bug as the "Year" token gets parsed to SqlIntervalQualifier but expectation is of SqlLiteral. Here's a [PR|https://github.com/apache/calcite/pull/2897] with test case to reproduce the issue.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)