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

    Details

      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)

        Gliffy Diagrams

          Attachments

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

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                dsteigne Deborah Steigner
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: