[
https://issues.apache.org/jira/browse/IGNITE-23468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Steshin updated IGNITE-23468:
--------------------------------------
Ignite Flags: (was: Docs Required,Release Notes Required)
> 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
> Affects Versions: 2.17
> Reporter: Vladimir Steshin
> Assignee: Vladimir Steshin
> Priority: Minor
> Fix For: 2.17
>
>
> 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)
