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

Copy Rows to Results: Clear Result Rows at initialization

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 8.2.0. GA
    • Fix Version/s: 8.3.0 GA
    • Component/s: Step
    • Labels:
      None
    • Story Points:
      0
    • 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)
    • Steps to Reproduce:
      Hide

      1) Have a job receive rows from previous job/transformation ("Get rows from result").
      2) Filter the rows based on some logic (true/false).
      3) Send "true" rows to output ("Copy rows to result").
      4) Make sure all rows are discarded ("false").
      5) Subsequent job/transformation now receives the original full result rows set, even though no rows passed the filter!

      Show
      1) Have a job receive rows from previous job/transformation ("Get rows from result"). 2) Filter the rows based on some logic (true/false). 3) Send "true" rows to output ("Copy rows to result"). 4) Make sure all rows are discarded ("false"). 5) Subsequent job/transformation now receives the original full result rows set, even though no rows passed the filter!

      Description

      If all incoming rows are "false", no rows are sent to output "Copy rows to result". One would expect that any subsequent jobs/transformations would receive 0 result rows (empty). Instead, the entire result rows are left intact! It seems impossible to filter away an entire result rows set, only parts of it. At least one row must be sent to "Copy rows to result" in order to affect the result rows.

      Solution: Clear Result Rows at initialization of the Copy Rows to Results step.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rrosinha Ricardo Rosinha
                Reporter:
                Sparkles Sparkles
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: