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

[Debbie Steigner (JIRA)]

Debbie Steigner created TEIID-5441:
--------------------------------------

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