Pentaho Error: Duplicate entry for key 'PRIMARY'

Question

The error that Pentaho gives is when trying to insert new records of the steep Merge Rows (diff): Error updating batch codigo_postal.0 - Duplicate entry '01002' for key 'PRIMARY'.

The transformation:

Table input final: is a select from table A:

Table input aux: is a select from table B:

Merge Rows (diff) (preview): (row 01002 is identical)

Switch / Case: (only rows new for codigo_postal steep)

In steep Switch / Case (previer): the row '01002' is not in the result (only new rows) but the error is Error updating batch codigo_postal.0 - Duplicate entry '01002' for key 'PRIMARY'.

Does anyone know what may be happening?.

Thank you.

Answer 1

ok, changing the data type to UNSIGNED worked correctly for me:

CAST(cp.id_codigo_postal AS UNSIGNED)

Thank you.