[
https://issues.apache.org/jira/browse/IGNITE-23523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17896262#comment-17896262
]
Evgeny Stanilovsky commented on IGNITE-23523:
---------------------------------------------
[~jooger] can you rework issue Description, cause seems it not highlight the
main problem according the PR and described case work properly well.
> Sql. Incorrect time formatting in sql logic tests causes test failures
> ----------------------------------------------------------------------
>
> Key: IGNITE-23523
> URL: https://issues.apache.org/jira/browse/IGNITE-23523
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Maksim Zhuravkov
> Assignee: Iurii Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> The following test case fails despite its result is correct
> {code:java}
> SELECT TIME '10:00:00' + INTERVAL '1' DAY
> java.lang.AssertionError: Not expected result at:
> (test_interval_addition.test_ignore:210). [row=0, col=0, expected=10:00:00,
> actual=10:00]
> {code}
> Explanation:
> {noformat}
> jshell> import java.time.LocalTime;
> jshell> String.valueOf(LocalTime.of(10, 0, 0))
> $4 ==> "10:00"
> {noformat}
> We should update formatting for time and date time so it does not lose zeros
> in seconds.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
