![]() ![]() When the value of column id reaches its maximum value no more rows can be inserted in the table using the query above. In the real code there are also other columns in the table and they are also present in the INSERT query but we can safely ignore them because they don't bring any value to this specific issue. `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,Īnd INSERT queries like: INSERT INTO tbl(id) VALUES (NULL) The issue is only with Pentaho version 9.3.Īppreciate your response if someone has seen this behavior.Let's assume a table structure like: CREATE TABLE `tbl` ( With Pentaho 6.0 outputs have always been as expected and increment gets reset to 1. ![]() Upon checking the logs in Heidi sql with Pentaho 9.3 run (unable to do so for Pentaho 6.0 version), I observed "DELETE FROM sample" is getting executed even though truncate option has been checked. Here the auto increment column values have been incremented rather than getting reset to 1 after the truncate. Though, when I run the job again I get below output. When I run the Pentaho job first time, I get the output as expected. On MySQL database table side, I have 2 columns in the table "sample". Table name "sample" and column name "status" with "Truncate Table" and "Return Auto generated key (Name: pk_status)" options checked. I am writing this data to a table column in MySQL database. I have a data grid with a string data for "status" with 4 different static values(e.g. ![]() ![]() The issue I am facing is related to Truncate Option in Table Output with "Return Auto Generated Key" checked.Īn example of my issues is listed as below: I am relatively new to Pentaho and our team is planning to upgrade from Pentaho 6.0 to 9.3 version. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |