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

SERIAL datatype creates UNIQUE KEY

    XMLWordPrintable

Details

    Description

      Hi,

      Currently the SERIAL data type makes a unique key.

      I assume Galera does not consider the first unique key to be the primary key (like InnoDB does). In this perspective it may make sense to let SERIAL create a primary key instead of unique key. Perhaps only when Galera is loaded, for backwards compatibility.

      Interesting in your insights about this issue,
      Cheers,
      Michael

      Attachments

        Activity

          People

            serg Sergei Golubchik
            michaeldg Michaël de groot
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.