Tetsuro IKEDA
null+****@clear*****
Thu Oct 4 10:20:35 JST 2012
Tetsuro IKEDA 2010-04-06 18:37:22 +0900 (Tue, 06 Apr 2010) New Revision: 95fd8f05bf16028c7a333baeb8c1cbaf60a65a35 https://github.com/mroonga/mroonga/commit/95fd8f05bf16028c7a333baeb8c1cbaf60a65a35 Log: upgrade testcase for fulltext. Added files: test/sql/r/fulltext.result test/sql/t/fulltext.test Added: test/sql/r/fulltext.result (+28 -0) 100644 =================================================================== --- /dev/null +++ test/sql/r/fulltext.result 2010-04-06 18:37:22 +0900 (7c6f64c) @@ -0,0 +1,28 @@ +install plugin mroonga soname 'libmroonga.so'; +set storage_engine=mroonga; +drop table if exists t1, t2, t3; +create table t1 (c1 int primary key, c2 text, fulltext index ft (c2)); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + `c2` text, + PRIMARY KEY (`c1`), + FULLTEXT KEY `ft` (`c2`) +) ENGINE=mroonga DEFAULT CHARSET=latin1 +insert into t1 values (1, "hoge hoge"); +insert into t1 values (2, "fuga fuga"); +insert into t1 values (3, "moge moge"); +select * from t1; +c1 c2 +1 hoge hoge +2 fuga fuga +3 moge moge +flush tables; +select * from t1; +c1 c2 +1 hoge hoge +2 fuga fuga +3 moge moge +drop table t1; +uninstall plugin mroonga; Added: test/sql/t/fulltext.test (+19 -0) 100644 =================================================================== --- /dev/null +++ test/sql/t/fulltext.test 2010-04-06 18:37:22 +0900 (6c14665) @@ -0,0 +1,19 @@ +--disable_warnings +install plugin mroonga soname 'libmroonga.so'; +set storage_engine=mroonga; +drop table if exists t1, t2, t3; +--enable_warnings + +create table t1 (c1 int primary key, c2 text, fulltext index ft (c2)); +show create table t1; +insert into t1 values (1, "hoge hoge"); +insert into t1 values (2, "fuga fuga"); +insert into t1 values (3, "moge moge"); +select * from t1; +flush tables; +select * from t1; +drop table t1; + +--disable_warnings +uninstall plugin mroonga; +--enable_warnings -------------- next part -------------- HTML����������������������������...Download