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

CREATE SEQUENCE failed with innodb_force_primary_key =1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.3(EOL)
    • 10.3.11
    • Sequences
    • None

    Description

      SEQUENCE can't created with innodb_force_primary_key =1

      set global innodb_force_primary_key =1;
       
      CREATE SEQUENCE s2 START WITH 100 INCREMENT BY 10;
      

      Create with a key or alter is not possible, because
      "SQL Error (4086) Seqeuence s2 table structure is invalid
      (Sequence tables cannot have any keys"

      Only workaround is

      set global innodb_force_primary_key =0;

      and create the sequence.

      Attachments

        Activity

          People

            monty Michael Widenius
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.