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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
billimmer
Creator III
Creator III

"Nullable" checkbox in Schema still allows nulls

I notice that Talend Components do not throw an exception when a null is passed to a NOT nullable field.  Is this by design?  

 

 

Labels (2)
2 Replies
Anonymous
Not applicable

This is not entirely true. A lot of components throws an error if you configure the schema column as not nullable. Example: most input and output components doing that!

billimmer
Creator III
Creator III
Author

Thanks, i was building a custom component and using tPostgresqlOutputBulk as an example and notice that it excepts nulls even if the schema field is not nullable.  It does convert the null to a string value...  so a null integer would be "0".  But for type String, it outputs a null which crashes on the bulkload component.  Another note about this component - it is impossible to get an empty string value, both null strings and empty strings end up as null in the output.  Must be a bug?

 

My main goal is to follow the existing standard if there is one.

 

Thank you