Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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