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

DDL Parser fails when table contains VARCHAR column with DEFAULT value

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate Issue
    • Affects Version/s: 3.8.x-prod-ip6.1, 4.3.0.Final
    • Fix Version/s: 4.4.0.Final
    • Component/s: Sequencers
    • Labels:
      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".

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  elvisisking Daniel Florian
                  Reporter:
                  asmigala Andrej Smigala
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: