Pavel Pereslegin created IGNITE-24909:
-----------------------------------------
Summary: 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
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 (?)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
