Pentaho

 View Only
Expand all | Collapse all

PDI 8.0 Insert/Update step inserting NULL value for empty string

This thread has been viewed 3 times
  • 1.  PDI 8.0 Insert/Update step inserting NULL value for empty string

    Posted 06-15-2018 20:10

    After upgrading from 7.1 to 8.0 and I've noticed a change in the Insert/Update step. An empty string gets set to a NULL value in the target database instead of an empty string. Version 7.1 did not do this. 


    #Pentaho


  • 2.  RE: PDI 8.0 Insert/Update step inserting NULL value for empty string

    Posted 06-20-2018 15:00

    Marvin,

    Can you please provide more detailed reproduction steps? I've tested in Pentaho versions 7.1 and 8.0 inserting an empty string into both PostgreSQL and MySQL databases using the Insert/Update step and every time the empty string is inserted as a NULL value.

    -Chris