Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5335

Force PK option

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.0
    • None
    • None

    Description

      Have an option to force PK for (innodb) tables.

      Forcing is quite easy (a poc from 2011):
      http://linsenraum.de/erkules/2011/03/this-table-type-requires-a-primary-key.html
      Why?
      RBR and so Galera would benefit from such an option.

      From my point of view a lot of DBA's would love it

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8582 innodb_force_primary_key option does not force PK or unique key

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link Bug #69845 Provide an option to prevent creation of tables without a unique/PK

          Web Link TokuDB - Race in secondary index query (when no PK exists)

          Activity

            People

              jplindst Jan Lindström (Inactive)
              erkules erkan yanar
              Votes:
              6 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.