ALTER TABLE ADD COLUMN: missing length check for column name
Details
| Detail name | Value |
|---|---|
| Changelog Number | 13370 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.2.0, Exasol 7.0.0, Exasol 7.1.0 |
| Fix Versions | Exasol 8.0.0, Exasol 7.0.14, Exasol 7.1.3 |
| Resolution Date | 2021-11-26 |
Background
Identifiers have a limit of 128 characters.
Description
ALTER TABLE ADD COLUMN does not check for the length of the column name. This can lead to illegal column names causing internal server errors when querying corresponding system tables.
Workaround
Drop the column that has the name with more than 128 characters after saving the data using EXPORT and IMPORT subsequently.
Fix
Changing the name of a column to more than 128 characters is not possible anymore as expected.
