[MDEV-18799] Long unique does not work after failed alter table Created: 2019-03-03  Updated: 2019-04-02  Resolved: 2019-03-17

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Affects Version/s: 10.4
Fix Version/s: 10.4.4

Type: Bug Priority: Major
Reporter: Sachin Setiya (Inactive) Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

All

Issue Links:
Duplicate
duplicates MDEV-18891 ASAN heap-use-after-free in innobase_... Closed
Relates
relates to MDEV-18897 InnoDB indexes are inconsistent with ... Closed

 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...



 Comments   
Comment by Sachin Setiya (Inactive) [ 2019-03-03 ]

bb-10.4-serg

Generated at Thu Feb 08 08:46:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.