Vladimir Steshin created IGNITE-23468:
-----------------------------------------
Summary: Calcite. Fix error of unsupported 'FORMAT' in 'CAST'.
Key: IGNITE-23468
URL: https://issues.apache.org/jira/browse/IGNITE-23468
Project: Ignite
Issue Type: Bug
Reporter: Vladimir Steshin
Assignee: Vladimir Steshin
Calcite 1.37 introduced 'FORMAT' operand in 'CAST. We should support it or
raise an error.
Currently, with '-ea' JVM option an assertion appears:
{code:java}
sql("SELECT CAST('2021-01-01' AS DATE FORMAT 'DD-MM-YY')")
{code}
{code:java}
java.lang.AssertionError: null
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$CastImplementor.implementSafe(RexImpTable.java:1517)
~[classes/:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$AbstractRexCallImplementor.genValueStatement(RexImpTable.java:1956)
~[classes/:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$AbstractRexCallImplementor.implement(RexImpTable.java:1917)
~[classes/:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:1052)
~[classes/:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:81)
~[classes/:?]
{code}
without '-ea':
{code:java}
assertQuery("SELECT CAST('2021-01-02' AS DATE FORMAT 'DD-MM-YYYY')")
.returns(sqlTime("02-01-2021")).check();
{code}
Error:
{code:java}
java.lang.AssertionError: Collections are not equal (position 0):
Expected: [[02-01-2021]]
Actual: [[2021-01-02]]
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
