Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5441

Redshift translator "AS decimal" should have 0 default scale

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 11.1, 10.3.4, 11.0.2, 8.12.15.6_4
    • 8.12.14.6_4
    • None
    • None

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-dsteigner Deborah Steigner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: