[
https://issues.apache.org/jira/browse/IGNITE-24909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-24909:
--------------------------------------
Description:
Date/time formatting tests currently located in {{test_cast_format.test}}, but
the tests look incomplete.
Need to improve checks for boundary values and templates (see 9.44 Datetime
templates):
* Incorrect templates, for example YYYYY, FF0, FF10, MMM, DDDD and pattern
mismatching (for example {{SELECT CAST('2021-01-02' AS DATE FORMAT
'DD-MM-YY')}} doesn't fail currently)
* Cast values with overflow, for example cast('9999-00-00' as date format
'YYYY-MM-DD') or cast('9999-99-99' as date format 'YYYY-MM-DD') produces
strange results
* Add test for cast with precision greater than zero (for example SELECT
cast('01:05:07.161' as time(*2*) format 'HH24:MI:SS.FF1'))
* Add tests that uses dynamic parameters
* Add tests that uses table columns
was:
Date/time formatting tests currently located in {{test_cast_format.test}}, but
the tests look incomplete.
Need to improve checks for boundary values and templates (see 9.44 Datetime
templates):
* Incorrect templates, for example YYYYY, FF0, FF10, MMM, DDDD
* Cast values with overflow, for example cast('9999-00-00' as date format
'YYYY-MM-DD') or cast('9999-99-99' as date format 'YYYY-MM-DD') produces
strange results
* Add test for cast with precision greater than zero (for example SELECT
cast('01:05:07.161' as time(*2*) format 'HH24:MI:SS.FF1'))
* Add tests that uses dynamic parameters
* Add tests that uses table columns
> Sql. Improve test coverage for date/time templates support
> ----------------------------------------------------------
>
> Key: IGNITE-24909
> URL: https://issues.apache.org/jira/browse/IGNITE-24909
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
>
> Date/time formatting tests currently located in {{test_cast_format.test}},
> but the tests look incomplete.
> Need to improve checks for boundary values and templates (see 9.44 Datetime
> templates):
> * Incorrect templates, for example YYYYY, FF0, FF10, MMM, DDDD and pattern
> mismatching (for example {{SELECT CAST('2021-01-02' AS DATE FORMAT
> 'DD-MM-YY')}} doesn't fail currently)
> * Cast values with overflow, for example cast('9999-00-00' as date format
> 'YYYY-MM-DD') or cast('9999-99-99' as date format 'YYYY-MM-DD') produces
> strange results
> * Add test for cast with precision greater than zero (for example SELECT
> cast('01:05:07.161' as time(*2*) format 'HH24:MI:SS.FF1'))
> * Add tests that uses dynamic parameters
> * Add tests that uses table columns
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
