Int (null) -> 0

[_AnonymousUser]

Hi,
I've got a problem using tMap component : all Integer fields where values is null becomes 0 after MySQL Insert.
How to avoid this problem ?
thank you.

[_AnonymousUser]

Am I the only one who has this problem ?

[amaumont]

I can't reproduce your problem on our current build, can you precise your TOS version ?
When you explain "After Mysql Insert", where do you see 0 values ? In database, in next component ?

[_AnonymousUser]

Hi.
Thank you for your answer.
My TOS version is 2.1.0 M2 r3967.
All values are into database.
For example : (id_test int not null, val_test1 varchar(100) null, val_test2 int null)
Source :
1;'aaaaaaa';3
2;null;4
3;'cccccccc';null
Destination after TOS job :
1;'aaaaaaa';3
2;null;4
3;'cccccccc';0
Here is an pic of my job :

[amaumont]

Thanks for your informations, they help me to reproduce your problem.
You can follow the bug issue 1450.

[_AnonymousUser]

Hi,
Thank you for your support.
I can see today on bugtracker that the bug is resolved. Is there a way to get the correct files to implement in my project ? Or should I wait the next vers ?

[Anonymous]

The simplest solution is to wait for next release (2.1 stable release will be released before the end of the week).
Regards,