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

ALTER TABLE require ALTER privilege on sequence from DEFAULT value expression

Details

    Description

      --source include/not_embedded.inc
       
      create user 'probsolvdbuser_dev'@'localhost';
      CREATE DATABASE problsolvdbdev;
      GRANT INSERT, UPDATE, ALTER ON problsolvdbdev.* TO 'probsolvdbuser_dev'@'localhost';
      USE problsolvdbdev;
      CREATE SEQUENCE seq_test START WITH 100 INCREMENT BY 10;
      CREATE TABLE action_1 (id int);
       
      connect (conn1,localhost,probsolvdbuser_dev,,problsolvdbdev,);
       
      alter table action_1 modify `id` int(11) NOT NULL DEFAULT nextval(`seq_test`);
       
      connection default;
      drop user  'probsolvdbuser_dev'@'localhost';
      drop databese problsolvdbdev;
      

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Vladislav Vaintroub made transition -
            Open Confirmed
            15d 3h 28m 1
            Vladislav Vaintroub made transition -
            Confirmed In Review
            1m 33s 1

            People

              sanja Oleksandr Byelkin
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.