Types of prepared parameters are guessed wrongly in update statements with multiple clauses
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5290 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0 |
| Fix Versions | EXASOL 6.0.9 |
| Resolution Date | 2018-03-14 |
Problem
In queries like this:
CREATE TABLE t (c1 char(1), c2 char(2)); UPDATE t SET c1 = ?, c2 = ?; -- With bind params of [ "a", "aa" ]
the reported type with for both parameters is CHAR(1).
Workaround
Until the bug is fixed, the guessing of parameter types can be disabled by the command line parameter -guessPrepareParameterTypes=0
