Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2492

DDL Parser fails when table contains VARCHAR column with DEFAULT value

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • 4.4.0.Final
    • 3.8.x-prod-ip6.1, 4.3.0.Final
    • Sequencers
    • None

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

              dflorian@redhat.com Daniel Florian (Inactive)
              asmigala@redhat.com Andrej Smigala
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: