[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2248) Teiid Connection import fails to parse DDL when table contains VARCHAR column with DEFAULT value

Teiid Connection import fails to parse DDL when table contains VARCHAR column with DEFAULT value ------------------------------------------------------------------------------------------------ Key: TEIIDDES-2248 URL: https://issues.jboss.org/browse/TEIIDDES-2248 Project: Teiid Designer Issue Type: Bug Components: Import/Export, Teiid Integration Affects Versions: 8.3.3 Environment: Teiid Designer 8.3.3 Teiid 8.4.1-redhat-7 Reporter: Andrej Šmigala Assignee: Barry LaFond Fix For: 9.2, 9.0.3 Attachments: screen-1.png Create a table with {code:sql} CREATE TABLE t1 ( c1 VARCHAR(10) DEFAULT 'c1' ) {code} When trying to import it through Teiid Connection Importer, the importer DDL is shown as {code:sql} CREATE FOREIGN TABLE "dballo00.dbo.t1" ( c1 string(10) DEFAULT '(''c1'')' OPTIONS (NAMEINSOURCE '"c1"', NATIVE_TYPE 'varchar') ) OPTIONS (NAMEINSOURCE '"dballo00"."dbo"."t1"', UPDATABLE TRUE, CARDINALITY 0); {code} but on the next page, the following error is shown (see screenshot): The DDL failed to parse with message: "Unparsable table body".