Zero hash value not allowed in HASHTYPE(16 BYTE) NOT NULL column
Details
| Detail name | Value |
|---|---|
| Changelog Number | 15255 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.0.0, Exasol 7.1.7, Exasol 7.1.8, Exasol 7.1.9, Exasol 7.1.10, Exasol 7.1.11, Exasol 7.1.12 |
| Fix Versions | Exasol 7.1.13, Exasol 7.1.9-p1, Exasol 8.5.0 |
| Resolution Date | 2022-08-24 |
Background
In EXASOL-3041, HASHTYPE columns were changed to allow zero hash values.
Description
Zero-hash values cannot be inserted if the following conditions are met:
- Column type is HASHTYPE(16 BYTE)
- Column contains a NOT NULL constraint
Workaround
Remove the NOT NULL constraint from the affected column.
Fix
Zero hash values are allowed in HASHTYPE(16 BYTE) NOT NULL columns.
