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

sequences are not quite durable in the presense of crashes

Details

    Description

      This test case

      --source include/have_innodb.inc
      		 
       
      		 
      create sequence t1 engine=innodb;
      		 
      select next value for t1;
      		 
      select next value for t1;
      		 
      --source include/kill_mysqld.inc
      		 
      --source include/start_mysqld.inc
      		 
      select next value for t1;
      		 
      drop sequence t1;

      shows

      create sequence t1 engine=innodb;
      		 
      select next value for t1;
      		 
      next value for t1
      		 
      1
      		 
      select next value for t1;
      		 
      next value for t1
      		 
      2
      		 
      # Kill the server
      		 
      # restart
      		 
      select next value for t1;
      		 
      next value for t1
      		 
      1
      		 
      drop sequence t1;

      That is, sequence updates aren't always durable

      Attachments

        Activity

          People

            serg Sergei Golubchik
            serg Sergei Golubchik
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.