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

[RH Bugzilla Integration (JIRA)]

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

RH Bugzilla Integration updated TEIID-5441:
-------------------------------------------
    Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1614834
        Bugzilla Update: Perform


> 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
>
> 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)