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

Primary keys are not set to not null

    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: