]
Barry LaFond commented on TEIIDDES-2248:
----------------------------------------
[~elvisisking] Dan, can you check into this? I know you fixed some MS parsing issues with
quotes, so maybe it'll be fixed in upcoming MS release version?
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: Dan Florian
Fix For: 9.2
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".