[
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.
The other issue is present 'T' between the date and time.
Let's change formatting for date/time types in SqlLogicTest to simple
human-readable format and fix appropriate tests
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.
Annother issue it si present 'T' between date and time
> 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.
> The other issue is present 'T' between the date and time.
> Let's change formatting for date/time types in SqlLogicTest to simple
> human-readable format and fix appropriate tests
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
