[jira] [Created] (IGNITE-23523) Sql. Incorrect time formatting in sql logic test causes test failures

[Maksim Zhuravkov (Jira)]

Maksim Zhuravkov created IGNITE-23523:
-----------------------------------------

             Summary: Sql. Incorrect time formatting in sql logic test 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


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)