Support of INCLUDING COMMENTS for Views
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8013 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 6.2.0, Exasol 6.2.rc1 |
| Resolution Date | 2019-06-07 |
Up to version 6.1 Exasol does not copy column comments from views that are part of the like clause although the like clause contains INCLUDING COMMENTS.
Example:
CREATE SCHEMA a; CREATE SCHEMA b; CREATE TABLE a.t (i int COMMENT IS 'a number'); DESC FULL a.t; -- shows the column comment CREATE TABLE b.t LIKE a.t INCLUDING COMMENTS; DESC FULL b.t; -- shows the column comment CREATE VIEW a.v(i COMMENT IS 'view-column comment') AS SELECT i FROM a.t ; DESC FULL a.v; -- shows the view column comment CREATE TABLE b.tv LIKE a.v INCLUDING COMMENTS; DESC FULL b.tv; -- does not show the comment
Starting with version 6.2 Exasol also copies the column comments from views.