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

The table compare step reports incorrect record as missing

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 5.0.0 GA (5.0.0 GA Suite Release)
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
    • Story Points:
      5
    • 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:
      Pervach

      Description

      There is in fact a record missing, from the compare table. The table compare step will sometimes report the wrong record as missing.

      The following sample shows the issue:

      reference table records: [1,a],[2,b],[3,c]
      compare table records: [1,a],[3,c]

      The table compare step will then report the record with key 3 as missing from the compare table. It should report the record with key 2 as missing.

      Attaching reproduction transformation and small sql dump.

        Attachments

        1. compare_test.ktr
          13 kB
        2. PDI-7255.png
          PDI-7255.png
          39 kB
        3. test.sql
          1 kB

          Activity

            People

            Assignee:
            alena_khamitsevich Alena Khamitsevich (Inactive)
            Reporter:
            schodnicki Slawomir Chodnicki (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: