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

ModeShape DDL Sequencer Does Not Create Primary Key Column Reference For Column Constraint That Uses "PRIMARY KEY" Keywords

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 2.4.0.Final, 2.2.1.GA
    • 2.3.0.Final
    • Sequencers
    • None

    Description

      The primary key in the below DDL, customerfamilyhistoryid_pk, is created but does not have the reference to the customerfamilyhistoryid column. A similar issue, MODE-815 (which dealt with the UNIQUE keyword), has already been fixed. This column constraint is different in that it uses the "PRIMARY KEY" keywords but the fix will be pretty much the same. The only class affected is StandardDdlParser. A related defect, TEIIDDES-550, depends on this being fixed.

      CREATE TABLE CustomerFamilyHistory
      (
      customerfamilyhistoryid number(10) CONSTRAINT customerfamilyhistoryid_pk PRIMARY KEY,
      firstname varchar2(50) NOT NULL,
      lastname varchar2(50) NOT NULL,
      age number(3),
      sibling varchar2(20),
      customerid number(7) NOT NULL
      );

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: