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, 8.12.15.6_4 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.