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

Introduce sql_require_primary_key

    XMLWordPrintable

Details

    Description

      MySQL 8 introduced sql_require_primary_key.

      Similar option (global option, affecting all Engines, unlike innodb_force_primary_key) should be available on MariaDB too.

      MariaDB 10.1 introduced the innodb_force_primary_key variable, which forces InnoDB tables to have a primary key. Unfortunately, this doesn’t solve the replication problem if we use other storage engines.

      sql_require_primary_key from MySQL8 simply disallows to create tables without a primary key, or drop a primary key from an existing table.

      https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_sql_require_primary_key

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              acs-ferreira acsfer
              Votes:
              6 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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