Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Int (null) -> 0

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.
Labels (2)
6 Replies
_AnonymousUser
Specialist III
Specialist III
Author

Am I the only one who has this problem ?
amaumont
Contributor III
Contributor III

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
Specialist III
Specialist III
Author

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
Contributor III
Contributor III

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

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
Not applicable

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