[IGNITE-23523] Sql. Incorrect time formatting in sql logic tests causes test failures

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: ignite-3
• Assignee: Iurii Gerzhedovich
• Reporter: Maksim Zhuravkov
• Created: 23/Oct/24 09:52
• Updated: 07/Nov/24 12:25
• Resolved: 07/Nov/24 12:25

Description

The following test case fails despite its result is correct

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]

Explanation:

jshell> import java.time.LocalTime;

jshell> String.valueOf(LocalTime.of(10, 0, 0)) 
$4 ==> "10:00"

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

Issue Links

• links to: PR #4683