Skip to content

Unique Key on ParentId, Key #158

Open
Open

Description

@JeremyCaney

While rare, occasionally a duplicate key is submitted to the database, primarily when generating keys from e.g., forms. While it's unclear how this is happening, the cost is significant as it corrupts the database and prevents it from reloading. Given that, independent of the cause, we should add a unique key in SQL to ParentId and Key to prevent this from corrupting the data integrity.

Activity

  1. added this to the OnTopic 5.3.0 milestone on Oct 13, 2026
  2. self-assigned this
    on Oct 13, 2026
  3. added theissue type on Oct 13, 2026
  4. added
    Type: BugBehavior that is inconsistent with documented or expected behavior.
    Area: SQLRelates to the SQL Server database objects; do not use for the repository.
    on Oct 13, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Area: SQLRelates to the SQL Server database objects; do not use for the repository.Priority: 0Status 2: ScheduledPlanned for an upcoming release.Type: BugBehavior that is inconsistent with documented or expected behavior.

Type

Projects

No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions