ODBC Driver may send incorrect values to the database
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10344 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.0 |
| Fix Versions | Exasol 7.0.0, Exasol 6.2.9 |
| Resolution Date | 2020-08-27 |
Description
In ODBC connections using a Prepared Statement, values that are of type SQL_NUMERIC or are character strings may be sent incorrectly to the database. This happens because the driver has changed the precision and scale of the numeric value or the maximum column size for the character string types.
Workaround
You can convert the decimal values to strings.
In case of the issue arising with strings, there is no workaround.
Fix
The ODBC driver will no longer override these attributes for data type SQL_NUMERIC and string types.
