ALTER TABLE fails for HASHTYPE

Detail name	Value
Changelog Number	9906
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.0.alpha1
Fix Versions	Exasol 7.0.alpha2
Resolution Date	2020-04-14

In version 7.0, hashtype was added as a supported datatype. Adding a new column of type hashtype larger than 16 bytes (via ALTER TABLE  ADD COLUMN) aborts the query with an internal server error. For example:

CREATE SCHEMA test;
CREATE OR REPLACE TABLE test.dummy (TEST HASHTYPE(32 byte));
ALTER TABLE test.dummy ADD COLUMN test2 HASHTYPE(32 byte);

Create a new table with the hashtype column and migrate the data instead of adding the column to an existing table. 

Adding a column of type hashtype larger than 16 will no longer return an internal server error. The column will be added as expected.

Changed behavior

Adding a hashtype column with a width other than 16 bytes by using ALTER TABLE no longer aborts the query with an error.