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

            Activity

              People

              Assignee:
              sachin.setiya.007 Sachin Setiya
              Reporter:
              sachin.setiya.007 Sachin Setiya
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: