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

DDL Parser fails when table contains VARCHAR column with DEFAULT value

    XMLWordPrintable

Details

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

    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

          clones

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-2248 Teiid Connection import fails to parse DDL 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
          duplicates

          Bug - A problem that impairs or prevents the functions of the product. MODE-2445 Failed to import SalesForce Metadata

          • Critical - To be worked on immediately following BLOCKER issues.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: