EVOLUTION-MANAGER

Edit File: 4618.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, index key_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 drop table if exists t1; create table t1 ( c1 int not null auto_increment primary key, c2 varchar(128) not null , index key_c2 (c2) ) engine=tokudb collate=latin1_general_cs; 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 1 THIS IS A TEST 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 1 this is a test drop table t1; CREATE TABLE t1 (a char(2) not null primary key, b varchar(20) not null, key (b))engine=TokuDB; INSERT INTO t1 values ('AB','MySQLAB'),('JA','Sun Microsystems'),('MS','Microsoft'),('IB','IBM- Inc.'),('GO','Google Inc.'); select * from t1; a b GO Google Inc. IB IBM- Inc. MS Microsoft AB MySQLAB JA Sun Microsystems update t1 set t1.a=LCASE(t1.a); select * from t1; a b go Google Inc. ib IBM- Inc. ms Microsoft ab MySQLAB ja Sun Microsystems drop table t1; create table t1 (a char(2) not null, b varchar(20) not null); INSERT INTO t1 values ('AB','MySQLAB'),('JA','Sun Microsystems'),('MS','Microsoft'),('IB','IBM- Inc.'),('GO','Google Inc.'); select * from t1; a b AB MySQLAB JA Sun Microsystems MS Microsoft IB IBM- Inc. GO Google Inc. update t1 set t1.a=LCASE(t1.a); select * from t1; a b ab MySQLAB ja Sun Microsystems ms Microsoft ib IBM- Inc. go Google Inc. DROP TABLE t1;