topic Int (null) -> 0 in Installing and Upgrading

Int (null) -> 0

_AnonymousUser — Sat, 16 Nov 2024 14:35:11 GMT

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.

Re: Int (null) -> 0

_AnonymousUser — Mon, 09 Jul 2007 07:54:19 GMT

Am I the only one who has this problem ?

Re: Int (null) -> 0

amaumont — Mon, 09 Jul 2007 10:09:48 GMT

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 ?

Re: Int (null) -> 0

_AnonymousUser — Mon, 09 Jul 2007 10:39:47 GMT

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 :

Re: Int (null) -> 0

amaumont — Mon, 09 Jul 2007 11:36:38 GMT

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

Re: Int (null) -> 0

_AnonymousUser — Tue, 10 Jul 2007 13:38:50 GMT

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 ?

Re: Int (null) -> 0

Anonymous — Tue, 10 Jul 2007 15:11:14 GMT

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