[jira] [Created] (IGNITE-22780) Sql. Cast from VARCHAR to TS WITH LOCAL TZ doesn't take into account time zone

[Konstantin Orlov (Jira)]

Konstantin Orlov created IGNITE-22780:
-----------------------------------------

             Summary: Sql. Cast from VARCHAR to TS WITH LOCAL TZ doesn't take 
into account time zone
                 Key: IGNITE-22780
                 URL: https://issues.apache.org/jira/browse/IGNITE-22780
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Konstantin Orlov


Let's take a look at case below:

{code:java}
        sql("CREATE TABLE tmp (id INT PRIMARY KEY, s VARCHAR(100))");
        sql("INSERT INTO tmp VALUES (1, '1970-01-01 12:00:00')");

        ZoneId zone = ZoneOffset.ofHours(4);

        assertQuery("INSERT INTO test SELECT s FROM tmp WHERE id = 1")
                .withTimeZoneId(zone)
                .check();

        assertQuery("SELECT * FROM test")
                .returns(Instant.parse("1970-01-01T08:00:00Z"))
                .check();
{code}

Although client which does INSERT with implicit cast from VARCHAR to TS WITH 
LOCAL TZ has zone offset of +4 hours, last query returns 
{{1970-01-01T12:00:00Z}}.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)