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)