[jira] [Updated] (IGNITE-18789) Sql. The sign of the default values for precision and scale is not kept

["Iurii Gerzhedovich (Jira)" <ji...@apache.org>]

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

Iurii Gerzhedovich updated IGNITE-18789:
----------------------------------------
    Priority: Minor  (was: Major)

> Sql. The sign of the default values for precision and scale is not kept
> -----------------------------------------------------------------------
>
>                 Key: IGNITE-18789
>                 URL: https://issues.apache.org/jira/browse/IGNITE-18789
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Iurii Gerzhedovich
>            Priority: Minor
>              Labels: ignite-3
>
> SQL standard (P 4.4.1) says:
> {code:java}
> If <precision> or <scale> is not specified explicitly, then the corresponding element of the descriptor effectively contains the null value.{code}
> But we keep our default values. That led to at least a few issues:
> 1) metadata will return incorrect information. For example type DECIMAL will be returned as DECIMAL(32767, 0)
> 2) The same issue will be for TYPEOF function for DECIMAL column will be returned DECIMAL(32767, 0)
> To fix the issue we should amend restrictions for configurations that are currently are not allowed to keep negative values and keep as special values sign default precision and/or scale, or do the properties like a nullable.



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