DML statements may crash for tables containing HASHTYPE(1,...,15, 17,18,19 BYTE) columns
Details
| Detail name | Value |
|---|---|
| Changelog Number | 13304 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.0 |
| Fix Versions | Exasol 7.0.14, Exasol 7.1.4 |
| Resolution Date | 2021-11-26 |
Background
For tables involved in joins, some statistics are computed on the affected columns to help in determining an optimal join order. These are maintained upon any DML operations performed on the table.
Description
DML statement (insert, delete, update, import, merge) may crash if the affected table (the target of the DML statement) contains a column of type HASHTYPE(1,...,15, 17,18,19 BYTE).
Workaround
Change those HASHTYPES to CHAR
Fix
DML statements work correctly with those HASHTYPES.
