Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2865

JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 11.1.2
    • 10.0, 9.0.5, 9.0.6, 9.0.7
    • Import/Export

    Description

      JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision and should be 9. I believe this https://issues.jboss.org/browse/TEIIDDES-2746 may have changed the behavior, in version 9.0.3 it imports correctly.

      You can use jdbc:sqlserver://ENGNTDBS14.mw.lab.eng.bos.redhat.com:1433;databaseName=mss_eds
      user - mss_eds
      password - mss_eds
      table - debtest2, both columns are numeric(9,2)

      Attachments

        1. debTest2Import.png
          debTest2Import.png
          99 kB
        2. debtestImport.png
          debtestImport.png
          98 kB
        3. importedColumns.png
          importedColumns.png
          27 kB

        Activity

          People

            blafond Barry LaFond
            rhn-support-dsteigner Deborah Steigner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: