diff options
Diffstat (limited to '')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/wrapper/r/delete_TODO_SPLIT_ME.result | 55 |
1 files changed, 55 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/delete_TODO_SPLIT_ME.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/delete_TODO_SPLIT_ME.result new file mode 100644 index 00000000..99053762 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/delete_TODO_SPLIT_ME.result @@ -0,0 +1,55 @@ +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; |