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

Online alter ignores check constraint violation

    XMLWordPrintable

Details

    Description

      --source include/have_debug_sync.inc
       
      create table t (a int);
      insert into t values (1),(2);
      --send
        set debug_sync= 'now wait_for downgraded';
       
      --connect (con_alter,localhost,root,,test)
      set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit';
      --send
        alter table t add check (a<10), algorithm=copy, lock=none;
       
      --connection default
      --reap
      insert into t values (11),(12);
      set debug_sync= 'now signal goforit';
       
      --connection con_alter
      --reap
      show create table t;
      select * from t;
       
      # Cleanup
      drop table t;
      set debug_sync= reset;
      

      bb-10.10-MDEV-16329 49ad87590

      connection con_alter;
      show create table t;
      Table	Create Table
      t	CREATE TABLE `t` (
        `a` int(11) DEFAULT NULL,
        CONSTRAINT `CONSTRAINT_1` CHECK (`a` < 10)
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1
      select * from t;
      a
      1
      2
      11
      12
      

      Either INSERT or ALTER should fail.

      Attachments

        Issue Links

          Activity

            People

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