Pentaho

 View Only

 Checksum no longer working with null values in 9.3

Harm van den Hoek's profile image
Harm van den Hoek posted 10-04-2022 05:24

We started to try if we could upgrade from 9.2 to 9.3.
Only we found out that the Transformation block Checksum (Add a checksum) doesn't work anymore with possible null values. 
It stops the Transformation with the error message: Error running stepnull

Included is a example transformation that has Datagrid that gives a row with an field that has no value.
Connected to that is a Checksum block that on 9.2 works and on 9.3 gives the above error. 

When we checked the code for the Checksum and found that this PR made a change that caused this problem. 
On 9.3 it executes this method that does an toString(), that doesn't work with null values. 
On 9.2 it executes this method that first does a null check before trying to do a toString().

Is this the correct place for this bug report or is there another place we can report this?

Because this doesn't look like the correct behavior for the Checksum block.