[teiid-issues] [JBoss JIRA] (TEIID-5441) Redshift translator "AS decimal" should have 0 default scale

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5441.
-----------------------------------
    Fix Version/s: 11.1
                   10.3.4
                   11.0.2
       Resolution: Done


Updated the decimal cast to have explicit precision and scale.

> Redshift translator "AS decimal" should have 0 default scale
> ------------------------------------------------------------
>
>                 Key: TEIID-5441
>                 URL: https://issues.jboss.org/browse/TEIID-5441
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.12.14.6_4
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>             Fix For: 11.1, 10.3.4, 11.0.2
>
>
> Currently "AS decimal" relies on the posgresql behavior of using a non-zero default scale: https://www.postgresql.org/docs/10/static/datatype-numeric.html
> Whereas redshift has a 0 default:  https://docs.aws.amazon.com/redshift/latest/dg/r_Numeric_types201.html
> So this needs updated in the base postgresql translator to work correctly on redshift.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)