全文索引在同一事务中不生效

begin

update phone set unique_er = 16523456789 where id = 662141370

select * from phone where match(unique_er) against (16523456789)

commit

插入数据之后，再根据全文索引查询是不可以的，只要修改过全文索引的相关字段，当前事务内使用全文索引搜索都会有问题。

begin;

update clientsa set unique_tel = 16523451787 where id = 3564321;

select * from clientsa where match(unique_card) against (370983199411225331);

commit;