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

Table output truncating the values in 8.1.0.4 service pack

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Duplicate
    • Affects Version/s: 8.1.0.4 GA
    • Fix Version/s: 8.2.0 GA
    • Component/s: Core (Engine)
    • 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) Please create a table in the database.
      2) Run the attached transformation in 8.0 and 8.1.
      3) Run the transformation again in 8.1.0.4 and see the difference in the field value in the database table.

      Show
      1) Please create a table in the database. 2) Run the attached transformation in 8.0 and 8.1. 3) Run the transformation again in 8.1.0.4 and see the difference in the field value in the database table.

      Description

      Table output step is truncating the value of a field coming from dynamic sql step. Although in table output preview it will show that it wrote the whole value for that particular field but in the database table, it is truncating on the basis of length coming from dynamic sql step. The same thing was not happening in 8.0 and 8.1. It was providing the whole value for the column in the database table. I am pasting the output from 8.0, 8.1 and 8.1.0.4. First two are coming from running the transformation in 8.0.and 8.1 respectively. Last 2 rows are coming from 8.1.0.4 version.

        Attachments

          Activity

            People

            • Assignee:
              mleite Margarida Leite
              Reporter:
              ngupta Nidhi Gupta
            • Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: