[ https://issues.apache.org/jira/browse/IGNITE-17169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Konstantin Orlov resolved IGNITE-17169. --------------------------------------- Resolution: Duplicate > ItFunctionsTest.testCurrentDateTimeTimeStamp fails due different format of > string representation > ------------------------------------------------------------------------------------------------ > > Key: IGNITE-17169 > URL: https://issues.apache.org/jira/browse/IGNITE-17169 > Project: Ignite > Issue Type: Bug > Reporter: Vyacheslav Koptilin > Priority: Blocker > Labels: ignite-3 > > ItFunctionsTest.testCurrentDateTimeTimeStamp fails with the following error: > {noformat} > org.opentest4j.AssertionFailedError: strEnd: 2022-06-14 21:40:43.917, > strRes=2022-06-14T21:40:43.895 ==> > Expected :true > Actual :false > <Click to see difference> > at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:55) > at org.junit.jupiter.api.AssertTrue.assertTrue(AssertTrue.java:40) > at org.junit.jupiter.api.Assertions.assertTrue(Assertions.java:210) > at > org.apache.ignite.internal.sql.engine.ItFunctionsTest.checkDateTimeQuery(ItFunctionsTest.java:97) > at > org.apache.ignite.internal.sql.engine.ItFunctionsTest.testCurrentDateTimeTimeStamp(ItFunctionsTest.java:67) > {noformat} > The root cause of the issue is that the following sql _SELECT > CURRENT_TIMESTAMP_ returns _LocalDateTime_ instead of _Timestamp_. These > classes have different string representations. > _Timestamp_ returns a timestamp in JDBC timestamp escape format. {@code > yyyy-mm-dd hh:mm:ss.fffffffff} > _LocalDateTime_ returns date-time in the ISO-8601 format {@code > uuuu-MM-dd'T'HH:mm:ss} -- This message was sent by Atlassian Jira (v8.20.7#820007)