EVOLUTION-MANAGER

Edit File: update_fulltext.result

drop table if exists t1, t2, t3; create table t1 (c1 int primary key, c2 text, fulltext index (c2)) COMMENT = 'engine "innodb"'; insert into t1 values(10, "aa ii uu ee"); insert into t1 values(20, "ka ki ku ke"); insert into t1 values(30, "sa si su se"); select * from t1; c1 c2 10 aa ii uu ee 20 ka ki ku ke 30 sa si su se update t1 set c2="ta ti tu te" where c1=20; select * from t1; c1 c2 10 aa ii uu ee 20 ta ti tu te 30 sa si su se select * from t1 where match(c2) against("ti"); c1 c2 20 ta ti tu te select * from t1 where match(c2) against("ki"); c1 c2 update t1 set c1=40 where c1=20; select * from t1; c1 c2 10 aa ii uu ee 30 sa si su se 40 ta ti tu te select * from t1 where match(c2) against("ti"); c1 c2 40 ta ti tu te select * from t1 where match(c2) against("ki"); c1 c2 drop table t1;