Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-9323

dealing with decimals in checksum, comparisons etc not according to value

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 4.2.0 GA (4.0.0 GA Suite Release), 4.4.0 GA (4.8.0 GA Suite Release)
    • Fix Version/s: 8.0.0 GA
    • Component/s: Step
    • Labels:
      None
    • Environment:
      java jre 7
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)
    • Operating System/s:
      Windows 7

      Description

      First table input. concerning field is showing as number(9,2), according to database. Records value in database for this column are 10.8 and 10.85.
      Preview is showing 10.8 for both rows. Creating checksum gives same checksum. Also using this field as key match in join etc. gives a match althought db values are
      different. Only adding a select values step after input and using 0.00 in meta-data format will give proper preview and different checksums and matches as I should
      espect because db values are different.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              rutgerdow Rutger Deterd Oude Weme
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: