drop table if exists t1, t2, t3;
create table t1 (c1 int primary key, c2 int) COMMENT 'engine = "innodb"';
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` int(11) DEFAULT NULL,
  PRIMARY KEY (`c1`)
) ENGINE=mroonga DEFAULT CHARSET=latin1 COMMENT='engine = "innodb"'
insert into t1 values (1, 100);
insert into t1 values (2, 101);
insert into t1 values (3, 102);
insert into t1 values (4, 102);
select * from t1;
c1	c2
1	100
2	101
3	102
4	102
delete from t1 where c1=3;
select * from t1;
c1	c2
1	100
2	101
4	102
flush tables;
delete from t1 where c1=2;
select * from t1;
c1	c2
1	100
4	102
delete from t1;
select * from t1;
c1	c2
drop table t1;
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
select * from t1 where match(c2) against("ki");
c1	c2
20	ka ki ku ke
delete from t1 where c1=20;
select * from t1;
c1	c2
10	aa ii uu ee
30	sa si su se
select * from t1 where match(c2) against("ki");
c1	c2
drop table t1;
