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

LevelDB: Support AUTO_INCREMENT

    XMLWordPrintable

Details

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

    Description

      For start, support AUTO_INCREMENT in a very basic way:

      Maintain next_free_value number

      • When opening the table, load it from the index
      • Increase it whenever anybody reserves AUTO_INCREMENT values (regardless of whether they use them or not. InnoDB doesn't guarantee continutity, either)
      • Also increase when writing a record: if (new_record.pk > next_free_value) { next_free_value= new_record.pk+1; }

      next_free_value can be stored in TABLE_SHARE.

      MyISAM supports auto_increment for columns that are not at key start. We will not support this.

      InnoDB does some tricks related to binary logging. We will not do this.

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              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.