ALTER VIRTUAL SCHEMA doesn't update columns if only the column-level adapter notes changed
Details
| Detail name | Value |
|---|---|
| Changelog Number | 20991 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0 |
| Fix Versions | Exasol 8.29.0, Exasol 7.1.29 |
| Resolution Date | 2024-07-12 |
Description
If an ALTER VIRTUAL SCHEMA statement is executed and the virtual schema adapter makes no changes to the columns of a virtual table except changing the column-level adapterNotes fields, then these adapter notes changes are not stored by the database.
Workarounds
- DROP and CREATE the virtual schema again.
- In the virtual schema adapter, make any additional change to the virtual column, e.g., set the column comment to a random number.
Fix
The ALTER VIRTUAL SCHEMA statement now applies all changes properly.
