You are not logged in.
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!