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

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: