Reverse Engineer Exasol Comments

[ssteinhauser]

When reverse engineering tables from an existing exasol database, comments are not recognized correctly. The comments on a table are not being recognized, but they are somehow being used as (part of) the comment on the table:

Actual statement:

create or replace table test.test (
    id1 integer comment is 'id1',
    id2 integer comment is 'id1'
)
;

DbSchema reverse engineered:

CREATE OR REPLACE TABLE "TEST"."TEST"(
    "ID1" DECIMAL(18,0), 
    "ID2" DECIMAL(18,0)
);

COMMENT ON TABLE "TEST"."TEST" is ''("ID1" is 'id1',"ID2" is 'id1');

1. Please check DbSchema Help / Output logs for errors. No issue, following output:

CREATE OR REPLACE TABLE "TEST"."TEST"(
    "ID1" DECIMAL(18,0), 
    "ID2" DECIMAL(18,0)
)

Parsed.

COMMENT ON TABLE "TEST"."TEST" is ''("ID1" is 'id1',"ID2" is 'id1')

Parsed.

3. Please include the DbSchema version, operating system and used database DbSchema Version: 9.6.5 OS: Windows Database: Exasol

4. The steps to reproduce this issue Execute the following statement to create a test table and reverse engineer that with DbSchema:

create or replace table test.test (
    id1 integer comment is 'id1',
    id2 integer comment is 'id1'
)
;