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

DDL Sequencer doesn't populate primary key correctly when constraint defined on a column

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 2.1.0.Final
    • 2.0.0.Final
    • Sequencers
    • None

    Description

      The DDL sequencer produces a unique key with no columns for the following DDL (copied from createTables.ddl in the project's test resource folder):

      CREATE TABLE AUTHREALMS
      (
      REALMUID NUMERIC(10) NOT NULL CONSTRAINT PK_AUTHREALMS UNIQUE,
      REALMNAME VARCHAR(250) NOT NULL UNIQUE,
      DESCRIPTION VARCHAR(550)
      );

      It should specify REALMUID as the key's column.

      (A similar issue exists in the same file for the PRINCIPALTYPES table)

      Marked as a blocker because it's holding up work on the Teiid Designer's DDL importer.

      Attachments

        Issue Links

          Activity

            People

              blafond Barry LaFond
              teiid John Verhaeg (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: