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

In Formula step, executing MIN () results in an error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Low
    • Resolution: Fixed
    • Affects Version/s: 6.1.0.1 GA, 7.0.0 GA
    • Fix Version/s: 7.1.0 GA
    • Component/s: Step
    • Labels:
    • 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. Please run the attached transformation to replicate the issue.

      Show
      1. Please run the attached transformation to replicate the issue.

      Description

      In Formula step, executing MIN () results in an error.
      But the semantics explain differently,

      Semantics: Returns the value of the minimum number in the list passed in. Returns zero if no numbers are provided in the list. What happens when MIN is provided 0 parameters is implementation-defined, but MIN() with no parameters should return 0.

      At the same time if you use MAX() this gives us "0" as the result.

        Attachments

        1. MIN_log.txt
          3 kB
        2. MIN.ktr
          14 kB
        3. Recording #6.mp4
          7.06 MB

          Activity

            People

            Assignee:
            upihin Uladzimir Pihin (Inactive)
            Reporter:
            jagdeesh.ss Jagdeesh.SS (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: