Possible crash in prepared insert statements
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8296 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.beta1 |
| Fix Versions | Exasol 6.2.0, Exasol 7.0.0, Exasol 6.1.5 |
| Resolution Date | 2019-07-10 |
Description
We have discovered a bug in our system which manifests itself by query crashes when doing prepared inserts. For the crashes to occur, all of the following conditions have to be met:
- Prepared inserts - regular insert statements are not affected
- String columns - types CHAR and VARCHAR
- Many values (null included) inserted into a string column in a single execute - about 100k rows per node may trigger the problem
Workaround
There is no workaround other than splitting big prepared inserts into several smaller ones (reduce batch size).
