I’ve a SQL query that when I run in an external program gives me the result of 9068697280905089, however when I run it within the Database Reader node KNIME gets the result 9,068,697,280,905,088
The DB field is Number (38) and the Column Type which KNIME returns is Number (Double)
Have you any idea why KNIME would change the last decimal in the returned result from a 9 to an 8?
The data value returned was different from that in the Oracle table as in the screen shot below. First one is from Oracle Query (Numeric 38 Data Type) the second image is the Default Data Type mapping to a Double which changes the last digit from a 9 to an 8.