[
https://issues.apache.org/jira/browse/IGNITE-18789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vyacheslav Koptilin updated IGNITE-18789:
-----------------------------------------
Labels: ignite-3 (was: )
> 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: Yury Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> SQL standard 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)
