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

Sequence gets corrupted and produces ER_KEY_NOT_FOUND (Can't find record) after ALTER .. ORDER BY

    XMLWordPrintable

Details

    Description

      CREATE SEQUENCE s;
      		 
      ALTER TABLE s ORDER BY cache_size;
      		 
      SELECT NEXTVAL(s);
      		 
       
      		 
      DROP SEQUENCE s;

      10.3 765ae6e8

      		 
      mysqltest: At line 3: query 'SELECT NEXTVAL(s)' failed: 1032: Can't find record in 's'

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19977 Assertion `(0xFUL & mode) == LOCK_S || (0xFUL & mode) == LOCK_X' failed in lock_rec_lock

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22927 ER_KEY_NOT_FOUND or Assertion `(0xFUL & mode) == LOCK_S || (0xFUL & mode) == LOCK_X' failed upon sequence operations

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16397 ER_KEY_NOT_FOUND upon attempt to LOAD DATA into sequence

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19303 Valgrind warnings about uninitialised values in dtuple_validate or mi_rrnd or ma_rrnd upon UPDATE/DELETE .. ORDER BY from sequence

          • Major - Major loss of function.
          • Open

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              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.