Yury Gerzhedovich created IGNITE-18789:
------------------------------------------

             Summary: 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


SQL standard says:
If <precision> or <scale> is not specified explicitly, then the corresponding 
element of the descriptor effectively contains the null value.
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)

Reply via email to