[
https://issues.apache.org/jira/browse/IGNITE-23523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-23523:
----------------------------------------
Description:
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.
Annother issue it si present 'T' between date and time
was:
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.
> 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.
> Annother issue it si present 'T' between date and time
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
