EVOLUTION-MANAGER

Edit File: 4648.result

SET DEFAULT_STORAGE_ENGINE = 'tokudb'; DROP TABLE IF EXISTS t1; create table t1 ( c1 int not null auto_increment primary key, c2 varchar(128) not null , c3 int, unique index unique_c2 (c2) ) engine=tokudb collate=latin1_general_ci; insert into t1 (c1,c2) values (1,'THIS IS A TEST'); select c2 from t1; c2 THIS IS A TEST select * from t1; c1 c2 c3 1 THIS IS A TEST NULL update t1 set c2 = 'this is a test' where c1 = 1; select c2 from t1; c2 this is a test select * from t1; c1 c2 c3 1 this is a test NULL insert into t1 (c1,c2) values(2,'ttt'); update t1 set c2 = 'ttt' where c1 = 1; ERROR 23000: Duplicate entry 'ttt' for key 'unique_c2' DROP TABLE t1;