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