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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Beaty
Specialist
Specialist

DynamicUtils - getInsertIntoStmtValuesList(Dynamic column, String database, StringBuilder list) method

Hi,

 

Looking at this method call that gets used when constructing the SQL INSERT statements when writing data from a dynamic schema to a database, I think it's missing a case to handle null numeric types.

 

It already has 2 cases for handling DATE and TIME entries, but could do with one or more to cater for numeric values.

 

This would stop the problem where a null integer column in a dynamic schema is getting changed to a 0 (zero).

 

Talend Studio 7.1.1.20181026_1147

 

Labels (3)
2 Replies
Anonymous
Not applicable

Thanks for raising this @dsoulalioux. Would you mind raising issues like this here: https://jira.talendforge.org. Every issue raised in Jira will be assessed and worked on if found to be required, whereas an issue raised here can easily be missed by R&D.

David_Beaty
Specialist
Specialist
Author

Hi,

 

Thanks @rhall raised a Jira for that issue

 

https://jira.talendforge.org/browse/TDI-42528