Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2248

Teiid Connection import fails to parse DDL when table contains VARCHAR column with DEFAULT value

XMLWordPrintable

      Create a table with

      CREATE TABLE t1 ( c1 VARCHAR(10) DEFAULT 'c1' )

      When trying to import it through Teiid Connection Importer, the importer DDL is shown as 

      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);

      but on the next page, the following error is shown (see screenshot):
      The DDL failed to parse with message: "Unparsable table body".

        1. screen-1.png
          screen-1.png
          34 kB

            blafond Barry LaFond
            asmigala@redhat.com Andrej Smigala
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: