]
Barry LaFond commented on TEIIDDES-2572:
----------------------------------------
This appears to be a MS Teiid Parsing issue. The work-around is to save the DDL to your
filesystem/workspace, remove the offending quotes and re-import using the DDL Importer
selecting the Teiid Dialect.
Going to clone this and move to Modeshape JIRA
DDL Parser fails when table contains VARCHAR column with DEFAULT
value
----------------------------------------------------------------------
Key: TEIIDDES-2572
URL:
https://issues.jboss.org/browse/TEIIDDES-2572
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
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".