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

Long unique does not work after failed alter table

    XMLWordPrintable

Details

    Description

      create table t1(a blob unique , b blob);
      		 
      insert into t1 values(1,1),(2,1);
      		 
      --error ER_DUP_ENTRY
      		 
      alter table t1 add unique(b);
      		 
      --error ER_DUP_ENTRY
      		 
      insert into t1 values(1,1);
      		 
      # Cleanup
      		 
      DROP TABLE t1;


      CURRENT_TEST: main.abc
      		 
      mysqltest: At line 6: query 'insert into t1 values(1,1)' succeeded - should have failed with errno 1062...

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18891 ASAN heap-use-after-free in innobase_get_computed_value on concurrent DELETE from table with long index

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18897 InnoDB indexes are inconsistent with what defined in .frm for table

          • Major - Major loss of function.
          • Closed

          Activity

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              sachin.setiya.007 Sachin Setiya (Inactive)
              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.