topic Re: tDBSCD component does not change date(time) fields to NULL in Talend Studio

tDBSCD component does not change date(time) fields to NULL

Vlatko — Fri, 15 Nov 2024 22:37:49 GMT

tDBSCD seems to ignore change of dates from something to NULL. At least when a date field is listed among Type 2 fields in the tDBSCD component.

When a varchar or int field changes from a value to NULL, tDBSCD will discover the change and perform a Type 2 change. If a date field is changed from something to NULL, the change will be done as expected.

But if the only change in a row is a change of a date field from a value to NULL, then the tDBSCD will ignore it and no data update will be done at all.

This is a clear bug.

The database is mySQL. Running Talend 7.3.

Re: tDBSCD component does not change date(time) fields to NULL

Anonymous — Tue, 23 Aug 2022 19:20:26 GMT

Hi @Vlatko Duric,

Thanks for raising this. If you have a support license, would you mind contacting support and sharing the job in which you are seeing this behaviour with them? If we can see the configuration of your job we can rule out a config issue and get straight to being able to demonstrate this issue to R&D.

Re: tDBSCD component does not change date(time) fields to NULL

Vlatko — Wed, 24 Aug 2022 10:33:03 GMT

Yes, we have support license, so I will contact Talend support for this.

By the way, this error is easy to re-produce. All you need is a simple job where the input to a tDBSCD compnent is a datetime field, among other fields. You can have all of them as Type 2.

Then do some changes on Type 2 fields in the input. You will notice that in the case when you ONLY change a datetime field from a valid date value to NULL, then the tDBSCD component will not perform the change at all. The change will be just ignored.

Re: tDBSCD component does not change date(time) fields to NULL

Vlatko — Wed, 24 Aug 2022 10:36:25 GMT