IMPORT FROM JDBC: Possible wrong results for DECIMAL values with scale zero
Details
| Detail name | Value |
|---|---|
| Changelog Number | 16324 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0 |
| Fix Versions | Exasol 8.34.0, Exasol 8.29.10 |
| Resolution Date | 2025-04-16 |
Description
When executing an IMPORT FROM JDBC statement, a DECIMAL data value with scale 0 was not properly transformed if the destination type is DECIMAL with a non-zero scale.
Example
IMPORT INTO (c1 DECIMAL(5, 3)) FROM JDBC AT 'jdbc:exa:localhost' user 'user1' identified by 'pw' STATEMENT 'SELECT 27';
This statement returned 0.027 instead of 27.
Workaround
IMPORT using a method other than JDBC (e.g. EXA, ORA, CSV).
Fix
This issue has been fixed such that the IMPORT FROM JDBC statement transforms the data values as expected.
