[
https://issues.apache.org/jira/browse/IGNITE-24824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17941611#comment-17941611
]
Maksim Zhuravkov commented on IGNITE-24824:
-------------------------------------------
[~xtern] Could you please review my PR?
> Sql. Add SQL logic tests for TIMESTAMP WITH LOCAL TIME ZONE type
> ----------------------------------------------------------------
>
> Key: IGNITE-24824
> URL: https://issues.apache.org/jira/browse/IGNITE-24824
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Pavel Pereslegin
> Assignee: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
> Time Spent: 10m
> Remaining Estimate: 0h
>
> When the type {{TIMESTAMP_WITH_LOCAL_TIME_ZONE}} was enabled (IGNITE-21551),
> coverage by SQL logic tests was completely missed.
> Definition of done:
> * Need to add SQL logic tests for {{TIMESTAMP WITH LOCAL TIME ZONE}} type. I
> believe we can start by duplicating SQL logic tests related to {{TIMESTAMP}}
> (test_timestamp.test, test_incorrect_timestamp.test, test_cast_format.test
> etc)
> * Add checks to verify different precision of columns (to
> {{test_timestamp.test}}) add corresponding columns to table timestamp_t with
> different precision and values)
> * Add tests to verify compatibility of TIMESTAMP -> TIMESTAMP WITH LOCAL TIME
> ZONE and vice versa (e.g. insert into ts_table (TIMESTAMP) values from
> ts_ltz_table (TIMESTAMP_WITH_LOCAL_TIME_ZONE) , insert into TS column TS_WLTZ
> literal and vice versa).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
