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.