Hello,

when creating a simple tMysqlInput -> tMysqlMap -> tMysqlSCD job transforming a DATE input down to a DATE SCD II column, the generated java code seems not to be able comparing input and output correctly if it is a zero-Date on both sides.

In Debug mode the following code is generated:

...
if ((lookUpValue_tMysqlSCD_1.joined == null && row2.joined != null)
|| (lookUpValue_tMysqlSCD_1.joined != null && !lookUpValue_tMysqlSCD_1.joined.equals(row2.joined))
...

When checking both dates (one from the prior SCD SELECT resultset and one from the row2-Map) they seem to be different:

row2.joined_date:  Wed Dec 31 00:00:00 CET 2
lookUpValue_tMysqlSCD_1.joined: Sat Jan 01 00:00:00 CET 1

On Mysql directly, comparing both values show a true. Is it a bug or am I doing something wrong?

Thanks for your help in advance!
Peter