Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-10974

openidm.objecttypes.objecttype definition not consistent across DBs

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: OpenIDM 5.5.0.3
    • Fix Version/s: 6.5.0
    • Component/s: _Schema
    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      1
    • Sprint:
      OpenIDM Sprint 6.5-3
    • Support Ticket IDs:

      Description

      IDM 6.0, 5.x, 4.x.

      In the openidm.objecttypes table (in db/scripts/openidm.sql), the column "objecttype" is defined differently for different DBs.

      E.g.
      for mssql and db2, the column is defined as "NOT NULL";
      for mysql, it is "NULL";
      for postgres, it is "DEFAULT NULL".

       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              emanuel.brici Emanuel Brici
              Reporter:
              wei-yee.lum Wei-Yee Lum
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: