xiong duan created CALCITE-6578:
-----------------------------------
Summary: RelToSql throws exception when unparse TIMESTAMPDIFF
function
Key: CALCITE-6578
URL: https://issues.apache.org/jira/browse/CALCITE-6578
Project: Calcite
Issue Type: Improvement
Reporter: xiong duan
Unit test in RelToSqlConverterTest:
{code:java}
@Test void testTimestampdiff() {
String query = "select TIMESTAMPDIFF(day,date '2029-05-06',date '2029-05-07')";
String expected = "";
sql(query).ok(expected);
}{code}
The RelNode is:
{code:java}
LogicalProject(EXPR$0=[CAST(/INT(Reinterpret(-(2029-05-07, 2029-05-06)),
86400000)):INTEGER NOT NULL])
LogicalValues(tuples=[[{ 0 }]]){code}
Exception:
{code:java}
class org.apache.calcite.sql.SqlSyntax$7: SPECIAL
java.lang.UnsupportedOperationException: class
org.apache.calcite.sql.SqlSyntax$7: SPECIAL{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
