[
https://issues.apache.org/jira/browse/IGNITE-24824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-24824:
--------------------------------------
Description:
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).
was:
When the type {{TIMESTAMP_WITH_LOCAL_TIME_ZONE}} was enabled (IGNITE-21551),
coverage by SQL logic tests was completely missed.
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)
Also add checks to verify different precision of columns (to
{{test_timestamp.test}}) add corresponding columns to table timestamp_t with
different precision and values)
> 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
> Priority: Major
> Labels: ignite-3
>
> 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)
