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

ALTER TABLE fails when a stored virtual column is dropped and added

Details

    Description

      Test case

      --source include/have_innodb.inc
      --source include/have_debug_sync.inc
       
      create table t1 (a char(9), b char(9) as (a) stored) engine=InnoDB;
      insert into t1 values ('foobar');
       
      --send
        set debug_sync= 'now wait_for downgraded';
       
      --connect(con1,localhost,root,,)
      set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit';
      --send 
      alter ignore table t1 drop b, add b char(3) as (a) stored, algorithm=copy, lock=none
       
      --connection default
      --reap
      update t1 set a = 'foobarqux';
      set debug_sync= 'now signal goforit';
       
      --connection con1
      --reap  
       
      # Cleanup
      drop table t1;
      set debug_sync= reset;
      

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Nikita Malyavin made transition -
            Open In Progress
            39s 1
            Nikita Malyavin made transition -
            In Progress In Testing
            5h 14m 1
            Nikita Malyavin made transition -
            In Testing Stalled
            8s 1
            Sergei Golubchik made transition -
            In Review Stalled
            2d 19h 42m 1
            Nikita Malyavin made transition -
            Stalled In Review
            6d 4h 10m 2
            Sergei Golubchik made transition -
            In Review In Testing
            3d 18h 6m 1
            Sergei Golubchik made transition -
            In Testing Closed
            394d 22h 17m 1

            People

              nikitamalyavin Nikita Malyavin
              nikitamalyavin Nikita Malyavin
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.