Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-4597

Primary keys are not set to not null

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.7
    • Fix Version/s: 1.9.8
    • Component/s: Database
    • Security Level: Default (Default Security Scheme)
    • Labels:
      None

      Description

      Imagine a user writes a script to insert a row into the table category_node. While the primary key keeps the table from having duplicate keys this doesn't prevent a record from having a null key and since null isn't checked you could also end up with duplicate rows where the key is NULL and the other column(s) are identical. This NOT NULL constraint should be set on all Primary Key columns.

        Attachments

          Activity

            People

            Assignee:
            ranger Benjamin Reed
            Reporter:
            david David Hustace
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: