[jira] [Assigned] (IGNITE-24825) Sql. Limit YEAR value to range 1-9999

["Pavel Pereslegin (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-24825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pavel Pereslegin reassigned IGNITE-24825:
-----------------------------------------

    Assignee: Pavel Pereslegin

> Sql. Limit YEAR value to range 1-9999
> -------------------------------------
>
>                 Key: IGNITE-24825
>                 URL: https://issues.apache.org/jira/browse/IGNITE-24825
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 3.0
>            Reporter: Pavel Pereslegin
>            Assignee: Pavel Pereslegin
>            Priority: Major
>              Labels: ignite-3
>             Fix For: 3.1
>
>
> Currently the value of YEAR in temporal types (DATE, DATETIME, TIMESTAMP) is not limited.
> This leads to confusion, for example the year in a binary tuple for date/datetime is limited to 3 bits (silent overflow happens when handling larger values).
> At the same time, SQL engine currently does not support a year less than or equal to zero ().
> {{Timestamp}} ({{TIMESTAMP_WITH_LOCAL_TIME_ZONE}}) can handle larger values, but firstly the SQL engine cannot correctly convert such a date into a VARCHAR (see {{org.apache.calcite.avatica.util.DateTimeUtils.unixDateToString}}), and secondly it looks that we need to have consistency between {{TIMESTAMP}} and {{TIMESTAMP_WITH_LOCAL_TIME_ZONE}} types.
> Definition of done:
> * Forbid date/datetime/timestamp values with year <=0 and year > 9999 (should be restricted in kv/sql/jdbc/etc). Validation shouldn't be on binary tuple level. For KV API we can add validation to org.apache.ignite.internal.schema.Column.validate() method.
> * Ensure interval arithmetic produces corresponding error when overflow happens (e.g. {{select timestamp '9999-12-31 00:00:00' + INTERVAL 1 DAYS}}). (This can be extracted into a separate ticket if it is complicated).



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