Improved error messages for duplicate or unknown columns in table constraints

Details

Detail name Value
Changelog Number 11726
Type Improvement
Status Resolved
Fix Versions Exasol 8.7.0, Exasol 7.1.16
Resolution Date 2022-11-01

Improvement

Improved error messages when adding an invalid constraint to a table
e.g.

create table T1 (A int, B int, partition by A, A);
-- Returns the error "duplicate column A in partition key"
create table T2 (A int, distribute by C);
-- Returns the error "column C not found in distribution key"

Changed behavior

Improved error messages when adding an invalid constraint to a table