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

Validate not to allow Negative integer inside "Commit size" in Delete step

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: 8.3.0 GA, 9.0.0 GA, 9.1.0 GA
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
      None
    • Environment:
      windows
    • 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.
    • Steps to Reproduce:
      Hide

      Steps to replicate the issue:

      1. Use Pentaho Spoon 8.3 or 9.1.
      2. Set up a test database called "test" containing a table called "tbl" and "tbl1". Each tables should have two columns called "id" and "name".
      3. Insert 4 rows into each tables.
      4. In Spoon, set up a connection called "mysql" and point it to the database created in Step 2.
      5. Open the attached Commit.ktr transformation and in the Delete Step change the commit size to -1.
      6. Run the transformation, verify that all rows have been deleted from the table(tbl1).
      7. In Spoon, open the Delete step and change the commit size to 0.
      8. Execute Steps 3 and 6, verify the rows have been deleted.
      Show
      Steps to replicate the issue: Use Pentaho Spoon 8.3 or 9.1. Set up a test database called "test" containing a table called "tbl" and "tbl1". Each tables should have two columns called "id" and "name". Insert 4 rows into each tables. In Spoon, set up a connection called "mysql" and point it to the database created in Step 2. Open the attached  Commit.ktr transformation and in the Delete Step change the commit size to -1. Run the transformation, verify that all rows have been deleted from the table(tbl1). In Spoon, open the Delete step and change the commit size to 0. Execute Steps 3 and 6, verify the rows have been deleted.

      Description

      The transformation with the Delete step having the "Commit Size" with a negative integer set, the rows are committed. Same behavior as when 0 is specified.

      Table Input step with the table(tbl) having columns called "id" and "name".

       

      Delete Step with the table(tbl1) having columns called "id" and "name”, Commit Size= 0, the values are set like if the id(s) in the column from table(tbl) is equal to the id(s) in table(tbl1), it deletes the same id(s) from the table(tbl1).

      If we give "Commit Size= -1 a negative integer, the rows getting deleted. Same behavior as when 0 is specified.

        PractiTest Integration




          Attachments

          1. Table input.PNG
            Table input.PNG
            37 kB
          2. Delete.PNG
            Delete.PNG
            28 kB
          3. Commit.PNG
            Commit.PNG
            21 kB
          4. Commit.ktr
            14 kB

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              mohshaik Mohamed Mujahid Shaik
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: