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:
-
Steps to Reproduce:
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.
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.
