Database Reader large integers

KNIME Analytics Platform
1

HI

Retrieving large integers wrongly assume type

a) The WF part is as follows

b) Thee dynamicaly SQL statement is as follows

c) Which executed in the node

gives:

 

which turns to be

d) However, the real content is different (not negative!)(ignore the order, as sql doesn't guarantee the same order, etc...; the offending records are identified !)

 

e) SQLIte definition of data 

2

This is a problem with SQLite. The driver doesn't tell the correct type unless it has actually seen one of the large values while iterating over the table. Until then it returns "Integer" for the column type instead of the correct "Long". This is a know issue with SQLite therefore we recommend using H2 for embedded databases which doesn't have these problems.