We have discovered a precision bug that applies to the JDBC configuration of Knime. When we try to run a select statement of a numeric column with decimals, Knime will convert the number to double variable. This works fine until the number becomes very large, in our case our column contains the number to the 100,000,000,000,000,000s with 9 decimal precision. Knime will just return the number rounding out the decimals.
Please note that this applies ACROSS twoJDBC database drivers so we don’t think that that problem is driver specific, in our case we use OpenEdge and Snowflake for testing.
Any help will be appreciated.