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

Details

    Description

      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".

      Attachments

        Issue Links

          is cloned by

          Bug - A problem that impairs or prevents the functions of the product. MODE-2492 DDL Parser fails when table contains VARCHAR column with DEFAULT value

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: