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

Oracle DDL handle missing check constraint name

XMLWordPrintable

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

      [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.

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

                Created:
                Updated:
                Resolved: