[jira] [Updated] (IGNITE-26246) Sql. Date/Time. CAST to VARCHAR does not preserve trailing zeros

["Iurii Gerzhedovich (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-26246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Iurii Gerzhedovich updated IGNITE-26246:
----------------------------------------
    Epic Link: IGNITE-24676

> Sql. Date/Time. CAST to VARCHAR does not preserve trailing zeros
> ----------------------------------------------------------------
>
>                 Key: IGNITE-26246
>                 URL: https://issues.apache.org/jira/browse/IGNITE-26246
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql ai3
>    Affects Versions: 3.0
>            Reporter: Maksim Zhuravkov
>            Priority: Major
>              Labels: ignite-3
>
> CAST to VARCHAR does not preserve trailing zeros that behaviour was introduced in https://issues.apache.org/jira/browse/IGNITE-24934 and it does  
> {code:java}
>       sql("CREATE TABLE t (id INT, val TIME(3), PRIMARY KEY (id))");
>         sql("INSERT INTO t VALUES (1, TIME '10:12:13.100')");
>         assertQuery("SELECT CAST (val AS VARCHAR), CAST(val AS VARCHAR FORMAT 'hh24:Mi:ss.FF2') FROM t")
>                 .returns("10:12:13.10", "10:12:13.10")
>                 .check();
> {code}
> Returns an error:
> {noformat}
> org.opentest4j.AssertionFailedError: Collections are not equal (position 0):
> Expected: 10:12:13.10 <class java.lang.String>
> Actual:   10:12:13.1 <class java.lang.String>
> {noformat}
> This issue may affect TIMESTAMP/TIMESTAMP_LTZ as well.
> There is a separate issue when intermediate CAST operation is lost (https://issues.apache.org/jira/browse/IGNITE-26242)



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