ALTER TABLE ... RENAME ... doesn't handle pseudo-column LEVEL correctly
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9670 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.alpha1 |
| Fix Versions | Exasol 7.0.beta1, Exasol 6.2.7 |
| Resolution Date | 2020-05-20 |
Background
By default, pseudo-column LEVEL is not allowed as an ordinary column name in a table.
Example
Following statements throw exception. It is expected behavior.
Error: [42000] LEVEL not allowed as column name.
CREATE TABLE T1 (LEVEL INT); ALTER TABLE T1 ADD COLUMN LEVEL INT;
Problem
However next statement allows to change the name, which cause inconsistent state. In this case, exception is expected.
ALTER TABLE T1 RENAME COLUMN X TO LEVEL;