hansva opened a new issue, #9259: URL: https://github.com/apache/hop/issues/9259
### Apache Hop version? 2.20.0 ### Java version? 21 ### Operating system Other ### What happened? ### What happened? The Calculator's date arithmetic stops the pipeline when field A (the date) or field B (the amount) is null: | Calculation | On a null value | |---|---| | Date A + B Days | `NullPointerException` | | Date A + B Hours | `NullPointerException` | | Date A + B Minutes | `NullPointerException` | | Date A + B Seconds | `NullPointerException` | | Date A + B Months | `HopValueException: Unable to add months with a null value` | Almost every other Calculator calculation returns null when an argument is null, so a single row with an empty date fails the whole transform only for these five. #### Example 1. Generate rows with a Date field `d` that is null on one row, and an Integer field `n` = 1. 2. Add a Calculator with the calculation "Date A + B Days", A = `d`, B = `n`. 3. The transform fails with a `NullPointerException` on the row where `d` is null. ### Issue Priority Priority: 2 ### Issue Component Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
