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

Oracle DDL handle missing check constraint name

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 5.1.0.Final
    • 4.6.0.Final
    • Sequencers
    • None

    Description

      [StandardDdlParser] isTableConstraint already handles PK, FK and UNIQUE constraints with optional constraint names, but only handles CHECK with constraint name present.

      according to Oracle docs (https://docs.oracle.com/cd/B28359_01/server.111/b28286/clauses002.htm#CJAGIICD)

      • "... CONSTRAINT sth_name CHECK (check expr) ..." is handled correctly
      • "... CHECK (check expr) ..." is NOT handled correctly

      If the same applies to other DB dialects this should be fixed in StandardDdlParser otherwise the method should be overloaded in OracleDdlParser.

      Attachments

        Activity

          People

            hchiorean Horia Chiorean (Inactive)
            freakolowsky Jure Kajzer (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: