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

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

      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)

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

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

                Created:
                Updated:
                Resolved: